BN204 - Database technologies - Final Assessment Trimester 3, 2020 a) Identify 4 business rules describing the relationships between entities and write the type of relationship, as given below, based on the description of operations given in the question Example: One customer can place one or more orders: One-to-many relationship. [2 marks] b) Identify entities, attributes, and primary keys that adequately describe the entities. Construct them as a collection of Tables and attributes (Schema form). You are required to indicate primary keys (underline). [3 Marks] c) Determine the functional dependencies (FD). Normalise these relations to 3 normal form, ensuring that the resulting relations are dependency-preserving and in 3NF. You need to explain each step clearly. [Marks] d) ER diagram a. Represent the structure of your database visually by using an entity-relationship (ER) diagram. You are required to: 1. Draw the ER diagram on paper (do not use any software tools) and include the image in the Word document. il. Name all entities in the ER diagram including your name. For example: If you have Entity name Student, you will name it as "Yourname:Student". If "Sam Smith" is drawing the ER diagram he will name the "Student" entity as "Sam_Smith:Student". ill. If you make any assumptions about data that are not explicitly given in the problem, these must be described. 20 Marks) NB: This should be your own individual work. If not, it is considered cheating and you will get zero marks for the whole exam. Page 4 of 8 BN204 - Database technologies - Final Assessment Trimester 3, 2020 a) Identify 4 business rules describing the relationships between entities and write the type of relationship, as given below, based on the description of operations given in the question Example: One customer can place one or more orders: One-to-many relationship. [2 marks] b) Identify entities, attributes, and primary keys that adequately describe the entities. Construct them as a collection of Tables and attributes (Schema form). You are required to indicate primary keys (underline). [3 Marks] c) Determine the functional dependencies (FD). Normalise these relations to 3 normal form, ensuring that the resulting relations are dependency-preserving and in 3NF. You need to explain each step clearly. [Marks] d) ER diagram a. Represent the structure of your database visually by using an entity-relationship (ER) diagram. You are required to: 1. Draw the ER diagram on paper (do not use any software tools) and include the image in the Word document. il. Name all entities in the ER diagram including your name. For example: If you have Entity name Student, you will name it as "Yourname:Student". If "Sam Smith" is drawing the ER diagram he will name the "Student" entity as "Sam_Smith:Student". ill. If you make any assumptions about data that are not explicitly given in the problem, these must be described. 20 Marks) NB: This should be your own individual work. If not, it is considered cheating and you will get zero marks for the whole exam. Page 4 of 8