CSC 4402 20091019

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

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