Higher+DBMS+Assessment

In order to pass the Relational Databases Systems unit at Higher, you must complete the following assessment tasks:

Use the Library System project for this assessment


 * 1. Design of data tables from source document**
 * produce a data dictionary for the table


 * 2. Normalisation of data to 3NF**
 * normalise the data given as UNF and convert to 3NF


 * 3. Creation of database (including interface) from design**
 * use the DBMS to create the relationships (take a screenshot)
 * build the database


 * 4. Implementation of complex queries**
 * sort the books by Publisher Name (ascending) and for books with the same publisher Catalogue Number (descending)
 * produce a summary which calculates (sum) the total number of copies of all books
 * devise your own query which searches two fields across different tables
 * provide screenshot evidence of all queries


 * 5. Implementation of macros/scripting**
 * develop 2 macros/scripts for the database