Question
Develop a data model of the proposed employee database utilizing crows foot notation. You are to utilize the entity and attribute names exactly as written,
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)
Step by Step Solution
3.46 Rating (146 Votes )
There are 3 Steps involved in it
Step: 1
I can describe the proposed data model for the employee database using Crows Foot Notation Entities ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started