Transform the following e-r diagram into a set of relations in 3NF. Identify the primary and foreign keys for each relation. Identify and describe referential integrity constraints needed to guarantee the integrity of the database.

 

CustID Age Order Num CustName Customer make Purchase Song Title User Name EmailAddress Genre Description password Genre Duration_in_secs) Song 1400 sign up as User CreditCar Num Song Tilte belongs to Price Purchase_Date Release Date contains has produced city Album Title Album created by creates Artist ID Artist Name HomeCity ResidenceCity