Question: 1. Source code and screenshot of the table for creating the Customer table. 2. Source code and screenshot of the table for creating the Item

1. Source code and screenshot of the table for

1. Source code and screenshot of the table for creating the Customer table.

2. Source code and screenshot of the table for creating the Item table.

3. Source code and screenshot of the table for creating the ItemProduct table.

4. Source code and screenshot of the table for creating the Orders table.

5. Source code and screenshot of the table for creating the Product table.

6. Source code and screenshot of the table for creating the Requests table.

7. Source code and screenshot of the table for creating the Shipment table.

8. Source code and screenshot of the table for creating the ShipmentItem table.

9. Source code and screenshot of the table for creating the Supplier table.

10. Source code and screenshot of the table for creating the SupplierItem table.

11. Write a DDL code the add new columns on the Customer table. The new columns name are Address, Postal Code, Province, Zip Code. The new columns are all data type Vachar2(100). Copy and paste the source code and screenshot of the updated table below:

12. Change the Quantity attribute to QTY in the item Table. Copy and paste the source code and screenshot of the updated table below:

13. Rename the following tables:

ItemProduct to DetailsOfProduct

ShipmentItem to ShipmentDetails

SupplierItem to SuppliersInvoice

Copy and paste the source code and screenshot of the updated table below:

14. Increase the number of characters on the attribute ProductCategory in the Product table. Increase it from 500 to 600. Copy and paste the source code and screenshot of the updated table below:

15. Type in Commit on the worksheet, to save the changes made. Copy and paste the code below:

16. Create a new table. Name the table TempTable. Create two attributes of your own, one of the attributes is an identifier. Copy and paste the source code and screenshot of the updated table below:

17. Delete the table TempTable. Copy the code you have used and take a screenshot of the your Recycle bin and paste it here:

18. Restore the table TempTable back to the Tables Schema. Copy and paste the source code and screenshot of the updated table below:

19. Make the table TempTable to an uneditable table. Copy and paste the source code and screenshot of the updated table below:

20. Create a comment on the column Customerid of the Customer table. Copy and paste the code below

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 General Management Questions!

Assignment 2: Sorting and Searching ( Submission due date: 7 Jan 2021) 1. Identify attributes and member functions suitable for each case and draw the class diagram. 2. Write implementation function...

Final Project Write a Java or C/C++ (the choice is yours) program for a Demand Paging Simulator according to the following rules. The program will implement two Demand Paging algorithms: the...

CCCS 111 - Introduction to Programming University of Jeddah Programming Assignment # 2 Points: 2 | CLO $2 Summary Write a program that prints out a table of all ASCII characters that can be stored in...

I only need assistsnce with 5,6, and 7. preferably 6 & 7 data is provided 4. Create a table named productSupplier with the following attributes, data types, and constraints: a. productId, integer, 7...

Implement a C program to decrypt a bmp image. Study the posted 8-bit-mini-DES algorithm posted, and study the code in miniDESv2.cpp. The posted ePic.bmp was encrypted with this algorithm. Modify the...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

#Chapter 1: Data entry, name and group worksheets, formatting, sorting and filtering, page layout, and forms. Business Problem: How might a manager track inventory quantities-on-hand? #Chapter 2:...

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

i need it as fast as you can please (( USE JAVA FX) This document contains ink, shapes and i... Club Registration App Project Phase II requirements Due on 24/12/2022 In Phase II your task is to...

5) Draw the interaction diagarm for the airtrack experiment. Friction is small but you should still include it on your diagram. Use C, W, A and E FIGURE 6.23 The experimental arrangement. 250 g cart...

Wanda Fennell, the purchasing agent for Northeast Airlines, is interested in determining what she can expect to pay for airplane number 4 if the third plane took 20,000 hours to produce. What would....

E8.23 (LO 5) (Analysis of Inventories) The financial statements of AB InBevs (BEL) 2018 annual report disclosed the following information. (in millions) 31 December 2018 31 December 2017 Inventories...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...