Question: 2. (15 marks) CUSTOMER cid name 1111 John Smith 2222 Mary Pert address Windsor Windsor numorder 100 50 CHEF chid 1 2 chname Mana Patel

2. (15 marks) CUSTOMER cid name 1111 John Smith 2222 Mary

Pert address Windsor Windsor numorder 100 50 CHEF chid 1 2 chname

2. (15 marks) CUSTOMER cid name 1111 John Smith 2222 Mary Pert address Windsor Windsor numorder 100 50 CHEF chid 1 2 chname Mana Patel Pat Goodman specialization celebrity fish address Windsor London MEAL mealid 23567 55555 meal name Chicken rice Fish potato Cost 20.45 30.50 SERVES chid 1 2 cid 1111 2222 mealid 23567 55555 mdate 10-Jan-21 20-Aug-20 a Write the SQL DDL instructions to create all 4 tables of the above database in the Oracle DBMS on our cs server specifying all constraints such as Key, entity and foreign key constraints as usual within each instruction (not separately). (6 marks) b. Using only the data in the above instance (not a new instance formed by you), write the SQL instructions to load insert) all the data above in the 4 tables you created. (5 marks) c. Write the SQL query for the following query posed on this database, also write the results of the query and the tables involved in answering the query. (6 marks) Print all meals names and date they are ordered (meal name, mdate) for customer named "Mary Pert (5 marks) Que 2a (5 marks.): Creating Tables Que 2b (5 marks): Inserting Data into the Database Tables Solution (6) Question Query Tables needed to answer query and Result 2c (5 marks) Tables needed are: Result of Query is

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!

The statements of comprehensive income for Continent plc, Island Ltd and River Ltd for the year ended 31 December 20X9 were as follows: Continent plc acquired 80% of Island Ltd for ¬27,500 on 1...

Given the following four relations for a simple restaurant management record database application where cost of meals ordered by customers are tracked for each food order. Total number of orders...

I will like answer, plz do a, b, c 2. (15 marks) Given the following four relations for a simple restaurant management record database application where cost of meals ordered by customers are tracked...

cach of the FIVE questions for full marks. (Total 70 marks) Question 1 (15 marks) 1. Vic Corporation refines petrol and sells it through its own petrol gas stations. On the basis of market research,...

Question 1 [15 marks] Financial statement presentation You are a senior financial accountant at Thunder Ltd. One of the new graduate accountants has prepared the following statement of financial...

need solutions for these questions THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS amounts in millions, except share and per share data January 31, 2016 February 1. 2015 ASSETS...

QUESTION 1 (20 MARKS) Atif Pharma Bhd (AP Bhd) is a pharmaceutical distributor which purchases prescription medicines and other medical products directly from pharmaceutical manufacturers and...

there are two part : A and B B is CASE STUDY QUESTION ASSIGNMENT QUESTIONS Answer ALL questions Due date: Value: Monday 7 November, 2016 15% Rationale This assignment covers Weeks 1 - 10, and builds...

GENERAL IN STRUCTION S The assessment for this unit of competency.r consists of 2 parts, Part A and Part B. - PartA includes 4 scenarios, each followed by a series of questions. a Part B includes 2...

Assignment Type: Group Written Report and Creative Promotional Element Due Date: Module 14 Grading: Total 75 Marks, Worth 25% of Final Mark Submission: All late submissions will receive a -15%...

Required: For (a) and (b) assume the company uses the periodic inventory system Calculate the gross proft (margin) if the company uses first-in, first-out (FIFO) ANSWER (b) Calculate the value of the...

You have been asked by the management of Mok Ltd to assist with the preparation of the income tax entries for the year ended 30 June 2018. The company reported a profit before tax for the year to 30...

The South Korean won ( ) value was abruptly changed from 1 , 0 2 2 / $ to 8 1 0 / $ . What is the percentage change in the won value? Group of answer choices - 1 3 . 7 9 % 1 6 . 0 0 % 2 6 . 1 7 % 2 0...

Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (L06-3, 6-4, 6-5) [The following information applies to...

Recall also that, in equilibrium, the real output produced ( Y ) is equal to aggregate expenditures: Y C I g X n . a. Calculate the equilibrium level of income or real GDP for this economy. b....

KEY QUESTION Suppose a handbill publisher can buy a new duplicating machine for $500 and the duplicator has a 1-year life. The machine is expected to contribute $550 to the years net revenue. What is...

KEY QUESTION What is the multiplier effect? What relationship does the MPC bear to the size of the multiplier? The MPS? What will the multiplier be when the MPS is 0, .4, .6, and 1? What will it be...