Answer Happy

Answer this question in your answer script/answer booklet provided. Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. 1. 2. 3. 4. 5. Business rules of a college that wants to keep track of their registered students: All entities should have surrogate primary keys. Each student registers to study at a specific campus. When a new campus is established, it can initially be recorded in the database without any students being registered there. The name and surname of each student must be recorded in the database. The name of each campus must be stored in the database. Every student registers for many modules over time, and every module can be taken by many students. Students may register for the same module in multiple years, so the year in which a student registers for a particular module also needs to be stored. The module code and name of every module must be stored in the database. Each module belongs to exactly one faculty, and a faculty owns many modules. A new faculty may be recorded in the database before the creation of its first module. 9. The name of each faculty must be stored in the database. 6. 7. 8. Marks will be awarded as follows: Entities Relationships Multiplicities Primary keys Foreign keys Other attributes 5 marks 4 marks 4 marks 2 marks 2 marks 2 marks 1 mark Correct UML Notation Total 20 marks