IT 235 Milestone One Guidelines and Rubric Overview: Database design is an integ
ID: 3747715 • Letter: I
Question
IT 235 Milestone One Guidelines and Rubric Overview: Database design is an integral step in the overall development of a database solution; a bad design can lead to many issues and problems with queries and potential expansion for any database. Getting the database design right is the first and most important step in creating a successful database. For this assignment, you will solve a database design situation as outlined in the scenario document. As you read through the narrative, be sure to pay close attention to the business requirements that the business owners note Prompt: Imagine that you are a consultant database designer and you have taken on a project that will require you to establish a database for a small pizzeria. If you have not already read the final project scenario document, do so now and determine the overall purpose of the database and the user requirements. Specifically, the following critical elements must be addressed I. Requirement Gathering: Read the provided scenario in order to determine the overall purpose of the database and the user requirements, specifically the following A. B. C. D. Define the purpose, goals, and objectives of the database as determined by the scenario Assess the user requirements associated with the database according to its owners and stakeholders Explain the business processes and restrictions that the database addresses in support of the user requirements. Explain what the end result of the database should be as determined by the scenarioExplanation / Answer
Purpose
Cougar Pizza Pies is a Pizza delivery services have been serving High-class pizzas for 20 years but have decided to take a new direction with next pizza.
Instead of focusing on an ever increasing a verity of specialty pizzas.
Goal
Our goal is to deliver the database with user interface where user can select various verity type ingredients on their pizzas and creating Cougar pizza to sell and deliver pizzas only between midnight and 4:00 AM .
Objective
Our Objective to make the onliune delivry of the Cougar pizza to deliver between midnight and 4 AM
to serve and following are the main key to our database
Order
Order
create table Order
(
OrderId integer not null,
WhenMade date not null,
Customer integer not null,
WayIssued varchar(20),
PaymentBy varchar(20) not null,
TotalPrice decimal(6,2) not null,
constraint pk_order primary key (OrderId),
constraint fk_ordercustomer foreign key (Customer) references Customer
);
Customer
Pizza
Delivery Boy
Purpose
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.