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
0
Kenneth, O. & Kenneth, B (2020). Database Design Concept. Afribary. Retrieved from https://afribary.com/books/unit-1-database-design-concept
Kenneth, Ohior, and B. Kenneth "Database Design Concept" Afribary. Afribary, 07 Jul. 2020, https://afribary.com/books/unit-1-database-design-concept. Accessed 11 Jul. 2025.
Kenneth, Ohior, and B. Kenneth . "Database Design Concept". Afribary, Afribary, 07 Jul. 2020. Web. 11 Jul. 2025. < https://afribary.com/books/unit-1-database-design-concept >.
Kenneth, Ohior and Kenneth, B. . "Database Design Concept" Afribary (2020). Accessed July 11, 2025. https://afribary.com/books/unit-1-database-design-concept