Unit 8: Databases

8.1 Database Concepts

1 Show understanding of the limitations of using a file-based approach for the storage and retrieval of data

2 Describe the features of a relational database that address the limitations of a file-based approach

3 Show understanding of and use the terminology associated with a relational database model

4 Use an entity-relationship (E-R) diagram to document a database design

5 Show understanding of the normalisation process

6 Explain why a given set of database tables are, or are not, in 3NF

7 Produce a normalised database design for a description of a database, a given set of data, or a given set of tables

8.2 Database Management Systems (DBMS)

1 Show understanding of the features provided by a Database Management System (DBMS) that address the issues of a file based approach

2 Show understanding of how software tools found within a DBMS are used in practice

8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)

1 Show understanding that the DBMS carries out all creation/modification of the database structure using its Data Definition Language (DDL)

2 Show understanding that the DBMS carries out all queries and maintenance of data using its DML

3 Show understanding that the industry standard for both DDL and DML is Structured Query Language (SQL)

4 Understand given SQL (DDL) statements and be able to write simple SQL (DDL) statements using a sub-set of statements

5 Write an SQL script to query or modify data (DML) which are stored in (at most two) database tables