Question

CREATE TABLE Album Albumid INTEGER NOT NULL Title NVARCHAR(160) NOT NULL. Artistid INTEGER NOT NULL, PRIMARY KEY (Albumid), FOREIGN KEY (Artistid) REFERENCES Artist ArtistId) CREATE TABLE Artist ArtistId INTEGER NOT NULL Name NVARCHAR(120), PRIMARY KEY (Artistid) CREATE TABLE Customer CuatanerId INTEGER NOT NULL, First Name NVARCHAR(40) NOT NULL, Last Name NVARCHAR(20) NOT NULL Company NVARCHAR(80) Address NVARCHAR(70) City NVARCHAR(40), State VARCHAR 140, Country NVARCHAR(40), Postal Code NVARCHAR(10) Phone NVARCHAR (24) Fax NVARCHAR(24), Email NVARCHAR60) NOT NULL, Support Rapid INTEGER PRIMARY KEY (CuatanerId). FOREIGN KEY (Support Regid) REFERENCES Employee Employeeld) CREATE TABLE Employee Employeeld INTEGER NOT NULL Last Name NVARCHAR(20) NOT NULL First Name NVARCHAR (20) NOT NULL, Title VARCHAR(30) Report To INTEGER BirthDate DATETIME, HireDate DATETIME, Address NVARCHAR(70), City NVARCHAR(40). State NVARCHAR(40) Country NVARCHAR(40) Postal Code NVARCHAR(10) Phone NVARCIAR (24) Fax NVARCHAR(24) Email NVARCHAR(60) PRIVARY KEY (EmployeeIdl. FOREIGN KEY (Reportsto) REFERENCES Employee (Employee Id) CREATE TABLE Gence GenreId INTEGER NOT NULL, Name NVARCHAR(120), PRIMARY KEY (Genred)
Based on the CREATE TABLE statements, make an ER model of the database. Give suitable names to the relationships. (Remember cardinality and participation constraints.) The diagram must use either the notation used in the textbook (and the lectures) or the crow’s foot notation. To save you some time: There are a few tables that include the following address fields: Address, City, State, Country and PostalCode (and the same fields with the prefix Billing-). You are allowed to replace these attributes with a single attribute named FullAddress in your diagram. Note: You are not allowed to use any software to connect to a database and generate the diagram automatically.

Answer 1

Entity Relationship Between Album and Artist

Albumld Artistld<FK> Artistid •°•.. Title Name Albums — Released by 04 Artist

Entity Relationship Between Customer and Employee

Title ReportsTo<FK> SupportRepld<FK> Employeeld Customerld Email LastName Birth Date FirstName First Name Customer SupportRep_TO Employee Reports To LastName Fax Company Email FullAddress Phone Hire Date Fax FullAddress