AS IT database key terms

1. used to link tables together and is a field in one table that is linked to a primary key in another table. (7, 3)
4. a type of relationship where one instance of an entity can be linked to many other entities (3, 2, 4)
5. a name given to anything data is stored about (6)
7. describes the properties of an entity (9)
8. a type of relationship that links one instance of a entity to one instance of a second entity (3, 2, 3)
9. a field in a table that allows each record to be uniquely identified eg ID (7, 3)

2. a type of entity that sits between 2 entities and has a one to many relationship (4, 6)
3. the name of the row in a table (6)
6. a type of relationship where many instances of an entity can be linked to many other instances of an entity (4, 2, 4)
10. contains data based on a specific entity eg customers (5)

Get Revising