Question: 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

Task 2: Make the CREATE script (15 pts) 3. Using the ERD

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. 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. Make sure to end each statement with a semicolon () 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.

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

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...

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...

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...

INFO 2 6 3 0 : REVIEW ASSIGNMENT SQL Now that you know how to create a database, add data to it , retrieve it , manipulate it , and change it , let's look at an example end to end! Task 1 : Write a...

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...

USING SQL ACCOMPLISH THE TASKS: Task 1: Write a create script: 1. Using the ERD pictured below, write all the table and constraint creation statements you would need to create the database in a...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

I can't seem to add my schema. I can try to add my data dictionary though. I dont think I have it right. Can someone that understands SQL look this over and help me correct my mistakes? Below is the...

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

Factoring and Outlining a Problem Japan Airlines has asked your company, Connections International, to prepare a proposal for a training school for tour operators. JAL wants to know whether Burbank...

Explain why gains and losses on the sale of capital assets are affected by managements estimates of the useful life and residual value of the assets.

Question 3 ( 2 5 Marks ) A virtual team should focus on achieving a common goal. Two of the biggest challenges involved in managing a virtual project team are developing trust and effective patterns...

Consider the following system of equations. 3x - 2x2 + 7x = 44 -2x + x2 + 4x- 13 6x x - Sx + Bxg- 55 (a) Write a matrix equation that is equivalent to the system of linear equations. 44 X2 13 X3 55...

Faye, Gary, and Heidi each have a one-third interest in the capital and profits of the FGH Partnership. Each partner had a capital account of $50,000 at the beginning of the tax year. The partnership...

II. Please try to analyze the following cases and write down the appropriate recoding process.. Payne Company purchased equipment in 2010 for $90,000 and estimated a $6,000 residual value at the end...

Equity instruments include all the following except: O a. B- Preferred stocks O b. C- Retained earnings O c. D- Bonds O d. A- Common stocks

Lucy factored $4,000,000 of accounts receivable with Ethel on a with recourse basis on May 1. (Assume the transaction meets the criteria to be classified as a sale.) Ethel assessed a finance charge...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

12. Explain the claim: Financial statement analysis is an integral part of business analysis.

1. Explain the relevance of auditing and the audit report (opinion) for financial statement analysis (Appendix 2A).

19. Identify at least five different internal and external users of financial statements.