Create tables and insert the data from the file called OrderOL TPSchema.txt file. I suggest you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create tables and insert the data from the file called OrderOL TPSchema.txt file. I suggest you create one table at a time to endure each table is created and inserted correctly. Copy (CTRL C) the commands of the text file and paste them (CTRL V or Right Click) into Oracle and execute them. To run the file, press (CTRL + Enter) to run the commands. This will execute the command you just pasted. The ERD of the Order Schema is shown below: Employee Employee_id First name Middle_initial (0) Last name sex manager_id hire_date salary commision (O) job_code dob Price_hist Product_id (FK) list_price min_price (0) start_date end_date Customer Customer_id Name Address City 04 state zip_code area_code (0) Phone number (O) salesperson_id (O) (FK) credit_limit (0) comments (0) #H Product Product_id Description Product code H- Sales_order Order_id Customer_id (FK) Shipdate (0) Order_date Total line_item Order_id (FK) Item seq Product_id (FK) Actual_price Quantity SubTotal (a) To the original EMP table, insert your own data as an employee as follows. For foame, Iname, sex, and dob with your own first name, last name, sex, and dob. For Emploxee.id, use the last 4 digits of your own Drexel student ID (e. if 2 your Drexel student ID ends with 1234, then your Emploxeeid will be "1234"). Make all attributes NULL or arbitrary. Insert the above data (5). (b) Display all the Emploxes id, first name, last name, sex and dob. (5) (c) Display the contents of all 6 tables using SELECT * command. Make sure each line is displayed in one line. (5) For example, Create tables and insert the data from the file called OrderOL TPSchema.txt file. I suggest you create one table at a time to endure each table is created and inserted correctly. Copy (CTRL C) the commands of the text file and paste them (CTRL V or Right Click) into Oracle and execute them. To run the file, press (CTRL + Enter) to run the commands. This will execute the command you just pasted. The ERD of the Order Schema is shown below: Employee Employee_id First name Middle_initial (0) Last name sex manager_id hire_date salary commision (O) job_code dob Price_hist Product_id (FK) list_price min_price (0) start_date end_date Customer Customer_id Name Address City 04 state zip_code area_code (0) Phone number (O) salesperson_id (O) (FK) credit_limit (0) comments (0) #H Product Product_id Description Product code H- Sales_order Order_id Customer_id (FK) Shipdate (0) Order_date Total line_item Order_id (FK) Item seq Product_id (FK) Actual_price Quantity SubTotal (a) To the original EMP table, insert your own data as an employee as follows. For foame, Iname, sex, and dob with your own first name, last name, sex, and dob. For Emploxee.id, use the last 4 digits of your own Drexel student ID (e. if 2 your Drexel student ID ends with 1234, then your Emploxeeid will be "1234"). Make all attributes NULL or arbitrary. Insert the above data (5). (b) Display all the Emploxes id, first name, last name, sex and dob. (5) (c) Display the contents of all 6 tables using SELECT * command. Make sure each line is displayed in one line. (5) For example,
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
Currently Digby is paying a dividend of $13.44 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?
-
You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...
-
Estimate zero-wind lift-off (ground) distance for the Citation corporate jet at the maximum takeoff weight (MTOW) of 20,000 lbs at elevation of 4,000 feet in ISA conditions. Wing surface area is 320...
-
Consider the case of the Cisco Fatty. Who was wrong? Advise how a firm might best handle this kind of online commentary.
-
The width of the slit in this experiment is 2.20 10-6 m. (a) If the frequency of the light is decreased, will the angle to the first dark fringe above the central bright fringe increase or decrease?...
-
A platform is rotating at an angular speed of 2.2 rad/s. A block is resting on this platform at a distance of 0.30 m from the axis. The coefficient of static friction between the block and the...
-
Ratliff Corporation produces lawn fertilizer spreaders. Ratliffs income statement shown has been prepared for August of the current year. Instructions: 1. Prepare Ratliffs August income statement...
-
You are the manager of a large but privately held online retailer that currently uses 17 unskilled workers and 6 semiskilled workers at its warehouse to box and ship the products it sells online....
-
In the country of United States of Heightlandia, the height measurements of ten - year - old children are approximately normally distributed with a mean of 5 4 . 9 inches, and standard deviation of 4...
-
B 9 50 01 02 03 04 05 06 107 108 109 110 111 112 113 114 115 116 117 40. Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to increases cash. 41. Based on...
-
This function will provide the full array of "department objects using the resolve method of the returned promise. If for some reason, the length of the array is 0 (no results returned), this...
-
List of different communication channels that Tonya could use to deliver the new policy to the staff members. As Tonya considers her audience, what techniques can she include in her communication...
-
Mason Company provided the following data for this year. Sales Direct labor cost Raw material purchases Selling expenses Administrative expenses. Manufacturing overhead applied to work in process...
-
Imagine that you have written a journal article about your life. Write a brief paragraph of at least 100 words using in-text citations Last Name, Year and then create your reference list. See the...
-
Please answer the following after watching Citizen Kane: 1. What are some of the themes in this film? Explain. 2. What kind of person is Charles Foster Kane? Explain. 3. Why is this film significant...
-
1. Compare and contrast instructor-led training and self-directed learning as well as asynchronous and synchronous training. 2. Explain how online education and electronic performance support systems...
-
2a. Two 1.95uC point charges are located on the x axis. One is at x = 1.02m, and the other is at x = -1.02m. Determine the electric field on the y axis at y = 0.460m. Submit Answer Tries 0/10 2b....
-
After Theorem 1.5 we note that multiplying a row by 0 is not allowed because that could change a solution set. Give an example of a system with solution set S0 where after multiplying a row by 0 the...
-
In this chapter, file servers were described as one way of providing information to users of a distributed information system. What file servers are available, and what are their relative strengths,...
-
List the ideal characteristics of an entity identifier attribute.
-
Working in a small group, pick a project (it could be anything, such as planning a party, writing a group term paper, developing a database application, etc.) and then write the various tasks that...
-
Tracy Company reports the following amounts in its annual financial statements: a. Compute Tracy's free cash flow. b. Compute Tracy's operating-cash-flow-to-current-liabilities ratio. c. Compute...
-
Review each of the following items, a through \(f\), and determine whether the item supports a (1) production view of quality or a (2) customer view of quality. a. Applying management-by-exception...
-
During the year, Paton Corporation's Long-Term Investments account (at cost) increased \(\$ 20,000\), the net result of purchasing stocks costing \(\$ 85,000\) and selling stocks costing \(\$...
Study smarter with the SolutionInn App