Identify what types of data needs to be stored in database

Assignment Help Database Management System
Reference no: EM131405671

Database Management Assignment: Gourmet Pizzas Project - Requirement Analysis and Conceptual Design

1. Background

Gourmet Pizzas is a pizza outlet at Charlestown. After years of managing the records manually, Gourmet Pizzas 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 Gourmet Pizzas's database based on the business requirements provided in this document.

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

2. Main Features and Business Requirements

Order Processing

Gourmet Pizzas takes orders via phone as well as through walk-in customers. Gourmet Pizzas provides both delivery and pickup services. When a customer orders via the phone, the customer's phone number is entered to the system along with the id of the person taking the order. If the customer has previously ordered by phone, the name and address appear on the screen. The customer is then asked for his 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 that in the computer, a new customer record is created and the order is taken. After the order has been taken, a verification process occurs whereby the assistant dials the number given and confirms the order with the customer. If it is not confirmed, the customer is recorded as a hoax and order is kept on hold (if and until the customer calls back in which case the verification process takes place before hoax is removed and order goes through). The time the call was answered as well as time the call was terminated is recorded for each phone order. For a walk-in customer, the customer's name is recorded to identify the order.

Each order contains date of order, one or more items, quantity of each item, price of each item, subtotal, discount amount (if any), discount code (if any), tax, total amount due, payment method, status, type (phone/walk-in) and description. If the payment is via card, a payment approval number is recorded. If the order is a delivery order, the driver who delivered the order is recorded.

There are different types of discount programs offered by Gourmet Pizzas. All discount programs are recorded in the database. A discount program has a discount code, start date of discount program, end date of discount program, requirements for discount, discount percentage (e.g. 5%) and a description.

Menu Items, Ingredients and Suppliers

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 and a list of suppliers who supply the ingredients. A supplier can supply many ingredients. Each ingredient can be supplied by many suppliers.

A stocktake is taken each week, where the actual levels of ingredients in store are recorded. This is then compared with suggested levels (based on orders for the week). This report is used by the store manager to order ingredients for the following week. Information about ingredient orders needs to be maintained in the database.

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), a 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 records needs to be maintained in the database.

3. Assignment (individual assignment)

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 in this document. There are two parts to be completed in assignment 1 as described below.

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 Gourmet Pizzas's database mentioned above.

Assignment submission format for the Requirements part: The requirements document MUST have the following sections:

  • Data Requirements - outlining the major data items
  • Transaction requirements - outlining the data manipulation and queries
  • Business Rules

You may interview your client (i.e. lecturer) for clarification and include your interview questions and responses

Part 2: EER Model with data dictionary

Draw an EER model for the requirements identified in Part 1. 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 with 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 requirements document MUST have the following sections:

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

Attachment:- Assignment File.rar

Reference no: EM131405671

Questions Cloud

What questions would be reasonable to ask the professor : The teacher of a class you're taking tells the class that he thinks students who often skip classes have twice the risk of failing the class compared to students who regularly attend class. To better understand his claim, what question(s) would be..
What is the explanatory variable in given study : What is the explanatory variable in this study?- What is the response variable in this study?- Give an example of a third variable that might at least partially account for the observed relationship.
Incentive to conduct operations at a domestic level : What is the corporate tax rate compared to individual tax rates? Please explain. Do large corporations have an incentive to conduct operations at a domestic level as opposed to outsourcing entities of the corporate to include employment?
Purchase pop and chips at the same convenience store : Hillary and Donald both purchase pop and chips at the same convenience store. They have different tastes for pop and chips, so Hillary buys 3 cans of pop and 10 bag of chips whereas Donald buys 15 cans of pop and 2 bags of chips. If they both have..
Identify what types of data needs to be stored in database : INFO6001: Database Management Assignment: Gourmet Pizzas Project - Requirement Analysis and Conceptual Design. In this assignment, you are required to develop a user requirements specification truly fulfilling the data requirements (identify what t..
What is karl demand for hamburgers at prices : a. What is Karl's demand for hamburgers at those prices? b. Calculate the (own-price) elasticity of demand for hamburgers at those prices. Is Karl's demand elastic or inelastic?
How-when will you evaluate the success of the new product : This milestone establishes a system to evaluate the ongoing success of a product or service as the marketplace and company dynamics evolve. This involves establishing measurable criteria of specific activities and mechanisms to assess current syst..
Industrial calamities in american history : The Pemberton Mill was a large factory in Lawrence, Massachusetts, which collapsed withoutwarning on January 10, 1860 in what is likely "the worst industrial accident in Massachusettshistory" and "one of the worst industrial calamities in American..
Draw a bar graph of the row percentages : Write a sentence that explains what would be measured by the row percentages for this table. Make your answer specific to this situation.

Reviews

len1405671

2/25/2017 5:14:23 AM

The lecturer will discuss the details of the requirements in class as well as act as the client of the system. You need to implement all the details mentioned in lecture as well as described in this document. You are encouraged to ask questions to the lecturer to clarify requirements. Method of submission: Both softcopy submission and hardcopy submission are required: zip all required files into one zip file. The file name MUST be identified by 4 sections: A1, your first name, your surname, and your student number, e.g., A1SimonLee1234567.zip. Please note: if your hardcopy submission and softcopy submission are not at the same time, the time of the later submission will be counted as your assignment submission time.

Write a Review

 

Database Management System Questions & Answers

  Prepare a database from scratch that contains at a minimum

prepare a database from scratch that contains at a minimum the elements listed below. the kind of database you create

  Create a new tab named sales data answers

Create a new tab named "test data answers". Create a new table on your new tab to display the following information: average value for meas 1 and average value for meas 2.

  Who were barons at the time of their appointment

Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date of appointment

  Describe the mechanism of attribute inheritance

Describe the mechanism of attribute/relationship inheritance. Why is it useful

  Create form to search for the title of a video

Create this form to search for the title of a video. Create the necessary Video table (with about 5 or 6 records in the interest of time) with the fields shown. Use any images you can find.

  Create database objects to track the construction projects

You will use a database template to enter data into the Events table. You will create a simple query, a form, and a report.

  Describe the different lobs that oracle supports

Describe the different LOBs that Oracle supports. What are they used for? How can they be stored in the database

  What are the ethical implication of the data challenges

Write a two page, single space, 12 point ft, inch margin paper on your impressions on the two topics: what are the data challenges you observe. what are the ethical implication of the data challenges.

  1 explain the concept of physical data independence and its

1. explain the concept of physical data independence and its importance in database systems2. explain what problems are

  How security policies can be utilized to mitigate each risk

Identify which U.S. compliance laws govern for each risk identified and summarize the implications. Evaluate how security policies, procedures, and practices can be utilized to mitigate each risk identified. Recommend appropriate security controls th..

  Describe the role of business process reengineering bpr in

question 1 what is the role of business process reengineering bpr in enhancing competitiveness? give examples to

  Create a new table and rename its field id to instructor id

CS102- Create a new table and rename its field ID to Instructor ID. Add five records to this table and save it as "Instructors". You may use an instructor's name more than once to specify that she teaches multiple courses.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd