Chapters 15

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