Entities and Attributes

Winter 2023 Midterm Exam
As you now know, the logical database model contains the key information that
defines how the eventual database will meet business requirements. It provides a
high-level view of the database that you can present to key project stakeholders
during the early stages of the database development.
Submit your answer to the following questions in pdf format. Your submission
should not exceed 5 pages.
A. Write an essay explaining the following:
1. Entities
2. Attributes
a. Data types
b. Primary and foreign keys
3. Entity and referential integrity
B. Discuss how relationships are designed in the logical model. Be sure to say
something about:
1. Relationship typeszN, 1:M, 1:1
2. Identifying versus non-identifying relationships
3. Optional versus mandatory relationships
4. Cardinality
5. Subtypes and supertypes

Purchase answer to see full
attachment