Skip to main content

Quiz: Chapter 02 Data Models

 Review link: https://quizlet.com/764523499/quiz-chapter-02-data-models-flash-cards/

Which of the following is a fundamental data modeling component, helping ensure data integrity?

a. Relationship

b. Entity

c. Attribute

d. Constraint

Hide Feedback

Correct

 

Which of the following is not a valid business rule?

a. An invoice can only be paid to one customer.

b. An invoice must be paid in a reasonable amount of time.

c. An invoice may have many items.

d. A customer must reside in the USA.

Hide Feedback

Correct

 

 

Why is identifying and documenting business rules essential to database design?

a. It allows the user to understand relationship participation rules and constraints.

b. It allows the designer to manage business processes.

c. It can be a communication tool between users and managers.

d. It helps to standardize the company's view of data.

Hide Feedback

Correct

 

 

Which of the following two-dimensional structures is known as a relation?


b. Entity

c. Table

d. File

 

Hide Feedback

Correct

 

In an entity relational model (ERD), what is each row in a table known as?

a. An entity set

b. An entity tuple

c. An entity occurrence

d. An entity relation

Hide Feedback

Correct

 

Which of the following is a disadvantage of various database models?

a. Database security

b. Visual modeling

c. System complexity

d. Data sharing

Hide Feedback

Correct

 

Which of the following entity relationship (ER) connectivity statements is invalid?

a. A CUSTOMER gender is MALE or FEMALE

b. PAINTER paints many PAINTINGs

c. An EMPLOYEE learns many SKILLs

d. An EMPLOYEE manages a STORE

Hide Feedback

Correct

Which of the following is not a valid component of object-oriented data models?

a. Object

b. Volume

c. Attributes

d. Class

Hide Feedback

Correct

A CEO of a company wants to find a new and improved way to manage and extract business insights from large amounts of web- and sensor-generated data. Which of the following could they use to achieve this goal?

a. The 3Vs

b. The internet of Things (IoT)

c. Hadoop

d. Big data

Hide Feedback

Correct

 

Which of the following technologies is not used in Big Data?

a. Hadoop

b. NoSQL

c. SQL

d. MapReduce

Hide Feedback

Correct

 

Labels:

Comments

Post a Comment

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
Post a Comment
Read more

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What is the process called where missing data is fixed? a). Imputing   2. According to the instructor
Post a Comment
Read more