Database Design Concept

Ohior Kenneth B. Kenneth 20 PAGES (2587 WORDS) Text Book
Subscribe to access this work and thousands more

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



Subscribe to access this work and thousands more
Overall Rating

0

5 Star
(0)
4 Star
(0)
3 Star
(0)
2 Star
(0)
1 Star
(0)
APA

Ohior, K (2020). Database Design Concept. Afribary.com: Retrieved December 05, 2020, from https://afribary.com/works/unit-1-database-design-concept

MLA 8th

Kenneth, Ohior. "Database Design Concept" Afribary.com. Afribary.com, 07 Jul. 2020, https://afribary.com/works/unit-1-database-design-concept . Accessed 05 Dec. 2020.

MLA7

Kenneth, Ohior. "Database Design Concept". Afribary.com, Afribary.com, 07 Jul. 2020. Web. 05 Dec. 2020. < https://afribary.com/works/unit-1-database-design-concept >.

Chicago

Kenneth, Ohior. "Database Design Concept" Afribary.com (2020). Accessed December 05, 2020. https://afribary.com/works/unit-1-database-design-concept