Use the Pizza database that has been created . Write SQL statements to answer th

Question

Use the Pizza database that has been created . Write SQL statements to answer these questions.

Process a pizza order for a new customer (this will involve 3 insert statements)

the Cusihey need the the Prodiust js the entity relation diagram for the (We will use this database again in future or the 98002 and 9803. With the z d state indormation later, thoug Employee Employeekey CustomerPhonekey CustomerlLastName CustomerFirstName CustormerAddress CustomerAddress?2 CustomerCity CustomerState CustomerZp HEmployeeLastName EmployeeFirstName EmployeeHireDate Product ProductKey ProductName ProductUnitSize ProductUnitPrice PK Orderkey OrderDate OrderTime CustomerPhoneKey Employeokey OrderDetail OrderDetailKey OrderKey ProductKey OrderDetailQuantity OrderDetallPriceCharged

Explanation / Answer

Q1) Process a pizza order for a new customer (this will involve 3 insert statements)

INSERT 1:-

INSERT INTO CUSTOMER VALUES (8100428836, 'MALAKER', 'GOPAL', 'ADDRESS1','ADDRESS2', 'CITY','STATE',560036);

COMMIT;

INSERT 2:-

INSERT INTO CUSTOMERORDER VALUES ('ORDER-12345', TO_DATE ('08-AUG-2017','DD-MON-YYYY'), '12:30', 8100428836, 437227);

COMMIT;

INSERT 3:-

INSERT INTO ORDERDETAIL VALUES ('ORD-DETAIL-001', 'ORDER-12345', 'P-001', 2, 1000);

COMMIT;

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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