Database Design Concept

Table of Contents

Entity Relationship Diagram 1

Entities and Attributes 1

Relationships 1

Artist Database ERD and Tables 3

General Rules Governing Relationships Among Tables 3

Normalization Rules 6

The Need for Normalization 6

Conversion to 1NF 7

Conversion to 2NF 8

Conversion to 3NF 9

Boyce-Codd Normal Form (BCNF) 10

Database Design 11

Changing Data into Information 11

The Information System 11

Systems Development Life Cycle 12

Database Lifecycle (DBLC) 13

Phase 1: Database Initial Study 13

Phase 2: Database Design 14

Phase 3: Implementation and Loading 16

Phase 4: Testing and Evaluation 16

Phase 5: Operation 17

Phase 6: Maintenance and Evaluation 17

DB Design Strategy Notes 17

Centralized vs. Decentralized Design 17

Database Management System 17

Installation and Uninstallation of Oracle Database Server 18