Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A family run restaurant has 6 employees - an owner, two chefs, and three waiters. The owner pays himself a base salary of $15,000/month and

image text in transcribed

A family run restaurant has 6 employees - an owner, two chefs, and three waiters. The owner pays himself a base salary of $15,000/month and partakes of 60% of the profit every month. The chefs each have a salary of $10,000/month along with a 20% share. each in every month's profit. The waiters have a monthly salary of $3000 each in addition to the money they make in tips. Create a database of these 6 employees which has the following information about each of them Name, Employee ID, Employee class ("?, for owner, C for chef and W' for water), and Salary. In addition, the chefs should have their cuisine of expertise listed in the database (for example, Italian" for Chef I and "French" for Chef 2) and the waiters should have their years of service to the restaurant listed in their database entry (for example, 3 for W1, 5 for W2,7 for W3) The primary objective of this program is to be able to view the statistics of the employees, especially their salaries. Using the concept of inheritance and polymorphism you are required to design this database. You are also required to write a driver program that tests the functionalities of the database. For example, run your program to output the statistics of each of these 6 restaurant employees for a month where the restaurant saw a profit of $6000 and the three waiters earned $1000, $1500 and $1700 in tips respectively. Let your user type in the profit for a particular month, along with the tips earned by the three waiters. Your program should display on screen a self-explanatory interface of the (6 employees with their personal statistics and of course their salaries. Run your program for at least three different months with different profits. What happens f the restaurant encounters a loss in a particular month? A family run restaurant has 6 employees - an owner, two chefs, and three waiters. The owner pays himself a base salary of $15,000/month and partakes of 60% of the profit every month. The chefs each have a salary of $10,000/month along with a 20% share. each in every month's profit. The waiters have a monthly salary of $3000 each in addition to the money they make in tips. Create a database of these 6 employees which has the following information about each of them Name, Employee ID, Employee class ("?, for owner, C for chef and W' for water), and Salary. In addition, the chefs should have their cuisine of expertise listed in the database (for example, Italian" for Chef I and "French" for Chef 2) and the waiters should have their years of service to the restaurant listed in their database entry (for example, 3 for W1, 5 for W2,7 for W3) The primary objective of this program is to be able to view the statistics of the employees, especially their salaries. Using the concept of inheritance and polymorphism you are required to design this database. You are also required to write a driver program that tests the functionalities of the database. For example, run your program to output the statistics of each of these 6 restaurant employees for a month where the restaurant saw a profit of $6000 and the three waiters earned $1000, $1500 and $1700 in tips respectively. Let your user type in the profit for a particular month, along with the tips earned by the three waiters. Your program should display on screen a self-explanatory interface of the (6 employees with their personal statistics and of course their salaries. Run your program for at least three different months with different profits. What happens f the restaurant encounters a loss in a particular month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

What are two advantages of encrypting data stored in the database?

Answered: 1 week ago

Question

What is human nature?

Answered: 1 week ago