Download
chapters 15 16 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Chapters 15 &16 PowerPoint Presentation
Download Presentation
Chapters 15 &16

Chapters 15 &16

157 Views Download Presentation
Download Presentation

Chapters 15 &16

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Chapters 15 &16 Conceptual and Logical Database Design Methodology

  2. Agenda • Definition • Conceptual database design • Relational database - logical design • Example

  3. Definition • Design methodology • Structured design approach using procedures, techniques, tools and documentation aids • Conceptual database design • Constructing an information model, independent from all physical consideration for an enterprise • Logical database design • Building an organization database based on a specific data model

  4. Conceptual Database Design • Entities • Relationships • Attributes (simple, no composite, no derived) • Attribute domains • Primary and candidate key attributes • Minimal set of attributes • Less change • Uniqueness in the future • Fewest characters • Easy to use by users

  5. Relational Database - Logical Design • Draw ER model • Review • Always binary with1 to many relationship • No complex relationship • No redundant relationship • No recursive relationship • No relationship with attribute(s)

  6. Relational Database - Logical Design • Normalize relations • Primary key • Foreign key • BCNF • Add constraints • Domain & enterprise • Referential • Entity • legal

  7. Relational Database - Logical Design • Review • Organization current & future needs • All user current & future requirements • Normalization (Boyce-Codd) • Relationship (one-to-one or one-to-many) • Redundancy • Constraints • User approval • Document

  8. Points To Remember • Definition • Conceptual database design • Relational database - logical design • Example

  9. Assignment • Review chapters 5-6, 11-16 • Read chapters 17-18 • Work on group project • E-R and normalized database due date: