INFO6001: Database Management 1 Assignment 1: Popular Pizza Project
INFO6001: Database Administration 1 Task 1: Widespread Pizza Mission – Requirement Evaluation and Conceptual Design Due: 10am, Tuesday, February 25, 2020 WORTH 15% of ultimate course evaluation mark. 1. Background Widespread Pizza is a pizza outlet in Newtown. After years of managing the information manually, Widespread Pizza has determined to computerise its information. You might be tasked to design a database for the store. The proposed database system is developed in varied modules, together with necessities evaluation, conceptual database design, logical database design, and bodily database design. On this project 1, you might be required to develop consumer necessities specification and the conceptual database mannequin for Widespread Pizza’s database primarily based on the enterprise necessities supplied on this doc and associated discussions in lectures. Your lecturer will act as your shopper and you may question him/her for any additional data and clarifications. 2. Foremost Options and Enterprise Necessities Order Processing Widespread Pizza takes orders by way of cellphone in addition to via walk-in prospects. Widespread Pizza gives each supply and pickup providers. When a buyer orders, the client’s cellphone quantity is entered to the system together with the id of the workers taking the order. If the client has beforehand ordered, the identify and tackle seem on the display. The shopper is then requested for his/her identify and tackle, after which the order is taken. If the client has not ordered earlier than or if the identify and tackle given don't correspond with what are recorded within the pc, a brand new buyer report is created and the order is taken. For every cellphone order, the time the decision was answered in addition to the time the decision was terminated is recorded. For every walk-in order, the time the client walks in is recorded. For a cellphone order, after the order has been taken, a verification course of happens whereby the workers dials the quantity given and confirms the order with the client. If it's not confirmed, the client is recorded as a hoax and the order is stored on maintain (if and till the client calls again through which case the verification course of takes place earlier than hoax is eliminated and order goes via). Every order incorporates date of order, the objects ordered, amount of every merchandise, value of every merchandise, complete quantity due, fee technique, order standing, kind (cellphone/walk-in), and description. If the fee is by way of card, a fee approval quantity is recorded. For a cellphone order, if the order is a pickup order, the pickup time is recorded; if the order is a supply order, the supply time and tackle and the motive force who delivered the order are recorded. Menu Objects, Elements and Suppliers Every merchandise within the menu has an merchandise code (distinctive), identify, measurement and a present promoting value. An merchandise within the menu is made up of quite a few substances. The substances and portions used for the merchandise are recorded within the database. Every ingredient has a code (distinctive), identify, kind, description, inventory stage at present stocktake interval, date final stocktake was taken, advised present inventory stage, reorder stage, and a listing of suppliers who provide the substances. A provider can provide many substances. Every ingredient could be provided by many suppliers. A stocktake is taken every week, the place the precise ranges of substances in retailer (i.e., inventory ranges of substances at present stocktake interval) are collected. The precise ranges of substances in retailer, along with advised present inventory ranges and reorder ranges, are utilized by the shop supervisor to order substances for the next week. Details about ingredient orders must be maintained within the database, together with order quantity, date of the order, date obtained order, complete quantity, order standing, description, amount and value of all substances, provider quantity, and ingredient code. Workers Workers on the retailer could be divided into two sorts: those that work within the store are paid hourly and those that perform deliveries are paid by the variety of deliveries. For every worker, there's an worker quantity, firstname, lastname, postal tackle, contact quantity, tax file quantity, financial institution particulars (financial institution code, financial institution identify, account quantity), fee fee, standing, and an outline. Drivers even have a driver’s license quantity. Hours should not common and a report is stored for every time an worker works – a shift (begin date, begin time, finish date, finish time). The orders a driver delivers throughout a shift is stored on the report. Fee charges for store employees and drivers are maintained within the database. Worker funds are made for every shift to the worker’s checking account. Worker fee report must be maintained within the database. It contains gross fee, tax withheld, complete quantity paid, fee date, fee interval begin date, fee interval finish date, and financial institution particulars of the worker. three. Task Duties (particular person project) The proposed database system is developed in varied modules, together with necessities evaluation, conceptual database design, logical database design, and bodily database design. On this project 1, you might be required to finish the primary two levels of the database design, i.e., to develop consumer necessities specification and the conceptual database mannequin for the database primarily based on the enterprise necessities supplied on this doc and associated discussions in lectures. There are two components to be accomplished in project 1 as described under. You might be required to write down and submit a report that features all of the content material of the 2 components which can be described under. The report should be in Microsoft Phrase. Half 1: Necessities On this project, you might be required to develop a consumer necessities specification really fulfilling the information necessities (determine what sorts of information must be saved within the database), transaction necessities (determine the vital and frequent database operations – information manipulation and queries), and enterprise guidelines (which relies on this doc and gildings in lecture) for the Widespread Pizza’s database talked about above. Task submission format for the Necessities half: The necessities doc MUST have the next sections: · Knowledge Necessities – outlining the main information objects · Transaction necessities – outlining the information manipulation and queries · Enterprise Guidelines Trace: Pattern necessities paperwork are mentioned in weeks 2 and three, and can be found in appendices A and B of your major textbook. Chances are you'll interview your shopper (i.e. lecturer) for clarification and embrace your interview questions and responses Half 2: EER Mannequin with information dictionary Draw an EER mannequin for the necessities recognized in Half 1. The EER Mannequin should be proven in UML notation which is mentioned in school and supplied in our textual content. Please be aware: different notations (apart from UML) will NOT be accepted, i.e., zero mark will probably be given for the EER mannequin half if a notation apart from UML is used. The EER Mannequin must be accompanied with a knowledge dictionary which incorporates entity kind desk, relationship kind desk and attribute desk. Task submission format for the EER Mannequin with Knowledge Dictionary half: The doc MUST have the next sections: · EER Mannequin · Documentation – Knowledge dictionary particulars (description of entities, relationships and attributes) Pattern format for documenting the information dictionary is supplied under. Knowledge Dictionary Format: Use the format described in your major textual content in documenting the information dictionary. Following gives samples for reference solely. ENTITY TYPES Entity Identify Description Aliases Incidence Assortment A set is a bodily assortment of things within the library positioned at a specific bodily location part Bodily space of the library is split right into a set of collections ... RELATIONSHIP TYPES Entity identify Multiplicity Relationship Multiplicity Entity identify PhysicalCopy zero..* LocatedIn 1..1 Assortment ... ATTRIBUTES Entity Identify Attributes Description Knowledge Kind & Size Nulls Multi- valued Derived Default Scholar studentId A singular id given to each pupil char N N N Trace: Pattern EER fashions and documentation is supplied in Chapter 16 of your textual content. The lecturer will focus on the main points of the necessities in school in addition to act because the shopper of the system. It's essential implement all the main points talked about in lecture in addition to described on this doc. You might be inspired to ask inquiries to the lecturer to make clear necessities. Technique of submission: Softcopy submission is required: · zip all required information into one zip file. The file identify MUST be recognized by four sections: A1, your first identify, your surname, and your pupil quantity, e.g., A1SimonLee1234567.zip · It should be submitted to Blackboard - Evaluation - Assignment1 - Assignment1Submission Be aware: Ten % of the attainable most mark for the evaluation merchandise will probably be deducted for every day or half day that the merchandise is late. This is applicable equally to week and weekend days. Evaluation objects submitted greater than 5 days after the due date will probably be awarded zero marks.