Task 1: Create an ERD (15 pts) 1. Using the business rules below, create an ERD using LucidChart. ● ● Business Rules for

[answerhappygod]

Task 1 Create An Erd 15 Pts 1 Using The Business Rules Below Create An Erd Using Lucidchart Business Rules For 1 (185.73 KiB) Viewed 47 times

Task 1 Create An Erd 15 Pts 1 Using The Business Rules Below Create An Erd Using Lucidchart Business Rules For 2 (152.81 KiB) Viewed 47 times

Task 1 Create An Erd 15 Pts 1 Using The Business Rules Below Create An Erd Using Lucidchart Business Rules For 3 (171.07 KiB) Viewed 47 times

Task 1: Create an ERD (15 pts) 1. Using the business rules below, create an ERD using LucidChart. ● ● Business Rules for the GrubHub Database You have been asked by the GrubHub drivers of Omaha to help them track customer orders. In a recent meeting, you were able to develop these business rules with their help: Customers can order from many restaurants. ● ● 0 Restaurants may have orders from many customers. A driver is assigned to the unique order between a single customer and restaurant at a given date and time. Customers should be tracked by their number, name, address, phone number and payment ID. ● 0 Make sure to include all needed entities, attributes, relationships and keys needed. Double check that you have the right data types assigned for each attribute. Look for M:N to relationships and repeating groups. Adjust your model as needed. ● Restaurants should be tracked by their number, name, payment ID, address, phone number and cuisine. Orders will be assigned a unique number and timestamped. Drivers want to track the status (placed, out, cancelled and fulfilled) of each order. Drivers have a unique ID number assigned by corporate. We will also need to track their name, phone number, license plate number, drivers license number, payment ID and status (active/inactive). GrubHub has a proprietary accounting module that will handle all monetary transactions using the assigned payment IDs. 2. Export your ERD as pdf file and save that file named with your last name. This will be one of the files you submit for this assignment.
Task 2: Make the CREATE script (15 pts) 3. Using the ERD you created in Task 1, develop a create.sql file that will create a database named grubhub. MAY SP 4. 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. 0 Make sure to end each statement with a semicolon (;) o The creation scripts we have used in class are a great guide! 5. Test running your create.sql file in our development environment. Adjust your script as needed. 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. ALUPEN 1 April wipe 1221 Ave Om ZApi wagtis 1211 Ave, Omat Si Cept ASD 11 E2 PRE8011 ar test 1 Andy Diver 24 PL pt46033 201 402-345-419" 403-863-4287 234-433-3437 435-38 3291 PL 13438 Pau Bo 23434 Paunah tum BETSA / DIPER 12290/ DIY s 482 LA LAME Pens IN 46011 EL. Pewnes. 14001) 1143 Pet IN 46211 BETE CHINA 21428ML PE IN 46211 driver 4820 My Math 482 Charity Cabere TERES PH Meries 42623 Brenden ME 70023 my oth Leah Peters Task 4: Submission (5 pts) ahora NEE HILPMLN 88-100 Pest fond 87-893-108 Perfeed 416-283-2188 Breakfast 788-278-82 Steakhouse 418-987-3188 Bea ensalate van ahana (200) 987-2200UCESS 818 608-0828 E27 147 212-6193 KUALTY 312 284-9084 CLASE 200 987-2280 UCES 3091477-8845 ALAR C04790040 DED972937 011083 428372225 CO400049 4427814 de status ander date 444802 antive DEZZ ANIVE 71887) live 384452 V 444882 v BCBSE native 7. Test running your create.sql file in our development environment. Adjust your script as needed. PACHE 3/30/2020844 9/30/2020 30 AM 8/30/2020 10 fulfid 3/30/2020 10 4 9/30/2032-13 44 sed
7. Test running your create.sql file in our development environment. Adjust your script as needed. Task 4: Submission (5 pts) 8. Upload all of the files needed to complete the steps above to the dropbox in our online class. Please do not zip together these files. Your files should include: An ERD PDF document. ● A Create.sql containing SQL to create your tables and insert data. 9. Then Submit! I METROPOLITAN Community College Revised: Spring 2019