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

Define 3nf normal form, 3NF Normal Form A relation schema R is in 3NF ...

3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R

Explain the cartesian product, Explain the Cartesian product:  The Cart...

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim

State the objectives of object design, Determine the OBJECTIVES of  object ...

Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

Although how will the system recover, Although how will the system recover ...

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

Write modified version of transfer that avoids deadlock, Your OS has a set ...

Your OS has a set of queues, each of which is protected by a lock. To enqueue or dequeue an item, a thread must hold the lock associated to the queue. You need to implement an a

Why is database redesign necessary, Why is database redesign necessary? ...

Why is database redesign necessary? Database redesign is essential for two reasons. First, redesign is essential both to fix mistakes made during the initial database design. S

Developer competent in data cleansing-data scrubbing, Data Scrubbing 70,000...

Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Group by clauses-data manipulation language, Group By clauses  • It is ...

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

MIS, We face problem of stock Opening balance and closing balance in Minus...

We face problem of stock Opening balance and closing balance in Minus

Define database layer, Define Database layer? The database layer define...

Define Database layer? The database layer defines the data formats used in the database.

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