Analyze the following business scenario and create an ERD. For each entity Identified, indicate the primary key, the relevant attributes, and the relationship among entities with cardinality. 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
Analyze the following business scenario and create an ERD. For each entity Identified, indicate the
primary key, the relevant attributes, and the relationship among entities with cardinality.
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
