Create a table schema Conditional Disjoint otal CDS Artist name Music type. Musi
ID: 3818585 • Letter: C
Question
Create a table schema
Conditional Disjoint otal CDS Artist name Music type. Music label Copies 0:n 1:1. Inventories S a DVDs Movi enr Movie directo movie hero Movie heroin the year of the movie. 1:n 1:n RC 1:1 0:m PC Video ames Pla Game genre Game Age Rating 0:1 SCE Rental id Rental date Rental amount Rental due 0:n Rentals 1:m 0:n RC UST 1:1 0 m Purchases Purchase date Purchase amount PCUST sale id. Sale amount Sales ee id empl Employee name 0:n Employee address Employee phone, Employee email ES Employee rank Employee salary. ER 1:1 1:1 0:n Employees 1:1 CUSTS 1:1 cust id Cust First name Cust Last Name Cust address 1:1 Customers Cust zip code pho Cust emailExplanation / Answer
CREATE TABLE Copies(Copy_ id integer); CREATE TABLE Inventories Tities(Title _id integer); CREATE TABLE CDS (Artist name varchar(40),Music type varchar(20), Music Label varchar(20)); CREATE TABLE DVDS(Movie genre varchar(10), Movie director varchar(20), movie _hero varchar(10), Movie heroin(20), the year of the movie varchar(40)); CREATE TABLE Video games(Ploform type varchar(20), Game genre varchar(10), Game AgeRating integer); CREATE TABLE Sales(Sale id integer, Sale amount integer); CREATE TABLE Rentals(Rental_ id integer, Rental date DATE, Rental amount integer, Rental due integer); CREATE TABLE Purchases(purchase _id integer, purchage date DATE, Purchase amount integer); CREATE TABLE Employees(employee _id integer,Employee name varchar(20), Empolyee address varchar(50),Employee phone integer, Employee email varchar(10), Eamployee rank integer, Employee salary integer); CREATE TABLE Customers(cust _id integer, Cust First name varchar(10) Cust Last Name(10),Cust address varchar(50), Cust zip code integer, Cust phone integer, Cust email varchar(15), Cust interests integer);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.