You are here: Home / / English / Userguide3 / Base3 / Database theory

Database theory

1. What is a database?
2. Database management systems
3. The layers of data abstraction (simplify this)
3.1. The physical layer
3.2. The logical layer
3.3. The external layer
3.4. Physical data independence
4. Flat files and the relational model
5. Conceptual database design
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

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


Legal Disclaimers and Limitations | Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0. License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License v2.0.

"LibreOffice" and "The Document Foundation" are registered trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.