Question: Create a restaurant POS database. Populate tables. All primary keys must be auto-generated. Show all code for createing tables. Include foreign key constraints. Waiters, cooks,

Create a restaurant POS database. Populate tables. All primary keys must be auto-generated. Show all code for createing tables. Include foreign key constraints.

Waiters, cooks, hosts, managers, customers, tables

invoices, payments, payment types, tips

inventory, specials, gift cards, loyalty cards

Capitalize SQL commands

Use indentation and blank lines for readibility

use consistent naming convention

inventory

The customer should be able to produce reports about what products sold each month.

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!

1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is identified by a...

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing company...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Question 2 Please 1. Modifying a Relational Database Scheme Recall this database schema from class, which could be used to keep track of orders from customers. Recall that boldface indicates a...

Carl Fenson of Winnipeg owned three taxicabs that operated for 24 hours a day (two shifts of 12 hours). Fenson worked one shift himself and hired drivers for the other shifts. At the time, in...

Conduct a two-sample ttest (Section 9.2) of the null hypothesis that the two treatment means are equal for each dot plot. Use = .05 and two-tailed tests. In the course of the test, compare each of...

II a state fails to repay a federal loan made to meet unemployment liabilies, what are the consequences frelect all that apply? The state must reduce the amount of unemployment insurance monty...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...