Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

5 Pages
HOS651 People and Places

Airbnb has developed its reputation on the premise thatitprovidesvisitors with an ‘authentically’ local experience. This reputation for authenticity has increased Airbnb’s popularity ...

Course

HOS651

Type

Essay

Subject

University

William Angliss Institute

6 Pages
HMSV1102 Indigonous History, Identity and culture

The learner will prepare a reflection, summarizing the learner’s understanding of the course materials prior to their engagement of any course materials.  The learner is to write ...

Course

HMSV1102

Type

Essay

Subject

University

Bow Valley College

11 Pages
ECE 353 Cognitive Development of Infants & Young Children

1.The water table in your 3 to 5 center has been leaking – so staff provide water experiences in a creative manner until the table can be repaired.  One of the new experiences consists of a ...

Course

ECE 353

Type

Home Work

Subject

University

queen’s university

14 Pages
PSY 278 Human Growth And Development

Question : Assignment Overview This week, you will look for a news story on an individual and describe the lifespan developmental stage/age the individual is experiencing. Thinking like a developm ...

Course

PSY278

Type

Essay

Subject

University

Fortis College

COMP1140 Database and Information Management

Question

Answered

Question:

Delitaste Pizza Project – Requirement Analysis and Conceptual Design

  1. Background

Delitaste Pizza is a pizza outlet in Newtown. After years of managing the records manually, Delitaste Pizza has decided to computerise its records. You are tasked to design a database for the shop.

The proposed database system is developed in various modules, including requirements analysis, conceptual database design, logical database design, and physical database design. In this assignment 1, you are required to develop user requirements specification and the conceptual database model for Delitaste Pizza’s database based on the business requirements provided in this document and related discussions in lectures.

Your lecturer will act as your client and you can query him/her for any further information and clarifications.

Main Features and Business Requirements

Order Processing

Delitaste Pizza takes orders via phone as well as through walk-in customers. Delitaste Pizza provides both delivery and pickup services. When a customer orders, the customer’s phone number is entered into the system along with the id of the staff taking the order. If the customer has previously ordered, the name and address appear on the screen. The customer is then asked for his/her name and address, and then the order is taken. If the customer has not ordered before or if the name and address given do not correspond with what is recorded in the computer, a new customer record is created and the order is taken. For each phone order, the time the call was answered as well as the time the call was terminated is recorded. For each walk-in order, the time the customer walks in is recorded.

For a phone order, after the order has been taken, a verification process occurs whereby the staff dials the number given and confirms the order with the customer. If it is not confirmed, the customer is recorded as a hoax and the order is kept on hold (if and until the customer calls back in which case the verification process takes place before the hoax is removed and the order goes through).

Each order contains the date of order, the items ordered, the quantity of each item, the price of each item, the total amount due, payment method, order status, type

(phone/walk-in), and description. If the payment is via card, a payment approval number is recorded. For a phone order, if the order is a pickup order, the pickup time is recorded; if the order is a delivery order, the delivery time and address and the driver who delivered the order are recorded. For a walk-in order, only pickup is available, where the pickup time is recorded.

Menu Items, Ingredients, and Ingredient Order

Each item in the menu has an item code (unique), name, size and a current selling price. An item in the menu is made up of a number of ingredients. The ingredients and quantities used for the item are recorded in the database.

Each ingredient has a code (unique), name, type, description, stock level at current stocktake period, date last stocktake was taken, suggested current stock level, reorder level.

A stocktake is taken each week, where the actual levels of ingredients in store (i.e., stock levels of ingredients at the current stocktake period) are collected. The actual levels of ingredients in store, together with suggested current stock levels and reorder levels, are used by the store manager to order ingredients for the following week. Information about ingredient orders needs to be maintained in the database, including order number, date of the order, date received order, total amount, order status, description, quantity and price of all ingredients, and ingredient code.

Employees

Employees at the store can be divided into two types: those who work in the shop are paid hourly and those who carry out deliveries are paid by the number of deliveries. For each employee, there is an employee number, firstname, lastname, postal address, contact number, tax file number, bank details (bank code, bank name, account number), payment rate, status, and a description. Drivers also have a driver’s license number. Hours are not regular and a record is kept for each time an employee works – a shift (start date, start time, end date, end time). The orders a driver delivers during a shift is kept on the record.

Payment rates for shop workers and drivers are maintained in the database. Employee payments are made for each shift to the employee’s bank account. Employee payment record needs to be maintained in the database. It includes gross payment, tax withheld, total amount paid, payment date, payment period start date, payment period end date, and bank details of the employee.

Assignment Tasks

The proposed database system is developed in various modules, including requirements analysis, conceptual database design, logical database design, and physical database design. In this assignment 1, you are required to complete the first two stages of the database design, i.e., to develop user requirements specification and the conceptual database model for the database based on the business requirements provided.

Part 1: Requirements

In this assignment, you are required to develop a user requirements specification truly fulfilling the data requirements (identify what types of data needs to be stored in the database), transaction requirements (identify the important and frequent database operations – data manipulation and queries), and business rules for the Delitaste Pizza’s database mentioned above.

Part 2: EER Model with data dictionary

Draw an EER model for the requirements identified in Part 1. The EER must be included in the report (you also need to submit your original EER file). The EER Model must be shown in UML notation which is discussed in class and provided in our text.

The EER model should be accompanied by a data dictionary which includes entity type table, relationship type table and attribute table.

Assignment submission format for the EER Model with Data Dictionary part: The document MUST have the following sections:

  • EER Model
  • Documentation – Data dictionary details (description of entities, relationships and attributes)

COMP1140 Database and Information Management

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

29 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has emerged as one-stop solution for students in USA. We have assembled a team of experts to help students from different fields of study. With a pool of 3000+ experts, we are capable of providing top-notch quality plagiarism-free assignments within any short deadline. Our assignment writing services cover more than 100 subjects such as accounting assignment help, maths assignment help, economics assignment help, law assignment help and statistics assignment help.

More COMP1140 COMP1140 Database and Information Management: Questions & Answers

Q
icon

We aren't endorsed by this University

HOS651 People and Places

Airbnb has developed its reputation on the premise thatitprovidesvisitors with an ‘authentically’ local experience. This reputation for authenticity has increased Airbnb’s popularity,providing both negativeand positiveimpactsfor local communities.Debate therefore exists on how tobo ...

View Answer
Q
icon

We aren't endorsed by this University

HMSV1102 Indigonous History, Identity and culture

The learner will prepare a reflection, summarizing the learner’s understanding of the course materials prior to their engagement of any course materials.  The learner is to write about their understanding of Indigenous History, Identity and Culture. This can include: nation buil ...

View Answer
Q
icon

We aren't endorsed by this University

ECE 353 Cognitive Development of Infants & Young Children

1.The water table in your 3 to 5 center has been leaking – so staff provide water experiences in a creative manner until the table can be repaired.  One of the new experiences consists of a tray on which is provided a variety of beautifully shaped and sized glass containers, a sponge, a f ...

View Answer
Q
icon

We aren't endorsed by this University

PSY 278 Human Growth And Development

Question : Assignment Overview This week, you will look for a news story on an individual and describe the lifespan developmental stage/age the individual is experiencing. Thinking like a developmentalist, you will apply concepts from the book and describe what may have contributed to this perso ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?