style=”color:rgb(40,40,40);background-color:transparent;”>Employees of this company are hired by the owner only on an hourly or salary basis. Employees have the following attributes:
Can you help me create a conceptual ER model for using the information below:
style=”color:rgb(40,40,40);background-color:transparent;”>Employees of this company are hired by the owner only on an hourly or salary basis. Employees have the following attributes:
· Employee ID: a unique five-digit identifier. Created to be distinctive within the company.
· Position/Title: the position each employee holds. Used to determine the types of customers and documents each employee is qualified to see.
· Name: the first name, middle name, and last name of the employee. It may not be unique since several employees could share a common name.
· Email: the email address is assigned
· Hire Date: the date the employee was hired. It is not a unique date.
· Pay Date: the date of the upcoming date of pay. This date is not unique since everyone will receive their payments on the same day.
· Phone Numbers: the main phone number is the same for everyone. Each employee has a unique extension number that can be used to call the employee directly.
Owner
The Owners have control of all documents and supervise all employees. Owners have the following attributes:
· Employee ID: a unique five-digit identifier. Created to be distinctive within the company.
· Position: the position each employee holds. Used to determine the types of customers and documents each employee is qualified to see.
· Name: the first name, middle name, and last name of the employee. It may not be unique since several employees could share a common name.
· Email: the email address is assigned
· Hire Date: the date the employee was hired. It is not a unique date.
· Pay Date: the date of the upcoming date of pay. This date is not unique since everyone will receive their payments on the same day.
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
