Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

8.7 Explain how cultures influence the perception of time.

Answered: 1 week ago