Please enable JavaScript.
Coggle requires JavaScript to display documents.
CHAPTER 9: DATA DESIGN - Coggle Diagram
CHAPTER 9: DATA DESIGN
concepts
data structures
-Each file or table contains data about people, places, things or events that interact with the information system
database management system (DBMS)
-a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database
advantages DBMS is offers timely, interactive, and flexible data access
components
Interfaces for Users, Database Administrators, and Related Systems
-
-
-
-
-
-
Normalization
-
Second Normal Form
A table design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are functionally dependent on the entire primary key
Third Normal Form
3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs
-
-