|
Module 9 Database
|
|
|
- Database design
- Normalisation and data modelling
- Methods and tools for analysing and implementing database design
- Database management system (DBMS)
- Use of Structured Query Language (SQL)
Candidates should be able to:
- describe flat files and relational databases, explaining the differences between them;
- design a simple relational database to the third normal form (3NF), using entity- relationship (E-R) diagrams and decomposition;
- define and explain the purpose of primary, secondary and foreign keys;
- describe the structure of a DBMS including the function and purpose of the data dictionary, data description language (DDL) and data manipulation language (DML);
- use SQL to define tables and views, insert, select and delete data and to produce reports.
Questions you should know the answers to:
- What is a flat file database?
- What is a Relational database?
- What does Referential Integrity mean?
- What do these terms mean in the context of Databases:
- Entity
- Attribute
- Table
- Field
- Record
- Primary Key
- Foreign Key
- Composite Key
- Validation
- What is an Entity Relationship Diagram?
- A hotel stores details of its Guests, Rooms and Reservations. Draw an Entity Relationship diagram for this system.
- What does DBMS stand for and what does it do?
- What is SQL?
- Find out about how to structure statements in SQL for:
- Creating a new table
- Viewing a table
- Inserting data in a table
- Selecting data from tables
- Deleting data from a table
- Creating reports
|