**1. What is a database model? **
a) A representation of the applications that interfaces with a database
b) A representation of the logical structure of a database ← Correct
c) A representation of unstructured data
d) A collection of sql queries performed against a database
Explanation:
A database model represents the logical structure of a database. This includes how data is stored and organized.
Objective
Understand: Explain what a model is in the context of a database
Covered in:
Modeling Data Relationships
2. Which database model best represents a library system, its members, and its books?
a)
b)
c)
d) None of the above
Explanation:
The diagram in a) best describes a simple library system. The three tables are: library, member, and book. The relationship between the library and book tables is a one to many relationship. A library can have many books. The relationship between the member and book tables is also a one to many relationship. A member can borrow many books.
Objective
Apply: Explain with a diagram of a database model given a verbal description
Create: Explain with a diagram of your own database model given these constraints
Apply: Create an ORM diagram to show relationships between data
Covered in:
Modeling Data Relationships