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

Part 1 describe a position on a topic in psychologyrespond

Part 1. Describe a position on a topic in psychology. Respond to a position on a topic in psychology with an evidence-supported counterargument. Rebut a counterargument to a position on a topic in psychology. Part 2 Expl ...

Identify 2-3 key areas of developmentidentify 2-3 key

Identify 2-3 key areas of development. Identify 2-3 key strengths to continue to build on.

Discussion questionin the textbook the story of ethics

Discussion question In the textbook, The Story of Ethics, Clark and Poortenga write: "According to postmodern philosophers, the project of justifying morality to the satisfaction of all rational persons is a failure. We ...

A critical analysis serves as a way for you to examine the

A critical analysis serves as a way for you to examine the different elements of popular culture discussed in this course. For your final written assignment, discuss the media forms you have written about for your previo ...

This examination will be available for you to take

This examination will be available for you to take beginning at 12:00 AM EST on Monday morning of Module 4 and will close promptly the following Sunday evening at 11:55 PM EST. It is suggested you write or print out the ...

Minimum words 300 include at lease one reference frompasser

Minimum words 300. Include at lease one reference from: Passer, M. Research methods: Concepts and connection (2014) Quasi-experimental designs are often used when conducting program evaluations on non-profit organization ...

Resource ch 1 of health care ethics 6th edmickey mantle

Resource: Ch. 1 of Health Care Ethics (6th ed.) Mickey Mantle received a liver transplant in 1995. He was a Baseball Hall of Fame center fielder for the New York Yankees whose liver was failing because of cirrhosis and h ...

You will identify a case study and then develop a

You will identify a case study and then develop a nutritional care plan forthe client associated with thatcase. Project tasks tobecompleted: Task 1: a. Choose from one ofthe following stages: pregnancy, infancy and child ...

Research methods in psychology assignmentthis assignment

RESEARCH METHODS IN PSYCHOLOGY ASSIGNMENT This assignment consists of three parts. PART 1: RELIABILITY Two researchers, Matt and Ian, were interested in studying cooperative behaviour between two children playing with to ...

Topic - nursing work as an extension of therapeutic nursing

Topic - Nursing work as an extension of therapeutic nursing relationship with the patients Nurses are a wonderful person with a highly respected professional who have a lot of responsibilities to look after the patients ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate