Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions