Database Design Concept

Table of Contents

Entity Relationship Diagram1

Entities and Attributes1

Relationships1

Artist Database ERD and Tables3

General Rules Governing Relationships Among Tables3

Normalization Rules6

The Need for Normalization6

Conversion to 1NF7

Conversion to 2NF8

Conversion to 3NF9

Boyce-Codd Normal Form (BCNF)10

Database Design11

Changing Data into Information11

The Information System11

Systems Development Life Cycle12

Database Lifecycle (DBLC)13

Phase 1: Database Initial Study13

Phase 2: Database Design14

Phase 3: Implementation and Loading16

Phase 4: Testing and Evaluation16

Phase 5: Operation17

Phase 6: Maintenance and Evaluation17

DB Design Strategy Notes17

Centralized vs. Decentralized Design17

Database Management System17

Installation and Uninstallation of Oracle Database Server18