Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
Bartleby Related Questions Icon

Related questions

Question

I have done up to question 7, and i got confused from question 8

---
## Assignment 6: 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:
1. **Client table**: contains information on the businesses that use Babbage’s services.
2. **Bookkeeper table**: contains information on the bookkeeper assigned to the business.

### Instructions:
Perform the following tasks:
1. Create a new database to store all the objects related to the bookkeeping data.
2. Save this database. The database must be named with Your Last Name + First Name + Assignment6. For example, if your name is John Smith, the file must be named: SmithJohnAssignment6. 5% will be deducted for the wrong filename.
3. Create the Client table using the structure and data shown in the table below: Save the table as “Client Table.”

#### Client Table Structure

| 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         |             | Street Address                       |
| City               | Short Text| 15         |             | City                                 |
| Zip Code           | Short Text| 5          |             | Zip Code                             |
| Balance            | Currency  |            |             | Amount Currently Owed for Services   |
| Bookkeeper Number  | Short Text| 2          |             | Bookkeeper Number                    |

4. Enter the data for the Client Table as shown in the table below:

![Client Table Data Entry](https://example.com/client-table-image)

5. Create the Bookkeeper table using the structure and data shown in the table below: Save the table as “Bookkeeper Table.”

#### Bookkeeper Table Structure

| Field Name       | Data Type | Field Size | Primary Key | Description                   |
|------------------|-----------|------------|-------------|-------------------------------|
| Bookkeeper Number| Short Text| 2          | Yes         | Bookkeeper Number (Primary Key)|
| Last Name        | Short Text| 10         |             | Last Name of Bookkeeper       |
| First Name       | Short Text
expand button
Transcribed Image Text:--- ## Assignment 6: 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: 1. **Client table**: contains information on the businesses that use Babbage’s services. 2. **Bookkeeper table**: contains information on the bookkeeper assigned to the business. ### Instructions: Perform the following tasks: 1. Create a new database to store all the objects related to the bookkeeping data. 2. Save this database. The database must be named with Your Last Name + First Name + Assignment6. For example, if your name is John Smith, the file must be named: SmithJohnAssignment6. 5% will be deducted for the wrong filename. 3. Create the Client table using the structure and data shown in the table below: Save the table as “Client Table.” #### Client Table Structure | 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 | | Street Address | | City | Short Text| 15 | | City | | Zip Code | Short Text| 5 | | Zip Code | | Balance | Currency | | | Amount Currently Owed for Services | | Bookkeeper Number | Short Text| 2 | | Bookkeeper Number | 4. Enter the data for the Client Table as shown in the table below: ![Client Table Data Entry](https://example.com/client-table-image) 5. Create the Bookkeeper table using the structure and data shown in the table below: Save the table as “Bookkeeper Table.” #### Bookkeeper Table Structure | Field Name | Data Type | Field Size | Primary Key | Description | |------------------|-----------|------------|-------------|-------------------------------| | Bookkeeper Number| Short Text| 2 | Yes | Bookkeeper Number (Primary Key)| | Last Name | Short Text| 10 | | Last Name of Bookkeeper | | First Name | Short Text
### Task Instructions for Bookkeeper Table and Query Creation

#### Step 6:
**Enter the Data for the Bookkeeper Table:**

Below is the required data for the Bookkeeper Table, as shown in the image provided:

![Bookkeeper Table Screenshot](embedded_image.png)

---

#### Step 7:
**Create a Relationship Between Two Tables:**
1. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table).
2. Save the Relationships.

---

#### Step 8:
**Create the Following Queries:**

**8.1. Client Table Query:**
- **Details:** The query must display the `Client Number`, `Client Name`, and `Balance` fields for all clients located in `Empoer` with a balance greater than $300.00.
- **Save As:** `Q21-Client-Empoer Query`

**8.2. Client Query Display:**
- **Details:** The query should display the `Client Number`, `Client Name`, and `Address` fields for all clients with an address on `Mauv`.
- **Save As:** `Q22-Client-Mauv Query`

**8.3. Search Query by City:**
- **Details:** Create a query that allows the user to enter the city to search when the query is run. The query results should display the `Client Number`, `Client Name`, and `Bookkeeper Number`. Test the query by searching for those records where the client is located in `Portage`.
- **Save As:** `Q23-Client-City Query`

**8.4. Display Clients in Ascending Order:**
- **Details:** Create a query from the Client table to display the cities in ascending order. Each city should appear only once (i.e., no repeating city).
- **Save As:** `Q24-City-Sort Query`

**8.5. Bookkeeper-Specific Client Query:**
- **Details:** Display the `Client Number`, `Client Name`, and `Balance` fields for all clients where the bookkeeper number is 24 or 34 and the balance is greater than $300.00.
- **Save As:** `Q25-Client-Bookkeeper24-34 Query`

**8.6. Sorted Client-Bookkeeper Query:**
- **Details:** Display the `First Name`, `Last Name`, and `Hourly Rate` fields from the Bookkeeper table and the
expand button
Transcribed Image Text:### Task Instructions for Bookkeeper Table and Query Creation #### Step 6: **Enter the Data for the Bookkeeper Table:** Below is the required data for the Bookkeeper Table, as shown in the image provided: ![Bookkeeper Table Screenshot](embedded_image.png) --- #### Step 7: **Create a Relationship Between Two Tables:** 1. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table). 2. Save the Relationships. --- #### Step 8: **Create the Following Queries:** **8.1. Client Table Query:** - **Details:** The query must display the `Client Number`, `Client Name`, and `Balance` fields for all clients located in `Empoer` with a balance greater than $300.00. - **Save As:** `Q21-Client-Empoer Query` **8.2. Client Query Display:** - **Details:** The query should display the `Client Number`, `Client Name`, and `Address` fields for all clients with an address on `Mauv`. - **Save As:** `Q22-Client-Mauv Query` **8.3. Search Query by City:** - **Details:** Create a query that allows the user to enter the city to search when the query is run. The query results should display the `Client Number`, `Client Name`, and `Bookkeeper Number`. Test the query by searching for those records where the client is located in `Portage`. - **Save As:** `Q23-Client-City Query` **8.4. Display Clients in Ascending Order:** - **Details:** Create a query from the Client table to display the cities in ascending order. Each city should appear only once (i.e., no repeating city). - **Save As:** `Q24-City-Sort Query` **8.5. Bookkeeper-Specific Client Query:** - **Details:** Display the `Client Number`, `Client Name`, and `Balance` fields for all clients where the bookkeeper number is 24 or 34 and the balance is greater than $300.00. - **Save As:** `Q25-Client-Bookkeeper24-34 Query` **8.6. Sorted Client-Bookkeeper Query:** - **Details:** Display the `First Name`, `Last Name`, and `Hourly Rate` fields from the Bookkeeper table and the
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Text book image
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Text book image
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Text book image
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Text book image
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Text book image
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY