Wachtwoord vergeten?
Database theory
- 1. What is a database?
- 2. Database management systems
- 3. The layers of data abstraction (simplify this)
- 4. Flat files and the relational model
- 5. Conceptual database design
- 6. Physical database design
- 7. Accessing the data
1. What is a database?
Simple introduction - database is simply a store of data or 'A collection of interrelated data items that are managed as a single unit', filing cabinets to electronic data stores.
2. Database management systems
What do these do, HSQLDB as a DBMS
3. The layers of data abstraction (simplify this)
3.1. The physical layer
How the data is stored on disc
3.2. The logical layer
An abstract data structure
3.3. The external layer
How the user interacts with the data structure. OpenOffice does this.
3.4. Physical data independence
The data structure is independent of the software that accesses it.
4. Flat files and the relational model
Discuss these and say what problems the relational model is designed to solve (redundancy, inconsistency etc.)
5. Conceptual database design
The design process
5.1. Entities
5.2. Attributes
5.3. Relationships
5.3.1. One to one
5.3.2. One to many
5.3.3. Many to many
6. Physical database design
6.1. Tables
6.2. Columns and data types
6.3. Constraints
6.3.1. Primary keys
6.3.2. foreign keys
6.3.3. Referential integrity
7. Accessing the data
7.1. Queries
7.2. Forms
7.3. Reports
