Databases:

Design

From the SQA Course Specification

• Describe and exemplify entity-relationship diagrams with three or more entities, indicating: entity name; attribute; name of relationship and cardinality of relationship (one-to-one, one-to-many, many-to-many) 

• Describe and exemplify an instance using an entity-occurrence diagram. 

• Describe and exemplify a compound key. 

• Describe and exemplify a data dictionary with three or more entities: entity name; attribute name; primary and foreign key; attribute type; attribute size and validation