Question: Instruction Part 1 : 1 . Create a blank database with the file ( database ) named JMSTechWizard 2 . In this database, create a

Instruction Part1:
1. Create a blank database with the file (database) named JMSTechWizard
2. In this database, create a table in which to store the clients information. Use the name Client for the table. The Client table has
10 fields: Client Number, Client Name, Street, City, State, Postal Code, Telephone Number, Billed, Paid, and Technician
Number. Client Number is the primary key and is text data type. The Billed and Paid fields are currency data type. The
Technician Number field is number data type. All the other fields are text data type.
3. Add the records in the Table-1 to the Client table.
4. In the same database, create another table in which to store the technicians information. Use the name Technician for the table.
The Technician table has 9 fields: Technician Number, Last Name, First Name, Street, City, State, Postal Code, Hourly Rate,
and YTD Earnings. Technician Number is the primary key and is number data type. The Hourly Rate and YTD Earnings are
currency data type. All the other fields are text data type.
5. Add the records in the Table-2 to the Technician table.

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!