Question

List all business rules listed on the case study

Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a salesperson with a base salary of $50,000 per year plus 2-percent commission on the sales price for all sales he makes plus another 5 percent of the profit on each of those sales. For contract employees, the beginning date and end dates of their contract are stored along with the billing rate for their hours.                                    

 

 

1.1       List all business rules listed on the case study 


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
List all business rules listed on the case study
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • create a Crows Foot ERD using specilization ERD

    Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in.  For each department, the department name, internal mail box number, and office phone extension are kept.  A department can have many assigned employees, and each employee is assigned to only one department.  Employees can be salaried employees, hourly employees, or contract employees.  All employees are assigned an employee number.  This...

  • Crows Foot ERD for Granite Sales

    Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employeesand the department that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can havemany assigned employees, and each employee is assigned to only one department. Employees can salaried employees, hourly employees, or contract employees. All employeesare assigned an employee number. This is kept along with...

  • Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...

    Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...

  • help me in Question please

    You must exercise a number of classes while using the inheritance rules we have learned.In each department must be realized, in addition to what is detailed below:.get, set methods-Property for all variables.ToString () -Equals () -- Builders of three types we learned.1. Write an Employee Department that represents a regular employee. For the department to keep theThe following data:Employee's nameBase salary (integer).behavior:Wage calculation method (equal to base salary).2. SalesEmployee Department - Represents a sales employee. For a sales employee keep...

  • Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are...

    Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are as follows: It should allow employees to record time card information electronically It should automatically generate paychecks based on the number of hours worked & total amount of sales for commission-based employees It should have a web based interface to allow employees to interact with the system It should allow employee to operate ONLY on their own data records It should allow employees to...

  • Projects Case Study A construction company requires a database to record details about building projects. Each...

    Projects Case Study A construction company requires a database to record details about building projects. Each project has its own project number, name and employees assigned to it. Each employee has an employee number, name and job classification, such as engineer or computer technician. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent upon the employee's position. For example, one hour of a computer technician's time is billed at a...

  • Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are...

    Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are as follows: It should allow employees to record time card information electronically It should automatically generate paychecks based on the number of hours worked & total amount of sales for commission-based employees It should have a web based interface to allow employees to interact with the system It should allow employee to operate ONLY on their own data records It should allow employees to...

  • Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are...

    Software Architecture Please provide diagrams for all questions For the payroll system, some common requirements are as follows: It should allow employees to record time card information electronically It should automatically generate paychecks based on the number of hours worked & total amount of sales for commission-based employees It should have a web based interface to allow employees to interact with the system It should allow employee to operate ONLY on their own data records It should allow employees to...

  • Salary Lab In this lab you are going to write a time card processor program. Your...

    Salary Lab In this lab you are going to write a time card processor program. Your program will read in a file called salary.txt. This file will include a department name at the top and then a list of names (string) with a set of hours following them. The file I test with could have a different number of employees and a different number of hours. There can be more than 1 department, and at the end of the file...

  • Please help me write in C++ language for Xcode. Thank you. In this lab you are...

    Please help me write in C++ language for Xcode. Thank you. In this lab you are going to write a time card processor program. Your program will read in a file called salary.txt. This file will include a department name at the top and then a list of names (string) with a set of hours following them. The file I test with could have a different number of employees and a different number of hours. There can be more than...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT