Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2017

    Question Unanswered: Are my relationships correct?

    *I am not asking for someone to do this assignment for me, I am just checking to see if I am doing this correctly!*

    My professor gave us a vaguely described homework assignment and I wanted to get some opinions on whether or not I was doing this correctly due to my not using MS access for quite a long time.

    Here is the description from our professor:

    "Submit an Access database for the following business rules.

    Each employee may have many dependents and each dependent is associated with one employee.

    Each employee is working in one department and each department has many employees.

    For each employee, we want to know his name, address, and highest educational degree.

    Each employee is of one of the two types: financial analyst or software developer. For financial analyst, we want to know his license number and if he is a CFA.

    For each financial analyst, we want to know what finance projects he has done. Each analyst may be in different projects and each project has many analysts.

    For software developer, we want to know the skills he has. Each software developer may have many skills (e.g., C#, SQL Server, …) and many developers many have the same skill."

    I have also attached a screenshot of what I've got so far. I would really appreciate any help, thank you!

    Click image for larger version. 

Name:	relationships.jpg 
Views:	8 
Size:	55.3 KB 
ID:	17343
    Last edited by wbuff; 04-25-17 at 21:20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts