View the step-by-step solution to:

CIS321 Week 5 Assignment Overview Linda Ballas Week 5 Homework: Physical Data Model (ERD) Physical Data Model Includes entities, attributes and...

I need help on this structured analysis and design assignment. It's creating a physical data model (relational schema) from a logical data model. I need help putting it together based on the part 1 solution.

Linda Ballas CIS321 Week 5 Assignment Overview
Background image of page 1
Week 5 Homework: Physical Data Model (ERD)
Background image of page 2
Show entire document
CIS 321Case Study ‘Employee Benefits System’ MILESTONE 4 - DATA MODELING – Part I (Logical ERD) SOLUTION Activity 1 – Entity Definition matrix The following entities described in the entity definition matrix were mentioned in the EBS case introduction. EMPLOYEE_PROFILE INVESTMENT INSURANCE DEPARTMENT The following entities described in the entity definition matrix were seen on the forms contained in the Milestone 3 description. EMPLOYEE_PROFILE CONTACT DEPARTMENT BUILDING The following entities described in the entity definition matrix were mentioned in the Milestone 4 description. DEPARTMENT BUILDING CONTACT EMPLOYEE
Background image of page 1
CIS 321Case Study ‘Employee Benefits System’ All of the above then leads to the following Entity Definition Matrix: Entity/Definition Matrix ENTITY NAME DESCRIPTION INVESTMENT An employee investment plan which includes 401k,  Company stock purchase options, and Savings Bonds. INSURANCE This includes automobile, home, and/ or renters insurance  offered through Conover’s Home/Auto department as well  as short-term and disability life insurance. CONTRIBUTION Monies withheld to be donated to charitable organizations  which currently include the United Way but with plans to  include many other types of organizations. EMPLOYEE or  EMPLOYEE_PROFILE An individual employee’s personal information  DEPARTMENT The department to which the employee belongs. BUILDING The building in which the employee works. CONTACT Represents a primary or secondary emergency contact. . Activity 2 – Logical ERD
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

The way to answer this question is ... View the full answer

Sol_physicaldatadesign.docx

Physical Data Design

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online