Each Student need to follow the below steps for their Assignment: 1. write a scenario in the databases about University. This scenario should include minimum three entities with their attributes the attributes should include Identifier and its different types. (0.5+0.5=1 mark) 3. The student has to draw ER diagram for his/her scenario with showing the relationship and cardinality between entities. (1+1+1=3 marks) 4. The student has to extend their ER Diagram to EER diagram which should include super type and sub types, participation and constraints. (1+1=2 marks) 5. The student has to transform their EER diagram into a Relational Schema. (0.5*3=1.5 marks) 6. Viva- There will a viva-voice in which the course lecturer will ask 5 questions to the student based on their scenario. (0.5*5=2.5 marks) Note: 1. Each Scenario should be unique and not repeated by any other student. 2. The Assignment should be submitted on or before 29th March 2021. 3. If the student failure to submit the assignment, will be awarded zero marks. 4. If the student failure to submit the assignment by the submission date then he/she will be penalized by 0.5 mark for each delay day of late submission 5. The student should check the Plagiarism policy and submit the Student plagiarism declaration form with their assignment. 6. The student should use proper referencing and cite it clearly in their assignment. 7. The student assignment will be graded on the above mentioned criteria