Superdeli Pizza is a pizza outlet in Newtown. After years of managing the records manually, Superdeli Pizza has decided to computerise its records.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1. Background

Superdeli Pizza is a pizza outlet in Newtown. After years of managing the records manually, Superdeli 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 Superdeli 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.

2. Main Features and Business Requirements

Order Processing

Superdeli Pizza takes orders via phone as well as through walk-in customers. Superdeli 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.

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

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

Each ingredient has a code (unique), name, type, stock unit, description, the stock level at the current stocktake period, the date the last stocktake was taken, suggested current stock 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 the reordered levels at last stocktake, are used by the store manager to order ingredients for the following week.

Employees

Employees at the store can be divided into two types: instore staff those who work in the shop are paid hourly, and driver those who carry out deliveries and are paid by the number of deliveries. For each employee, there is an employee number, first name, last name, 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 of work 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 shift also stores the number of deliveries in the shift for a driver, and number of work hours in the shift for an instore staff. The orders a driver delivers during a shift are kept on the record.

Payment rates for instore staff 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, the total amount paid, payment date, payment period start date, payment period end date, and bank details of the employee.

3. Assignment Tasks (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 and related discussions in lectures. There are two parts to be completed in assignment 1 as described below.

You are required to write and submit a report that includes all the content of the two parts that are described below. The report must be in Microsoft Word (No mark will be given if the report is submitted in other file formats).

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 need to be stored in the database), transaction requirements (identify the important and frequent database operations – data manipulation and queries), and business rules (which is based on this document and elaborations in lecture) for the Superdeli Pizza’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

Hint: Sample requirements documents are discussed in weeks 2 and 3, and are available in appendices A and B of your main textbook.

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

 

Attachments:

Expert's Answer

217 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of