Analyze supertype erd subset publisher database erd

Assignment 3: Database Design and Data Modeling
Student Name
Due Date:
IT525-01 Database Design and Data Modeling
Professor:
Purdue Global University

Running Head: Assignment 3: Database Design and Data Modeling 2

Example: child sex entity can lead into female-male
Composite Key – consists of more than one attribute to identify an entity occurrence e.

Example: Entity New York City and the composite key could be Manhattan and Wall Street f. Total Completeness – every Supertype occurrence must be a member of at least one subtype.

Running Head: Assignment 3: Database Design and Data Modeling 3

Question 2. Analyze a Supertype/Subtype ERD (a subset of a Publisher database ERD)

Running Head: Assignment 3: Database Design and Data Modeling 5

References

Coronel, C., & Morris, S., (2017). Database Systems: Design, Implementation, and Management.