Question

Questions: Assume you are creating a database for IS paint store. Suppose you have an ER diagram like the following: Please answer the following questions. Explain your answer. 1. Convert the ER diagrams to relational tables. 2. Specify primary keys and foreign keys in each table. For foreign keys, specify which primary key it references to. 3. Please create the tables in SQL for the relational tables in our ER diagrams. You also need to define primary keys and foreign keys. 4. Please insert at least one row into each table.

Answer 1

street,city,zip,state) Transaction Balance Rent date Transaction Detail payment Cust ID (FK T ID Due Date Return Date TYPE I ID (FK) Director Price Num InStock LID IFK) TV Series ID (FK) E title E Director LID Release time LID (FK) Series ld (FK

1) Primary Keys of every table is defined by underlining that attribute and FK is represent by typing (FR) in front of that attribute.

2)

Table Name	Primary Key	Foreign Key	Foreign_Key_Reference_Table
Customer	Cust_ID
Transaction	T_ID	Cust_ID	Customer
Transaction Detail	I_ID	T_ID	Transaction
Inventory	I_ID	I_ID	Transaction Detail
Genre		I_ID	Inventory
TV Series	TV_Series_Id	I_ID	Inventory
Movie		I_ID	Inventory
Episode		TV_Series_Id	TV Series