1.8.2 Relational database modelling
• show understanding of, and use, the terminology associated with a relational database model:
entity, table, tuple, attribute, primary key, candidate key, foreign key, relationship, referential
integrity, secondary key and indexing
• produce a relational design from a given description of a system
• use an entity-relationship diagram to document a database design
• show understanding of the normalisation process: First (1NF), Second (2NF) and Third Normal
Form (3NF)
• explain why a given set of database tables are, or are not, in 3NF
• make the changes to a given set of tables which are not in 3NF to produce a solution in 3NF, and
justify the changes made
Rate It!
(3 votes, average: 3.67 out of 5)
Loading...
Comments - 4 Responses
Sir the notes are spot on, but if you lighten the watermark it would increase readability. It’s causing a lot of confusion
ok.i will consider this in my next upload session.i appreciate your suggestion.
Salaam, I am from the UK doing this A-level and I stumbled on this accidentally. I felt I needed to let you know how absolutely helpful they have been may Allah reward you and give you Jannah.
thanks for good wishes,this definitely encourages me to do more.
Write A Comment