Understand a set of requirements and construct a suitable data model to represent them in a computer system
computer science
Description
Assessment Specification
Learning Outcomes: LO1: Construct
a relational data model
LO2:
Execute the techniques of data normalisation to 3NF
Specific Assessment Criteria:
• Understand a set of requirements and construct a suitable data
model to represent them in a computer system
•
Demonstrate an understanding of normalisation
process by normalising the designed model to 3NF and documenting/explaining
each step as necessary
•
Explaining the pros and cons of normalised
databases in general terms
