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

2.Make a database in MS Access as written above and set

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

DATABASE 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...

1 OrderID Order Date Orderl EmployeelnChi Customerld CustomerName CustomerAddress CustomerCity 2 2 1001 10/21/2010 1 2345 1 Contemporary Casuals 1355 S Hines Blvd Gainesville 3 1001 10/21/2010 2 2345...

Instructions. HW 3 Attached Files: 1S_3063_HW3.xlsx (16.482 KB) HW 3 allows you to implement the data models we learned so far to an actual database. Please review the two lectures for Chapter 4...

--- DATABASE MANAGEMENT SYSTEMS 1. The Perron Electronics Assembly Company (PEAC) needs a database to track its training program. PEAC has several trainers and they offer various courses for their...

HW 3 allows you to implement the data models we learned so far to an actual database. Please review the two lectures for Chapter 4 before starting this assignment. This assignment requires you to...

GIVE STEP-BY-STEP INSTRUCTIONS ON HOW TO SOLVE EACH QUESTION ON ACCESS. Thanks. Each client has one representative in our company. Some of our employees are client representatives, while others are...

Our company, Sensational Fashion, Limited, which runs an e-commerce business, has decided to use Microsoft Access to create a relational database to keep track of our employees and clients. Here are...

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Give me another example with the same method of solution Goal and objectives 1 1. Database design process flowchart 2 2. Data model 3 3. Phases of database design 3 i. Requirements collection and...

You are the tax advisor at Professional Accounting Service Ltd and have been requested to calculate the TDS for the following transactions: Detail Rent payable to a foreigner Royalties payable to a...

Friendly College is a small, privately supported liberal arts college. The college uses a fund structure; however, it prepares its financial statements in conformance with ASC 958. Partial balance...

Nancy glves Manuel a crane to use in his buriness with a fair market value of $ 6 1 , 0 0 0 and a basis in Nancys hands of s$ 0 , 0 0 0 . No Federal gith tax was paid. What is Manuels basis for...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

The company openly shares plans and information with employees.

You serve on the professional development committee of a national association in your field.Your group recently sponsored a regional seminar on a pertinent topic in that field. The all-day seminar,...

You are an intern for the Eagleton Eagles, a minor league baseball team. Your supervisor, Matt Marks, has asked you to analyze the following data about the entertainment offered before games,between...