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
Ohior, K (2020). Database Design Concept. Afribary.com: Retrieved March 07, 2021, from https://afribary.com/works/unit-1-database-design-concept
Kenneth, Ohior. "Database Design Concept" Afribary.com. Afribary.com, 07 Jul. 2020, https://afribary.com/works/unit-1-database-design-concept . Accessed 07 Mar. 2021.
Kenneth, Ohior. "Database Design Concept". Afribary.com, Afribary.com, 07 Jul. 2020. Web. 07 Mar. 2021. < https://afribary.com/works/unit-1-database-design-concept >.
Kenneth, Ohior. "Database Design Concept" Afribary.com (2020). Accessed March 07, 2021. https://afribary.com/works/unit-1-database-design-concept