Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What is conservative approach ?

Answered: 1 week ago

Question

What are the basic financial decisions ?

Answered: 1 week ago

Question

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago