Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Department Dnumber Dname Mgr ID MgrStartDate 1 Headquarter 6668885555 6/5/98 4 Adminstration 8976664444 9/3/06 5 Research 3333445555 8/9/06 Employee EmployeeID Fname Lname Bdate Address City
Department | ||||||||||
Dnumber | Dname | Mgr ID | MgrStartDate | |||||||
1 | Headquarter | 6668885555 | 6/5/98 | |||||||
4 | Adminstration | 8976664444 | 9/3/06 | |||||||
5 | Research | 3333445555 | 8/9/06 | |||||||
Employee | ||||||||||
EmployeeID | Fname | Lname | Bdate | Address | City | State | Gender | Salary | Supervisor ID | Dnumber |
1234567894 | Jones | Vogg | 4/7/05 | Belvolt | Houston | TX | Male | 30000 | 145 | 5 |
3333445555 | Alicia | Bruce | 8/9/03 | Rosemaire | Dallas | TX | Female | 40000 | 345 | 5 |
6668885555 | Frankin | English | 2/3/95 | Voss | Austin | TX | Male | 25000 | 612 | 5 |
8976664444 | Rose | Abey | 8/3/96 | Oak | Austin | TX | Female | 30000 | 235 | 5 |
8976664444 | Smith | Narayen | 5/3/01 | Arlington | Dallas | TX | Male | 45000 | 1 | |
3333445555 | Paul | Kelly | 3/2/97 | Sugarland | Houston | TX | Male | 40000 | 189 | 4 |
3333445555 | Alinda | Robert | 9/3/04 | commerce | Dallas | TX | Female | 30000 | 451 | 4 |
6668885555 | Malisha | Ash | 3/2/01 | plano | Dallas | TX | Female | 25000 | 892 | 1 |
Please answer Question no 3
1. Make a database in MS Access as written above and set the appropriate row as Primary Key and give the table name " Department" | |||
2.Make a database in MS Access as written above and set the appropriate row as a Primary Key and give the table name " Employee" | |||
3.Establish the Relationship between the two tables. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started