Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Homework Help/Study Tips Expert

You need to produce a Data Model for the Green Bite Foods Company described below.

Green Bite Foods

Green Bite Foods is a small catering firm with 20 full time employees. Company also has about 50 casual employees which it can call on at very short notice. Green Bite Foods caters for private functions like weddings, parties and picnics. During a typical summer weekend they will cater for up to 15 functions or events. The company takes orders for functions and buys the needed supplies and also cooks and prepares the food.

Green Bite Foods has a set of 8 standard menus and also caters for special requests like wedding cakes, birthday cakes, retirement cakes etc. When potential customers call, the advisor would describe the available menus and corresponding prices. The customer would also be provided with a drinks menu.   If the customer decides to make a booking the advisor records the customer information and the information about the function (e.g. place, date, type, number of guests, which standard menu is needed, drinks, extras and the total price).  A copy of the booking form is then sent or faxed to the customer, which should be signed and returned with a deposit before the function is officially booked.  The remaining money is collected when the function is complete.  If the customer does not reply within one week they are sent a friendly reminder.

Each week the owner looks through the functions scheduled and orders the supplies – e.g. plates, and the raw ingredients needed such as bread, chicken, wine etc.  The owner would also make an assessment of the staffing requirements and will schedule the staff in advance.  The casual staffs are paid by cheque a few days after a function has taken place. The hourly rate for casual staff is £8.00.

The owner of Green Bite Foods has requested an information system in order to manage the processing of the various types of booking, cancellations, ordering of food supplies and payment of casual staff.  You must produce a data model for Green Bite Foods.

Deliverables

A report should includes the following sections:

1. An introduction detailing the purpose of the specification and the user environment. This should include a description of the issues or problems to be solved.

2. You must expand your specification to a System Specification. This must be aimed at the developer of the system and should include:

• Data Models of the proposed system
Conceptual Model – EERD (This must include entities, relationships, primary key constraints, cardinality and participation constraints, specialisation and generalisation.)

Logical Model – Mapped EERD (Map the conceptual model to a logical model using the relevant steps.  Carry out normalisation to 3rd normal forms and discuss the progression through 1st, 2nd and 3rd normal forms.  This mapped model also must additionally include all attributes and foreign keys.

• Use either the extended Crow’s Foot notation or Chen’s notation but do not mix the notations (i.e. use either one or the other but not both).

• Use any design tool which you feel most familiar with (i.e. Visio, MS Word or IBM Rational etc.)

3. A Data Dictionary detailing the data requirements of your proposed system.

4. A discussion of problems you encountered and how you endeavoured to solve them.

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M91464

Have any Question? 


Related Questions in Homework Help/Study Tips

For this assignment write a reflection paper that is a

For this assignment, write a reflection paper that is a minimum of three completely full pages. Reflect on the best, most rewarding experience that you have ever had as part of. Maybe this experience was in your work org ...

Historical analysis -choose an historic american time

Historical Analysis - Choose an historic American time period from the following list: 1700-1750, 1750-1800, 1800-1850, 1850-1900, 1900-1950, or 1950-2000 Next, analyze various aspects of American culture in terms of dru ...

The corporate culture -write a 2-3 page apa style critical

The Corporate Culture - Write a 2-3 page, APA style critical analysis of the ethical issues involved in the case below: NYSE and Richard Grasso The analysis should include the following: A short description of case Ident ...

Impact of child rearingdescribe the impact of child-rearing

Impact of Child Rearing Describe the impact of child-rearing styles on child development, note cultural variations in child-reading beliefs and practices. Respond in 400-600 words with a scholarly reference source.

Questionin 250-500 words write on each of these ten

Question: In 250-500 words write on each of these ten articles the literature reviews. Which problems have been investigated; which require further investigation or replication; which have not been investigated? 1. Borel ...

Assignment school wide behavioral support plan the final

Assignment: School Wide Behavioral Support Plan The Final Assignment is a 4- to 6-page paper that analyzes the following case study: Case Study Mr. Knightly has been a Special Education teacher at Jackson Elementary Scho ...

Essay questions -how did colonizers mapping affect the arab

Essay Questions - How did colonizers mapping affect the Arab world? And how did the Arab nation-state act on this mapping and respond to the major effects of colonization? Discuss through showing critical engagement with ...

Anthropology2pages anthropology essayfollow below

Anthropology 2PAGES ANTHROPOLOGY ESSAY FOLLOW BELOW INSTRUCTIONS PLEASE What is the "Out of Africa" hypothesis? What is the evidence for and against it? You have to use all the key for this research KEY POINTS FOR ESSAY ...

Ancillary services 2 assignmentplease view these short

Ancillary Services (2 Assignment) Please view these short video clips: Understanding Hospice Care https://www.youtube.com/watch?v=lFjLGYsOlfU What hospital pharmacists do https://www.youtube.com/watch?v=l6Nzmd7oZlM Radio ...

Objectiveassist the student on understanding on how an

OBJECTIVE: Assist the student on understanding on how an organization handle the work related issues and its impact to the organization. OUTCOMES: 1. Describe the importance of leadership and identify the skills of a lea ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro