Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure Original On Schedule
Your task in this assignment is to set up a connection to acadoradbprd01.dpu.depaul.edu with SQLDeveloper and write an SQL script to create and populate a small database consisting of four linked relations.
Steps:
0. First, verify run SQLDeveloper and create a new connection to acadoradbprd01.dpu.depaul.edu (follow the instructions in CDMOracleTutorial.pdf included with Lecture1 materials. I strongly recommend that try to establish a connection to acadoradbprd01.dpu.depaul.edu as soon as possible so that you have time to work out any problems that arise with your account and password.
Next, write a script to do the following:
1. Create a relational database schema consisting of the four relation schemas given in the diagram below, representing various entities recorded by a furniture company. Define all necessary attributes, domains, and primary and foreign keys.
You should assume the following: Each CustomerID is a number with at most three digits, each OrderID is a number with at most five digits, and each ProductID is a number with at most two digits. Each Name is at most 26 characters long, and each Address is at most 50 characters long. Each Quantity is a positive whole number between 1 and 100, inclusive. Each Description is at most 29 characters long, and each Finish is at most 12 characters long. Each Price is a non-negative value (zero is allowed) representing a price in dollars and cents that cannot exceed 999.99.
In order to avoid conflicts, include DROP TABLE commands for all four tables before your CREATE TABLE statements. Either drop tables containing foreign keys before the tables containing the referenced primary keys, or use CASCADE CONSTRAINTS. Verify that the tables have been defined correctly before going on to the next step.
2. Populate the database as follows:
CUSTOMER:
CUSTOMERID NAME ADDRESS
———————- —————————— ——————–
2 CASUAL FURNITURE PLANO, TX
6 MOUNTAIN GALLERY BOULDER, CO
FULLORDER:
ORDERID ORDERDATE CUSTOMERID
———————- ————————- ———————-
1006 24-MAR-10 2
1007 25-MAR-10 6
1008 25-MAR-10 6
1009 26-MAR-10 2
PRODUCT:
PRODUCTID DESCRIPTION FINISH PRICE
———————- —————————— ———- ———-
10 WRITING DESK OAK 425
30 DINING TABLE ASH 600
40 ENTERTAINMENT CENTER MAPLE 650
70 CHILDRENS DRESSER PINE 300
REQUEST:
ORDERID PRODUCTID QUANTITY
———————- ———————- ———————-
1006 10 4
1006 30 2
1006 40 1
1007 40 3
1007 70 2
1008 70 1
1009 10 2
1009 40 1
Remember to insert the records containing primary key values before inserting the records containing the foreign keys that reference those values (or your insert statements will fail).
3. Display the contents of each table by adding four statements of the form SELECT * FROM TABLE_NAME ; to the end of your script.
4. Include a comment at the top of the script file giving your name, the course number and your section number, the assignment number, and the date of submission, e.g.:
/*
YourName
CSC 453 Section YourSection
Assignment 1
SubmissionDate
*/
5. Run the complete script. Be sure that that the contents of the four tables are displayed correctly by your script.
Remarks:
1. There are tools within SQLDeveloper that allow you to build tables row-by-row without writing your own CREATE and INSERT statements and will automatically generate SQL code that would build the table. You may not use these table creation and code generation tools to complete the assignment; you must write the CREATE statements to create the tables yourself and include these statements in your script.
2. For this assignment you may use a different front end application instead of SQLDeveloper, only the submitted SQL script will be graded.
3. For this assignment you may use a different DBMS (e.g., SQL Server) if you prefer. However, be sure to specify which DBMS you have used in the top level comment.
4. For all assignments, it is your responsibility to make sure that the files you have uploaded are readable and in the correct locations. You should always check that you can successfully download your submitted files back from the course web site and open them immediately after submitting them to be sure that they have been uploaded correctly.
5. Please remember that all work must be completed individually.
I need this assignment exactly what this question asks
Please don’t use strictly no plagiarism and no chatgpt
I need this assignment in 5hours
Get fast, custom help from our academic experts, any time of day.
Secure Original On Schedule