Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 4 (Marks: 25) Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should
Question 4 (Marks: 25) 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. Online course catalog business rules: - Every entity must have a surrogate primary key. - A creator can publish their course on a platform. For example, Sarah can publish her databases course on Udemy. - There is no limit on the number of platforms that a creator can publish their course on. - The price and publication date of each publication must be stored in the database. - The name and description of each course must be stored in the database. - The name of each creator must be stored in the database. - The name of each platform must be stored in the database. - Each platform is hosted in exactly one country, and every country can have many different platforms. - The name of each country must be stored in the database. Marks will be awarded as follows
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started