04-design-notes

04-design-notes - 1 Relational Database Design Part II CPS...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 Relational Database Design Part II CPS 116 Introduction to Database Systems 2 Announcements (Tue. Sep. 13) Homework #1 due in one week You should have started by now Course project description available! Choice of standard or open Team of size 1-4, but 1- and 4-person teams need approval from me Two milestones + demo/report Milestone #1 due in one month, right after fall break 3 Database design steps: review Understand the real-world domain being modeled Specify it using a database design model (e.g., E/R) Translate specification to the data model of DBMS (e.g., relational) Create DBMS schema ) Next: translating E/R design to relational schema 2 4 E/R model: review Entity sets Keys Weak entity sets Relationship sets Attributes on relationships Multiplicity Roles Binary versus N-ary relationships Modeling N-ary relationships with weak entity sets and binary relationships ISA relationships 5 Translating entity sets An entity set translates directly to a table Attributes columns Key attributes key columns Students Courses CID title Enroll SID name grade Student ( SID , name ) Course ( CID , title ) 6 Translating weak entity sets Remember the borrowed key attributes Watch out for attribute name conflicts Building ( building_name , year ) Rooms ( building_name , room_number , capacity ) Seats ( building_name , room_number , seat_number , left_or_right ) Rooms In Buildings name year number capacity In Seats number L/R? 3 7 Translating relationship sets...
View Full Document

Page1 / 6

04-design-notes - 1 Relational Database Design Part II CPS...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online