Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo
When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.
CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de
Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat
A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;
Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every
Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of
Software failures : In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr
Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring
Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu
How a database system can improve their efficiency in an organisation?
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd