{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cs411-05-reldesign - CS411 Database Systems 05 Relational...

Info icon This preview shows pages 1–17. Sign up to view the full content.

View Full Document Right Arrow Icon
1 CS411 Database Systems 05: Relational Schema Design
Image of page 1

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

View Full Document Right Arrow Icon
2 Why Do We Learn This?
Image of page 2
3 Motivation We have designed ER diagram, and translated it into a relational db schema R = set of R1, R2, ... Now what? We can do the following – specify all relevant constraints over R – implement R in SQL – start using it, making sure the constraints always remain valid However, R may not be well-designed, thus causing us a lot of problems
Image of page 3

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

View Full Document Right Arrow Icon