| 1 | Understand the enterprise application of database systems | 1.1 | Summarise the common use of distributed database management systems |
| 1.2 | Explain the meaning of the term 'distributed database management system' |
| 1.3 | Describe the components of a distributed database management system |
| 1.4 | Summarise the common use of data warehouses |
| 1.5 | Explain the meaning of the term 'data warehouse' |
| 1.6 | Describe the structure of a data warehouse |
| 2 | Understand how to enhance the design of and further develop a database system | 2.1 | Describe how tables that contain redundant data can suffer from update anomalies |
| 2.2 | Explain how to overcome update anomalies using normalisation |
| 2.3 | Describe how to retrieve data from one or more tables using SQL |
| 3 | Be able to enhance a logical database design | 3.1 | Check the tables are well-structured using normalisation |
| 3.2 | Define the integrity constraints on the tables |
| 4 | Be able to develop a physical database design | 4.1 | Map a logical database design to a physical database design |
| 4.2 | Design tables for a target DBMS |
| 4.3 | Design a representation of derived data |
| 4.4 | Design integrity constraints for the target DBMS |
| 4.5 | Denormalise tables where appropriate |
| 5 | Be able to enhance a database system using SQL | 5.1 | Apply integrity constraints |
| 5.2 | Retrieve data from one or more tables using joins |
| 5.3 | Retrieve data from one or more tables using sub-queries |
Don't show this message again.