databases

Question 1

describe what is meant by primary key

Answer 1

A primary key is a unique identifier for each record in the table in this case video id

Question 2

relational database

Answer 2

.A relational database is a database which recognises the differences between entities by creating different tables for each entity

Question 3

flat file database

Answer 3

flat file is a database that consists of a single file.The flat file will most likely be based around a singe entity and it’s attributes.flat file database written in the following way :
entity1(attribute1 , attibute 2)

Question 4

foreign key

Answer 4

The attribute which links two tables together.The foreign key will exist in one table as the primary key and act as the foreign key in another

Question 5

secondary key

Answer 5

allows a database to be searched quickly.

Question 6

Referential integrity

Answer 6

Referential integrity means that no foreign key in one table can reference a non-existent record in
a related table