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 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.
Dear, please refer to the SAME question: https://www.homeworklib.com/question/37666/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 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...
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...
. Create the ERD in your drawing tool for microsoft visio for the following problem; Construct an ERD to represent employees and positions. For employees, the ERD should record the unique employee number, first name, last name, department name, office number, hire date, and date of birth. For position, the ERD should record the unique position number, position name, and step number. Positions can be classified as management, associate, or other. Management positions have a salary range (minimum and maximum)...
Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make sure that you diagram parent-child relationships.) Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and department names should be kept....
Within c++ Create a simple Employee class with name, department, and title. Create an hourlyEmployee class (which inherits from the Employee class) for a basic payroll program to compute the net pay salary of hourly based employees. Your program should also find the average net pay for a small company. To define the class, include the appropriate data members, member functions, constructors, and access modifiers. For simplicity, use a constant tax rate of 30% to compute the tax amount. Employees...
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...
2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned a room. Each room is identified by...
C# visual studio This project tests your skills at building an Object-Oriented Programming project. The purpose is to calculate pay for various types of employees. Use your same file for your [Your Name] Review.cs that contains your 2D Shape classes. Submit only your [Your Name] Review.cs file. The classes will contain: Employee Abstract class with the following properties: EmployeeId int FirstName string LastName string Pay (abstract, read only) double Sales Concrete class inherits Employee. Contains the following properties: Draw double...
use java You are asked to create a record management system for a university. There are two type of employees in a university: Salaried employee: they are salaried, and they are paid by monthly salary Waged employee: they are on wage and paid biweekly You are asked to implement three classes: Employee, SalariedEmployee and WagedEmployee. We have the following properties, and you need to identify these properties and associate them with appropriate classes. name: name of the employee ssn: ssn...