The studio stores information about musicians and albums

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. Forexample, INFO210_xyzw98_HW3.docx,INFO210_abc123_HW3.pdf,arevalidfilenames. The file name should not contain any space symbols, and it should contain exactly two underscore symbols.

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.

Business Rules:
Each musician who records at the studio has a social security number (ssn) and a name, and no two musicians have the same ssn. Musicians form bands. A band is described by a unique name and has at least one musician as a member.

Name			N		Name	Genre
M					Name
Musician				Record
M
M		Produce
	Sequence		1
	Sequence
M						production
Songs						production

Problem 2 : Translating ER models to relational schemas

namechar(128),

primarykey (name),

Country	Country_Name

		North America
	England

		Europe
	Mali

(a) List the average population and number of all European cities with population of more than 600,000.

continent='Europe') and city_population>600000;

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