IT360 Applied Database Systems Entity-Relationship Model Chapter - PDF document

IT360 – Applied Database Systems Entity-Relationship Model Chapter 5 in Kroenke Database Design Process 1

Entity-Relationship Model Example ER Model - Entities • Entities • Attributes • Identifiers • Entity class vs. entity instance 2

Exercise: IT360 Database • Draw ER diagram for a database used to manage IT360 class (at least 3 entities) – Specify entities, attributes, identifiers ER Model – HAS-A Relationships • Degree • Max cardinality • Min cardinality • Identifying vs non-identifying 3

Exercise: IT360 Database • Draw ER diagram for a database used to manage IT360 class (at least 3 entities) – Specify entities, attributes, identifiers – Specify relationships – Specify cardinalities for relationships ER Model – Is-A Relationship 4

Exercise: The College Report Exercise: The Department Report 5

Exercise: The Department Major Report Exercise: The Student Acceptance Letter 6

Members, Lockers 7

Suppliers, Parts, Prices Price column 8

Association Class Entity vs. Attribute 9

Multi-valued Attribute  Entity 1:N Recursive Relationship 10

Drug Warehouse • Drugwarehouse.com has offered you a free life- time supply of prescription drugs (no questions asked) if you design its database schema. Given the rising cost of health care, you agree. Here is the information that you gathered: • Patients are identified by their SSN, and we also store their names and age • Doctors are identified by their SSN, and we also store their names and specialty • Each patient has one primary care physician • Each doctor has at least one patient ER Summary 11