Question: Write SQLs to create three tables based on given relational schemas and directions below. Based in Oracle DBMS, follow standard syntax. In addition of the

Write SQLs to create three tables based on given relational schemas and directions below. Based in Oracle DBMS, follow standard syntax.

Write SQLs to create three tables based on given relational schemas and

In addition of the relational schema above, include the following specifications in the table creation. i. The OrderDate column of ORDERS table has a default value as a current system date, SYSDATE. ii. The value of OrderQuantity of ORDERINE table should be greater than 0. iii. The value of ProductType of PRODUCT table should be a value in this list {Books,Electronics, Home, Clothing} iv. When an order record in ORDERS table is deleted, all ORDERINE records associated with the OrderID of the deleted record are also deleted. v. When a CUSTOMER record is deleted, its associated ORDERS records CustomerID is changed to NULL.

ORDERS ORDERLINE PK OrderlD number(11) PK | | FK OrderID number(11) | FK | [F] ProductiD number(11) CustomerID number(11) OrderDate date OrderQuantity number(11) CUSTEROMER CustomerlD number(11) CustomerName varchar2125) CustomerAddr varchar2(30) PRODUCT ProductID number(11) ProductType varchar2130 PK

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write SQLs to create three tables based on given relational schemas and directions below. In addition, include the specifications below when you create the tables. (1) In FLIGHTLEG table, include...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Can someone help make this java file run? The code is probable the main issue I am having //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

In response to the ongoing challenges posed by the COVID - 1 9 pandemic, the Ministry of Health for each country has initiated a domestic healthcare campaign to promote healthcare services and...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

You expect that Microsoft will pay a dividend of $1.50 in one year, $1.76 in two years, and $1.89 in three years. After that, dividends are expected to grow at 3% per year. If your required rate of...

Panama adopted the U.S. dollar as its official paper money in 1904. Currently, $400 million to $500 million in U.S. dollars is circulating in Panama. If interest rates on U.S. Treasury securities are...

How do companies decide on the method of capital raising

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

b. Will there be one assigned leader?

c. How will members be allowed to rotate out of the team if they so desire?

Do you currently have a team agreement?