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 crows 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

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Tasks: Your group will be tasked with completing the following scenario: The client organization is continuing to expand their digital infrastructure and your team have been brought in as system...

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, do not make any modifications. (After...

Create an EER diagram using MySQL Workbench (Crow's Foot Notation) to support the described business scenario and its operations. After, translate the diagram into a DB schema consisting of tables...

Database Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will...

CIS336 Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be...

LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be given a business scenario for a University Medical...

Please come up with database report based on Aged care facility Management.Students are expected to develop and provide their own case study and then interpret that to create an ER Model of the...

I NEED ERD IN THIS QUESTION AND CONCEPTUAL DESIGN AND BUSINESS RULES ARE AS FOLLOWS. I NEED ERD ON LUCIDCHART OR ON VISIO PLEASE. YOU CAN EMAIL ME THE ANSWER TOO. Conceptual design of a database for...

Answer the following questions from the text. Use the Petes foot notation. For each problem: 1. Write a Pete's foot diagram describing all relationships. 2. Underneath each relationship in the...

Suppose, you are working as IT manager in a company, give two examples of structured and un-structured problems you may face.

A piece of iron placed on a block of wood makes it float lower in the water. If the iron were instead suspended beneath the wood, would the wood float as low, lower, or higher? Defend your answer.

Define normalization and explain detail about normal forms.

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...