Design and develop a desktop application in C# using windows form application for Pizza Mania. The aim of this development is to create a Point of Sale for Pizza Mania, a growing pizza shop. Following is the sample design but you can design your own that suits, attract and easy to use. You are also required to design the local db schema to record the sale and inventory. Pizza Mania - Point of Sales Regular Pizza Large Pizza Pan Pizza Fajita Rs.399/- Fajita Rs.599/- Fajita Rs.999/- Spicy Rs.399/- Spicy Rs.599/- Spicy Rs.999/- Generate Bill Chicken Tikka Rs.499/- Chicken Tikka Rs.699/- Chicken Tikka Rs. 1099/- Manid Keep in your mind that if Pizza Mania's inventory of the day is showing 90 pizzas of all three flavors and sizes, a salesperson will not sale more than inventory unless an Admin of the Pizza Mania will add more inventory from his login screen. Therefore, two users, salesmen and admin panels are required with appropriate rights. Sales person is only allowed to sale the pizzas according to demand/order and upon every sale, the inventory must be updated automatically from the inventory table of this date. A salesperson can communicate/inform, Admin for adding more inventory when he see the less inventory. Once item sold, cannot be deleted from the db schema table of sale.
Design and develop a desktop application in C# using windows form application for Pizza Mania. The aim of this development is to create a Point of Sale for Pizza Mania, a growing pizza shop. Following is the sample design but you can design your own that suits, attract and easy to use. You are also required to design the local db schema to record the sale and inventory. Pizza Mania - Point of Sales Regular Pizza Large Pizza Pan Pizza Fajita Rs.399/- Fajita Rs.599/- Fajita Rs.999/- Spicy Rs.399/- Spicy Rs.599/- Spicy Rs.999/- Generate Bill Chicken Tikka Rs.499/- Chicken Tikka Rs.699/- Chicken Tikka Rs. 1099/- Manid Keep in your mind that if Pizza Mania's inventory of the day is showing 90 pizzas of all three flavors and sizes, a salesperson will not sale more than inventory unless an Admin of the Pizza Mania will add more inventory from his login screen. Therefore, two users, salesmen and admin panels are required with appropriate rights. Sales person is only allowed to sale the pizzas according to demand/order and upon every sale, the inventory must be updated automatically from the inventory table of this date. A salesperson can communicate/inform, Admin for adding more inventory when he see the less inventory. Once item sold, cannot be deleted from the db schema table of sale.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:Design and develop a desktop application in C# using windows form application for Pizza Mania.
The aim of this development is to create a Point of Sale for Pizza Mania, a growing pizza shop.
Following is the sample design but you can design your own that suits, attract and easy to use. You
are also required to design the local db schema to record the sale and inventory.
Pizza Mania - Point of Sales
Regular Pizza Large Pizza
Pan Pizza
Fajita
Rs.399/-
Fajita
Rs.599/-
Fajita
Rs.999/-
Spicy
Spicy
Spicy
Generate Bill
Rs.399/-
Rs.599/-
Rs.999/-
Chicken Tikka
Rs.499/-
Chicken Tikka
Chicken Tikka
Rs.699/-
Rs.1099/-
Manioa
Keep in your mind that if Pizza Mania's inventory of the day is showing 90 pizzas of all three
flavors and sizes, a salesperson will not sale more than inventory unless an Admin of the Pizza
Mania will add more inventory from his login screen.
Therefore, two users, salesmen and admin panels are required with appropriate rights. Sales person
is only allowed to sale the pizzas according to demand/order and upon every sale, the inventory
must be updated automatically from the inventory table of this date. A salesperson can
communicate/inform, Admin for adding more inventory when he see the less inventory.
Once item sold, cannot be deleted from the db schema table of sale.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education