Question: Using the ERD you created in Task 1, develop a create.sql file that will create a database named grubhub. Using the grubhub database, include

Using the ERD you created in Task 1, develop a create.sql file that will create a database named grubhub. Using the grubhub database, include statements in your file to create all the entities, attributes and primary and foreign key constraints detailed in your ERD. O Make sure to end each statement with a semicolon (;) O The creation scripts we have used in class are a great guide! Test running your create.sql file in our development environment. Adjust your script as needed. PK, FK Restaurants number, payment ID, address, name, phone number, and cuisine PK, FK PK, FK Orders unique number timestamp PK, FK GrubHub payment IDs PK, FK PK, FK Drivers status (paced, out, cancelled, and fullfilled) name, phone number, license plate number, drivers license number, payment ID, and status (active/inactive) PK, FK Customers number, name adress name, phone number, and payment ID record Name 1 April Ludgate 2 April Ludgate 3 Leslie Knope 4 Ron Swanson 5 Andy Dwyer 6 Task 3: Add Sample Data (15 pts) 6. Add insert statements to your create.sql file to add the data pictured below. This data is present in tables at the end of this document. Address 1235 55 Ave, Omaha, NE 68132 1235 55 Ave, Omaha, NE 68132 4387 Waffles Drive, Pawnee, IN, 46011 987 Bacon Avenue, Pawnee, IN 46011 2468 The Pit, Pawnee, IN 46011 Phone 402-553-4397 402-553-4397 234-432-5437 456-987-3265 pmt_id restaurant name address 23456 Paunch Burger 23456 Paunch Burger 98754 JJ's Diner 234789 Mulligan's 12390 JJ's Diner 6872 Lard Lane, Pawnee, IN 46011 6872 Lard Lane, Pawnee, IN 46011 23428 Main St. Pawnee, IN 46011 6876 Classy Rd., Indianapolis, IN 46077 23428 Main St. Pawnee, IN 46011 phone cuisine 678-893-1568 Fast food 678-893-1568 Fast food 456-987-3185 Breakfast 786-235-4862 Steakhouse 456-987-3185 Breakfast O rest. Pmt_id driver 4826 Henry Roth 4826 Charity Osborne 78623 Fritz Macias 48623 Brenden Hill 78623 Henry Roth Leah Peters phone license plate drivers license drv. Pmt_id drv. Status order date (286) 937-2250 IUC989 C04790049 444862 active (815) 605-0336 REW222 D89973937 959227 active (943) 893-6193 XUA177 U06119817 718371 active (513) 284-9064 IOL455 X22173227 334452 active (286) 937-2250 IUC 989 C04790049 444862 active (909) 477-8843 AJA879 V44276914 603268 inactive order status 9/30/2020 6:44 out 9/30/2020 10:44 placed 9/30/2020 10:54 fulfilled 9/30/2020 10:46 placed 9/30/2020 11:44 cancelled 7. Test running your create.sql file in our development environment. Adjust your script as needed.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Based on the provided EntityRelationship Diagram ERD and the instructions heres a script createsql that will create the necessary tables for the grubh... View full answer

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 Algorithms Questions!

Problem Solving Code Problems. (~50% of Grade) There should be one Word document that provides the problem-solving methodology to this problem to include UML Class and UML Activity Diagrams. You will...

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Task 2 : Make the CREATE script ( 1 5 pts ) Using the ERD you created in Task 1 , develop a create.sql file that will create a database named grubhub. Using the grubhub database, include statements...

Include your understanding of environments. A definition and at least three citations from our class text should be included. *teaching with the brain in mind. Describe and elaborate upon the need to...

Now that you know how to model a database, write create statements and add records to a database, let's look at an example end to end! Task 1: Create an ERD (15 pts) 1. Using the business rules...

The a * Fashion now requires a partial implementation of the design made in Assignment Part 1 . To keep consistency between the assignments, database specification containing the ER diagram and the...

Part 1: Practicing Problem Analysis, Design, and Coding Step 1. Problem Statement A company named Acme Software Company needs to develop a Java application that can maintain software purchasing...

Suppose you are a database developer at a XYZ data development company, you got a new project to develop a database system. The system is a ticket booking system for attending Jerash Festival. This...

Which of the nine principles for sustainability do most organizations or companies find the most difficult to follow in the Kingdom of Saudi Arabia? Why do customs or laws make it difficult to...

Use appropriate computer software to diagonalize (if possible) the following matrices. (a) (b) (d) 1110 1000 00011 00014 11200 2100 21100 0005 0110 0]10 3000

(11) Use either indirect proof or conditional proof to derive the conclusions of the following symbolized arguments. 1. (x)[(Ax Bx) Cx] 2. (x)[(Cx Dx) Ax] / (x)Ax

1. Analyze the balance sheet line items by calculating AVG, Percentage Change and CAGR. What do the balance sheet trends imply about the operations of the Be Our Guest business? 2. Calculate the...

IN Page 3: Page 4: Page 5: You are presented with two options to teance some receivables- Option Is a 49 day loan secured against receivables from Finance Co. and Option 2 is a to inventory loan from...

An ion with charge q = 5.7 1019 C and mass m = 5.4 1026 kg enters a magnetic field of 1.5 T, directed into the page. The ion enters with a speed of 8.9 106 ms1. a) Draw a diagram showing this...

Sami wants to purchase a car and he needs to borrow $60,000 to be paid off in equal annual payments over 10 years period. The interest rate is 12% compounded monthly. The expected annual inflation...

Philippine Corporation of Manila paid P1,920,000 for a 40% interest in Taiwan Company on January 1, 2009 when Taiwan Companys net assets totaled 3,000,000 NT Dollars and the exchange rate for NT...

CMST 1110 Conflict Resolution Worksheet Conflict is a positive element of all groups. Without it, people would not be challenged to think beyond their everyday, routine boundaries. When a variety of...

List and briefly explain how integrity controls can be used for database security.

Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Explain the reasons why some experts are against the practice of denormalization.

For the data from Problem 2 in this chapter, address the following questions, using the information provided in the accompanying SAS output. a. State the regression model that incorporates the...

Refer to the data in Problem 19 of Chapter 5. The relationship between the rate of owner occupancy of housing units (OWNEROCC) and the median monthly ownership costs (OWNCOST) was studied in that...

Using the data from Problem 2 in Chapter 5 and/or the SAS output given here, answer the following questions about the separate straight-line regressions of SBP on QUET for smokers (SMK = 1) and...