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

1 Expert Approved Answer

Step: 1 Unlock

I can describe the proposed data model for the employee database using Crows Foot Notation Entities ... View full answer

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 Databases Questions!

Before you begin this assignment, be sure you have read the UMUC Family Clinic Case Study below and your Week 1 and Week2 syllabus readings, which discuss EHR functionality and Process...

Develop a data model of Freds Train Shops expenditure cycle activities related to the acquisition of office equipment and other fixed assets. Fred sometimes orders multiple pieces of equipment....

The Sassawinni First Nation is located adjacent to a town in northern Saskatchewan. The Nation is under the jurisdiction of the federal government's Aboriginal Affairs and Northern Development...

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

Santini Construction is evaluating a project to build a bridge over the Salmon River. The project is currently worth $14 million. In one year, when the construction is 30% complete, there will be a...

Units Beginning inveritory of 3 , 5 0 0 units that are 1 0 0 percent complete for materials and 2 9 percent complete for conversion. 1 5 , 8 0 0 units started during the period. thing invernory of 2...

The water table lies at a depth of 3 m below the ground level at a site that consists entirely of sands. A 7 m deep excavation is to be made with the use of anchored sheet piles to support the...

Just Sofas (JS) had begun the year full of promise with a new facility, restructured manufacturing process, and high hopes for its new ERP system. Most of the domestic furniture manufacturers had...

In a balanced three-phase wye-wye system the load impedance is . The source has phase sequence abc and Van= 120

Show how OS-RANK (T, x) operates on the red-black tree T of Figure 14.1 and the node x with x.key = 35. Figure 14.1 26 20 17 41 E--- 12 7 14 21 30 47 -------- -------- E---- ----- --- 4 1 16 2 (14...

In a paired-samples t-test, how do you find the degrees of freedom?

Which of the following is problematic about using experience to predict new hires' performance according to the readings?Organizations fail to understand that experience is highly transferable across...

Define each of the following terms: a. Data b. Information c. Metadata d. Enterprise resource planning e. Data warehouse f. Constraint g. Database h. Entity i. Database management system j....

How would Fitchwood's security have to be different if the data mart were made available to customers via the Internet?

For products 1, 2, and 7, list in one row and three respective columns that product's total unit sales; label the three columns Prod1, Prod2, and Prod7.

2. Describe some of the difficulties in generalizing the findings from these classic studies to real-life phenomena.

4. Some aspects of memory are likely universal. There is no evidence yet to show cultural differences in memory accuracy (Wang & Senzaki, 2019), memory abilities tend to decrease as people get older...

8.7 Explain how cultures influence the perception of time.