Write SQL statements to create the corresponding relations and capture as many o

Question

Write SQL statements to create the corresponding relations and capture as many of the constraints as possible for the following E-R diagram. If cannot capture some constraints, explain why.

address Citv ength subject subject náme state aTime comment tvpe náme Zip Dealerships Appointments Feedback Loans WorksAt Requests Writes Applies ame assword bDate assword ende1 Name ddress phone email taCustomers email Employees services address ssn mpg type year odel sells Purchase comm maker pDateprice windPrice TradeIn NewCars UsedCars condition mileage

Explanation / Answer

Answer:

The SQL statements to create the corresponding relations using E-R diagram are given as follows:

Create Dealerships (name varchar2(20), address varchar2(20),city varchar2(20), state varchar2(20), zip varchar2(10));

Create Employees (id number(6) primary key, ssn number(10),fname varchar2(10), minital varchar2(10), lname varchar2(10), email varchar2(20), salary number(10,2), password varchar2(20), bdate date, gender char(6), phone number(10), address varchar2(20), name varchar2(20) references Dealerships(name), email varchar2(20) references Customers(email),vin varchar2(10) references Cars(vin));

Create Customers (ssn number(10),fname varchar2(10), minital varchar2(10), lname varchar2(10), email varchar2(20) primary key, password varchar2(20), address varchar2(20),vin varchar2(10) references Cars(vin));

Create Appointments (id number(6), subject varchar2(20),adate date, atime varchar2(10), email varchar2(20) references Customers(email));

Create Feedback (id number(6), subject varchar2(20),comment varchar2(20), email varchar2(20) references Customers(email));

Create Loans (id number(6), name varchar2(20),length number(3), type char(2), email varchar2(20) references Customers(email));

Create Cars(vin varchar2(10) primary key, type char(6),mpg number(4), year number(4), model varchar2(10), maker varchar2(10), windprice number(12,2), unitcost number(10,2), mileage number(4), condition varchar2(10, price number(12,2));

Create table Purchase(vin varchar2(10), pdate date ,price number(12,2));

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.