Question 4 Entity Relationship Diagram Review Marks 20 Dineo Being Ever Curious And Wanting To Learn More About An 1 (150.24 KiB) Viewed 26 times
Question 4 - Entity Relationship Diagram Review (Marks: 20) Dineo, being ever curious and wanting to learn more about anything and everything, decided to try her hand at creating a UML ERD for a relational database. You made it look so easy, so she was confident that she could do it too. So, she wrote some new rules about campus life and created the below ERD based on some web pages that she consulted. A student can register for more than one degree over time, and many students can register for the same degree. Each degree consists of many modules that you have to complete. And a module can be part of multiple degrees. The number of credits for the module should be stored in the database too. A student can register multiple times for the same module, and the final mark and result should be recorded for each module registration. The name, surname and student number should be recorded for each student. A student also registers to study at a specific campus. Each campus has a name. Student Student Number Erk} / 11 Nawne Surname o* Student No EFKS Module Name Subject Degree I Nenne Molute Naume Credits
21; 22; 23 2022 Comment on her diagram, explaining which 10 changes you would recommend to improve the diagram to align with the business rules. Also, include improvements that would make it possible to implement the design in a relational database. Finally, please explain why you would make each change too, so she can learn from her mistakes. Hint: Include the diagram and add letters to the diagram that you can refer to in your comments. [TOTAL MARKS: 100]
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!