SLIDE 1
2
Entity-Relationship Model Example ER Model - Entities
- Entities
- Attributes
- Identifiers
- Entity class vs. entity instance
IT360 Applied Database Systems Entity-Relationship Model Chapter - - PDF document
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
SLIDE 2
SLIDE 3
3
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
SLIDE 4
4
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
SLIDE 5
5
Exercise: The College Report Exercise: The Department Report
SLIDE 6
6
Exercise: The Department Major Report Exercise: The Student Acceptance Letter
SLIDE 7
7
Members, Lockers
SLIDE 8
8
Suppliers, Parts, Prices
Price column
SLIDE 9
9
Association Class Entity vs. Attribute
SLIDE 10
10
Multi-valued Attribute Entity 1:N Recursive Relationship
SLIDE 11
11
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