Relational databases & Normalisation Flashcards
1
Q
Relational database
A
A collection of tables, in which relationships are modeled by shared attributes.
2
Q
Entity name
A
Is shown outside brackets of table description e.g. Books (BookID, DeweyCode, Title, Author, DatePublished)
3
Q
Primary key
A
Is underlined
4
Q
Normalisation
A
A process used to come up with the best possible design for a relational database.