TEC 5323 Advanced Database Technology

Project 3 Table Join

Task:

You will need to use the script "chap04.sql" for this project, in a similar way to what you have worked at the class notes. In other words, the assignment will be tested under the user name of "practice04" in Oracle.

Your assignment for this project is to use table-join to accomplish the following tasks:

    1. Create a summary with the following five columns: ORDER_ID, DESCRIPTION,QUANTITY,UNITPRICE, EXTEND. (30 points)

    2. The query will join ITEMS and PARTS tables in a correct and logical way. (45 points)

    3. EXTEND is calculated by multiplication of QUANTITY and UNITPRICE. (10 points)

    4. Rearrange the results in descending order according to ORDER_ID. (15 points)

    Tips: There will be a total of 24 rows selected.

.
Report:

Create a single SQL script for the project (10 points off if not in one file).  Please test your script before submission.  Twenty (20) points will be taken if the script is not running (even with minor syntax error) while the instructor tests on his system.  Please note the importance of this practice as a database professional in the field.  This practice will be reinforced for all remaining projects in the course. 

Submit your project through D2L If you need instructions on how to submit, click here.

Please submit your SQL script only. SQL script is in .sql format, which can be run in Oracle SQL*Plus as SQL>@filepath\file.sql. For example, if your SQL script is saved as myscript.sql in C:\temp folder, then we will be able to execute it in SQL*Plus as "SQL>@C:\temp\myscript.sql."

Convention for File Name: Please name your file as firstname_lastname_project3.sql, where firstname and lastname are your first and last name, respectively, and "_" is underscore.

Please note that five (5) points will be taken for all projects this semester from this point on if the file naming convention is not followed.

 
Due: At the end of this week. Please see the course schedule for exact due date.

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University