K201 CHAPTER 5
Byte
A character of data
Database
A self-describing collection of integrated records
What is a database?
A self-describing collection of integrated records
How is a data model transformed into a database design?
By defining foreign keys
Database Application
Collection of forms, reports, queries, and application programs that process a database
A Key (Primary Key)
Column or group of columns that identifies a unique row in a table
Metadata
Data that describes data
Relational Databases
Databases that carry their data in the form of tables that represent relationships using foreign keys
Personal DMBS
Designed for smaller, simpler database applications
Foreign Keys
Keys of a different (foreign) table than the one in which they reside
Enterprise DBMS
Process large organizational and work group databases
Normalization
Process of converting a poorly structured table into two or more well structured tables
Database Management System (DBMS)
Program used to create, process and administer a database
Database Application System
Systems that make database data more accessible and useful
How are data models used for database development?
They describe the data and relationships that will be stored in the database
How do database applications make databases more useful?
They make data more accessible and purposeful
What is the purpose of a database?
To keep track of things
What are the components of a database application system?
User (you), Database Application (forms, reports, queries, application and programs), DBMS and Database (tables, relationships and metadata
What is the users' role in the development of databases?
Users should review and approve the data model