Computer ScienceCode 9618
Database Concepts
What this topic asks you to be able to do
- Demonstrate an understanding of the drawbacks of storing and retrieving data with a file-based approach
- Describe the relational database features that overcome the limitations found in a file-based approach
- Demonstrate comprehension of, and apply, the vocabulary tied to the relational database model
- Use an entity-relationship (E-R) diagram when recording how a database is designed
- Demonstrate an understanding of normalisation and its stages: First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF)
- Account for why a given set of database tables does or does not satisfy 3NF
- Produce a normalised design for a database when given a set of tables, a set of data, or a description of the database