Our Services

Get 15% Discount on your First Order

Let’s consider the following scenario: Papa Georgeo (AKA PG) is

September 23, 2022

Let’s consider the following scenario:

Papa Georgeo (AKA PG) is opening a Pizzeria and he needs a database to capture and maintain the data for the entities Sales, Customers, Products, Purchase, Suppliers, and Employees.

Business Needs:

PG would like to capture all the sales data with the details of every order. An order could be consisted of multiple items. For example, a customer could order 3 large pizza, 1 bread sticks, and 2 beverages in one order with one order ID. The Sales schema should capt
ure and maintain order date, customer ID, Order Time, Sub Total, Tax Amount, Total Due, Order Item, Qty, Price Charged for each item, Discount Amount for each item etc. PG is going to offer a club card (AKA PG Card) for his customers which they will hand it to the cashier to get points (those points are known as, you guessed it correctly, PG points! ???? ) every time they buy anything from the pizzeria. A customer can get a free pizza when he/she has accumulated enough points. In addition, PG would like to track who is buying what so he can create different promotions for his customers with that information. The restaurant will accept cash, checks, and all major credit cards as payment method.

Note: Find the complete question in the attached document

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Why is state-sponsored espionage more concerning than traditional corporate espionage?

Why is state-sponsored espionage more concerning than traditional corporate espionage? Research to determine how encryption in transit or encryption at rest would better protect data against this type of crime? What are the elements of a defense in depth strategy to manage the potential risk? What access models and

Book of Amos, Habakkuk, and Malachi

Based on Hill & Walton chapters 35, 40, 44; videos; and your personal experience answer the following questions: How would you summarize the messages of Amos, Habakkuk, and Malachi? Does our world still struggle with social oppression, the issue of theodicy, and religious ritualism without a covenant relationship? Are the

TOPIC: Are fraternities too dangerous for college students? The following essay should be written by using information from this source:

TOPIC: Are fraternities too dangerous for college students? The following essay should be written by using information from this source: information to access the short book: username: [email protected] password: Tommymipeti04! Submit your Final Draft here and it will be graded by your instructor. Be sure to include all sections of the paper

Instructions For this assignment, you will create a new product

Instructions For this assignment, you will create a new product or service line for Amazon. In your analysis, include the following items:  Provide a brief descriiption of the product or service.  Explain how the new product or service line fits into the firm’s strategy and new mission

In recent years, there has been much conversation about Critical

In recent years, there has been much conversation about Critical Race Theory with many states, including Texas, prohibiting teaching it or discussing racism, sexism, etc. Define and explain Critical Race Theory. What is it? How did it originate? What are the arguments for and against it? What is your opinion,

Label each entry as you do them whether it’s the

Label each entry as you do them whether it’s the title or numbers. Take a look at the requirements and example below and what’s attached. What’s required? Three learning journal entries per week (described below). At least one journal entry per week must address our semester reading, Our Own

1) Explain why companies issue convertible securities. 2) Discuss the

1) Explain why companies issue convertible securities. 2) Discuss the similarities and the differences between convertible debt and debt issued with stock warrants. Answer: Professor and class, Convertible bonds have the option of conversion into a common stock at a specified price during a particular period. Stock purchase warrants

Hi all, This course homework is Direct reading of Industrial

Hi all, This course homework is Direct reading of Industrial Organization (ECO632). The task is: Choose three or more papers to write a proposal based on these papers, raise some interesting questions based on those papers that you think it is possible to address in your future research. In the research

Spring constant What to submit: A lab report is required.

Spring constant What to submit: A lab report is required. Submit one pdf of the Lab report You have one week to work on this lab. Lab Manual: Here is the Lab manual: SpringConstantLab Download SpringConstantLab Simulation to be used for this Lab: masses-and-springs-PHET (Links to an external

choose a health care statistic that health care managers would

choose a health care statistic that health care managers would use, such as one of the following: Hospital-acquired condition (HAC) Emergency department visits Labor and delivery suite usage Ambulatory surgery procedures Hospital death rates Cesarean-section rate Wait time Adverse drug events Research your chosen statistic, and provide information from an

Select from one or more of the three options below for your Week 5 Initial Post. 1. Review Table 9.4 on page 223. Which one of the components do you

Select from one or more of the three options below for your Week 5 Initial Post. 1. Review Table 9.4 on page 223. Which one of the components do you think is the easiest for you to implement? Why? Which component is the most difficult for you to implement?

Assignment Instructions For this assignment, write thorough and thoughtful responses

Assignment Instructions For this assignment, write thorough and thoughtful responses to the following questions: Introduction What was most the challenging aspect of creating this assignment? What did you learn about yourself as a writer? What might you do differently the next time you write this type of assignment knowing what

Describe two different ways that the two sets of competencies

Describe two different ways that the two sets of competencies (NAEYC and Whole Leadership) align or are similar. Provide a reason for each of your stated alignments. For your own experiences, choose EITHER an area of strength OR an area of growth from the Whole Leadership Framework. Share with your

For the first CAP, we are going to set the

For the first CAP, we are going to set the foundation for your Critical Assignment due in week 8. Professionals in the field of Kinesiology work with a diverse population of participants ranging from athletes, clinical patients, fitness enthusiasts, etc. In order to optimize performance, it is implied that physical ability

What would you propose for the NY State Legislature to lift the ban on

In December 2014, NYS Governor Cuomo banned High Volume Hydraulic Fracturing (fracking) as the NYS Department of Health (DOH) issued a report explaining the reasons for recommending the ban (see BlackBoard for the report). It should be noted that New York had a de facto ban on fracking for over

Airbus and a gap analysis of principles and leadership styles within

Description A recent survey of senior executives from 197 companies worldwide with sales exceeding $500 million found that less than 15% compared the business results with the strategic plan performance and delivered only 63% of their potential performance (Mankins & Steele, 2005). Some top-level and mid-level managers identify misaligned goals

Your second homework for next week consists of composing at

Your second homework for next week consists of composing at least 3 further annotations of papers that you are considering for inclusion in your literature review. In a second step, use these annotations and your growing awareness around the topic of your choice to populate a table/ a matrix/

Respond to at least two response posts made to your

Respond to at least two response posts made to your classmates. Your responses should be more than, “I agree.” Find ways to respond to your classmates, though different ideas, including articles that support or challenge and/or videos. Add your own experience and then ask questions that will help them to