Creating the Babbage Bookkeeping Database
Assignment 5: Creating the Babbage Bookkeeping Database
Problem: Babbage Bookkeeping is a local company that provides bookkeeping services to several small businesses in the area. The database consists of two tables.
- The Client table: This table contains information on the businesses that use Babbage’s services.
- The Bookkeeper table: This table contains information on the bookkeeper assigned to the business.
Instructions: Perform the following tasks:
- Create a new database in which to store all the objects related to the bookkeeping data.
- Save this database. The database must be named with Your Last Name + First Name + Assignment5. For example, if your name is John Smith, the file must be named: SmithJohnAssignment5. 5% will be deducted for the wrong filename.
- Create the Client table using the structure and data shown in the table below: Save the table as “Client Table.”
| Client Table |
| Field Name |
Data Type |
Field Size |
Primary
Key |
Description |
| Client Number |
Short Text |
3 |
Yes |
Client Number (Primary Key) |
| Client Name |
Short Text |
20 |
|
Name of Client |
| Address |
Short Text |
15 |
|
Client Street Address |
| City |
Short Text |
15 |
|
City |
| Zip Code |
Short Text |
5 |
|
Zip Code (5 Character Version) |
| Balance |
Currency |
|
|
Amount Owed for Services |
| Bookkeeper Number |
Short Text |
2 |
|
Number of Client’s Bookkeeper |
- Enter the data for the Client Table as shown in the table below:
- Create the Bookkeeper table using the structure and data shown in the table below: Save the table as “Bookkeeper Table.”
| Bookkeeper Table |
| Field Name |
Data Type |
Field Size |
Primary
Key |
Description |
| Bookkeeper Number |
Short Text |
2 |
Yes |
Bookkeeper Number (Primary Key) |
| Last Name |
Short Text |
10 |
|
Bookkeeper Last Name |
| First Name |
Short Text |
8 |
|
Bookkeeper First Name |
| Address |
Short Text |
15 |
|
Bookkeeper Street Address |
| City |
Short Text |
15 |
|
Bookkeeper City |
| Zip Code |
Short Text |
5 |
|
Zip Code (5 Character Version) |
| Hourly Rate |
Currency |
|
|
Hourly Rate |
| YTD Earnings |
Currency |
|
|
Year-to-Date Earnings |
- Enter the data for the Bookkeeper Table as shown in the table below:
- Set relationship and specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table). Save the Relationships.
Order from us and get better grades. We are the service you have been looking for.
