Develop a data model of the proposed employee database utilizing crows foot notation. You are to utilize
Question:
Develop a data model of the proposed employee database utilizing crow’s foot notation. You are to utilize the entity and attribute names exactly as written, do not make any modifications. (After submission, a selection of three tables will be made by your professor as a sample of your work for grading purposes)
• EMPLOYEE (EmployeeID, RoleID, ManagerID, DepartmentID, EmpAddressID, FName, LName, Salary, HireDate, Probation, PersonaleMail, PersonalPhoneNumber) • ROLES (RoleID, PositionTitle, PositionDescription, ProbationLength, MinSalary, MaxSalary)
• DEPENDENTS (DependentID, EmployeeID, Relationships, FName, LName, DateOfBirth)
• EMPLOYEEPERSONAL (PersonalID, EmployeeID, DateOfBirth, SocialSecurityNumber, AllergyName, AllergyDesc, EpiPen, DisabilityName, DisabilityDesc, Gender)
• DEPARTMENTS (DepartmentID, FacilityID, DepartmentName, DepartmentDesc) • FACILITYADDRESS (FacilityID, CountryID, FacilityName) • EMPLOYEECONTACT (EmpContactID, EmployeeID, FacilityID, WorkExtension, OfficeNumber) • EMERGENCYCONTACTS (ContactID, EmployeeID, FName, LName, ContactNumber, ContactAltNumber)
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi