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. University registrar’s tables:

student (student-id, name, program, dateofbirth)

course (courseno, title, syllabus, credits)

course-offering (courseno, sectionno, year, semester, time, room)

instructor (instructor-id, name, deptno, title)

enrolls (student-id, courseno, sectionno, semester, year, grade)

1. Customer Order:

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

Product (productNO, productTitle, price, QStock )

customerOrder ( orderNO, orderDate, customerNO)

orderedProduct (orderNO, productNO, orderQuantity)