Quiz 2 CH2

Question 1

What does the term ‘attribute’ refer to in data modeling?

Answer 1

A characteristic of an entity

Question 2

What does a constraint in a data model usually specify?

Answer 2

Rules or restrictions on data values

Question 3

Which notation uses a three-pronged symbol to represent the “many” sides of a relationship in ER diagram?

Answer 3

Crow’s foot notation

Question 4

Which emerging data model is best suited for managing large amounts of web and sensor-generated data?

Answer 4

NoSQL

Question 5

Which model in DBMS architecture is described as software-dependent but hardware-independent?

Answer 5

The Internal Model

Question 6

Which model in DBMS architecture is concerned with describing how data is stored on storage media such as disks or tapes?

Answer 6

The Physical Model

Question 7

What does a business rule establish in database design?

Answer 7

Relationships and constraints between entities

Question 8

Which data model was developed by E.F. Codd in 1970?

Answer 8

Relational Model

Question 9

What is a key benefit of the relational model?

Answer 9

Easy to design and manage

Question 10

What does the physical model of a database describe?

Answer 10

The actual storage details on hardware