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

Problem about data mining for business intelligence, Do the 11.1 11.1 Cre...

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

Database, real life situations where database management system are most su...

real life situations where database management system are most suitable

What is substitutability, What is substitutability? Any method of a cla...

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

What is authorization graph, What is authorization graph? Passing of au...

What is authorization graph? Passing of authorization from single user to another can be shown by an authorization graph.

Identify the candidate keys, Consider the following six relation schemes an...

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for

Explain the steps for reduction of e-r model, Explain the steps for reducti...

Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

Explain the paths in the association network, Explain the paths in the asso...

Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Process of adjustment of inheritance, Process of Adjustment of inheritance ...

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

What are the different kinds of database end users, What are the different ...

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que

Design a query plan for distributed query, (a) Design a query plan for the ...

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

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