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 DATABASE Department Dnumber 1 Dname Headquarter Adminstration Research Mgr ID 6668885555 8976664444 3333445555 MgrStartDate 6 5 98 9 3 06 8 9 06 4 5 State Dnumber Gender Male Female Salary 30000 40000 Supervisor ID 145 Fname Jones Alicia Frankin 5 345 Employee Employeeld 1234567894 3333445555 6668885555 8976664444 8976664444 3333445555 5 Male 5 Lname Vogg Bruce English Abey Narayen Kelly Robert Ash TX TX TX TX Bdate 4 7 05 8 9 03 2 3 95 8 3 96 5 3 01 3 2 97 9 3 04 3 2 01 Rose Address City Belvolt Houston Rosemaire Dallas Voss Austin Oak Austin Arlington Dallas Sugarland Houston commerce Dallas plano Dallas 25000 30000 45000 612 235 5 1 Smith Paul Female Male Male Female Female 40000 189 TX TX TX TX 4 3333445555 30000 451 4 Alinda Malisha 6668885555 25000 892 1

Question

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  DATABASE Department Dnumber 1 Dname Headquarter Adminstration Research Mgr ID 6668885555 8976664444 3333445555 MgrStartDate 6 5 98 9 3 06 8 9 06 4 5 State Dnumber Gender Male Female Salary 30000 40000 Supervisor ID 145 Fname Jones Alicia Frankin 5 345 Employee Employeeld 1234567894 3333445555 6668885555 8976664444 8976664444 3333445555 5 Male 5 Lname Vogg Bruce English Abey Narayen Kelly Robert Ash TX TX TX TX Bdate 4 7 05 8 9 03 2 3 95 8 3 96 5 3 01 3 2 97 9 3 04 3 2 01 Rose Address City Belvolt Houston Rosemaire Dallas Voss Austin Oak Austin Arlington Dallas Sugarland Houston commerce Dallas plano Dallas 25000 30000 45000 612 235 5 1 Smith Paul Female Male Male Female Female 40000 189 TX TX TX TX 4 3333445555 30000 451 4 Alinda Malisha 6668885555 25000 892 1

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Database Processing Fundamentals Design And Implementation

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question