Create tables based on the below given relational model. Define your own data type to the attributes and apply your own constraints to the attributes Identify the primary, foreign keys apply it to the...


Create tables based on the below given relational model.


Define your own data type to the attributes and apply your own constraints to the attributes


Identify the primary, foreign keys apply it to the attributes.


Populate the data in all the tables using SQL commands/queries




  1. Customer Order:


Customer (customerNO, customerName, address, city, category, custBalance)


Product (productNO, productTitle, price, QStock )


customerOrder ( orderNO, orderDate, customerNO)


orderedProduct (orderNO, productNO, orderQuantity)



Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here