Question 4 (20 marks) Figure shown in left, is an order formOrder Form of a comp

Question

Question 4 (20 marks) Figure shown in left, is an order formOrder Form of a company. Construct a table as in a database system, which is used to Shio to: 3-Oct store the invoice data. The table should include attribute, field type June Summers Fill in I sample record in the table you 123 Main St have designed as a demonstration. In Toronto, ON M5M SMS the table, showing the field names, field type and suggest which field is the primary key Product Price aty Total Sweater 15.00 5 $75.00 Jacket Sweater Shirt Pants Dress Total $75.00

Explanation / Answer

Solution:

This is done in SQL:

Database creation:

CREATE TABLE OrderForm(
    Product int NOT NULL,
    Price int,
    Qty int ,
    Total int,
    PRIMARY KEY (Product)
);

INSERT INTO OrderForm(Product, Price, Qty, Total)
VALUES ('Jacket', '15', '5', '75');

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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