CSC 4402 20091019

CSC 4402 20091019 - • Conceptual design(E-R modeling and...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC 4402 10/19/2009 Page 1 of 1 Get lectures notes on “Logical Design of Relational Databases” from Info desk in the Union. No relational algebra on the final!! Part IV – Database Design Chapter 6 – E-R modeling and Dr. Chen’s lecture notes on logical design of relational databases, and Chapter 7 (for reference purposes). Chapter 6 – E-R design process DB design process User requirement specification
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: • Conceptual design (E-R modeling and E-R diagram) • Functional requirements • Final stage o Logical design o Physical design Major pitfalls in DB design • Redundancy • Incompleteness Main concepts: • Entities o Instance is an individual object o Type or set the entity belongs to • Attributes • Relationships • Subtype, supertype...
View Full Document

Ask a homework question - tutors are online