Improve efficiency of database, Database Management System

Assignment Help:

Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs, silver service waiters/waitresses, barmen/cocktail, entertainers  and so on. All potential employees are vetted to ensure they are of an appropriate standard and are paid a generous rate and bonus to ensure they remain loyal to the company and uphold its high values. The company has enjoyed considerable growth in spite of the economic downturn and the proprietor is now looking to set up an integrated database to support the operations of the company, which he hopes will be able to replace the disparate collection of applications currently in place

SACS currently has a client base of approximately 500 companies. A client places an order using a form which asks for the date and type of the event, its location, approximate numbers of guests, type of catering (buffet/sit down meal etc) and what type of entertainment (if any) is required.  The staff coordinator will then estimate the type and number of catering staff required and publish this online. Staff who are able and willing to work on that day will sign up for the event. As soon as the required numbers are obtained the event is flagged as 'full' and no more names are accepted.

In order to maintain high levels of service, clients are encouraged to give feedback on the service they get from SACS.  If there are any complaints about a particular staff member this will be recorded and anyone with more than two complaints against their name will be told their services are no longer required.  Catering staff are paid weekly. As they are self employed a schedule is generated listing the jobs they have covered, the hours for each job and a total for the week based on their stipulated hourly rate.  A quarterly bonus is paid to all catering staff based on the number of events they cover. 

The company has been experiencing problems with keeping track of staff bookings and is hoping that the new database will be able to solve these and improve efficiency.


Related Discussions:- Improve efficiency of database

What are the causes of bucket overflow in a hash file, What are the causes ...

What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflow? When a record is inserted, the bucket to that

What is the full form of odbc, What is the full form of ODBC ? ODBC stand...

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Sources of utilities for a dbms, There are three main sources of utilities ...

There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

Differentiate between primary and secondary storage, Differentiate between ...

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Develop network database ipad app, I want an iPad app that is a simple 1 pa...

I want an iPad app that is a simple 1 page form to complete with text. The Objective is to allow a few dozen people of the same organization (they're all on iPad) to open the app,

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

What are temporary tables, What are temporary tables? Temporary tables...

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

What is a select operation, What is a SELECT operation? The select oper...

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

What is magnetic disks, What is magnetic disks?explain it? Magnetic dis...

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work...

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

H. takouur

6/22/2013 11:09:04 PM

How a database system can improve their efficiency in an organisation?

Write Your Message!

Captcha
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