And that additional business rules hold

INFO 210, Database Management Systems

Homework 3

Submit your assignment electronically to Bblearn “HW 3” slot(https://learn.dcollege.net/).

•	Place all parts of your answers into one file, and name it as follows: INFO210_yourDrexelid_HW3, with the appropriate file extension. For example,

Problem 1 : Entity-Relationship modeling

A recording studio needs help designing its database. The studio stores information about musicians and albums. Draw an ER diagram describing the studio’s database for each of the two scenarios described below. Assume that the only business rules that hold are those stated below, and that no additional business rules hold. Clearly mark all key and participation constraints.

Problem 2 : Translating ER models to relational schemas

Consider ER diagrams below. Write a SQL statement (create table) that implements the constraints specified by the ER diagram below. Create as many tables as required. Briefly explain which constraints are captured in your relational implementation, and in what way. If a constraint cannot be implemented, state that explicitly in your explanation. You will not receive full credit without an explanation.

(b) Identify the city with largest population for each country. List its country name, and the population.

(c) For each country, list its name and belonging continent, along with its total population that is over 1 million.Also sort the result by the total population in descending order.