
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
I have done up to question 7, and i got confused from question 8

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](https://content.bartleby.com/qna-images/question/09a865ef-cd53-432a-ba69-87fd7dbe2b35/6a5e6d93-9303-4830-8133-91e42c2bd3a0/342iy9_thumbnail.png)
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:

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

---
#### 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](https://content.bartleby.com/qna-images/question/09a865ef-cd53-432a-ba69-87fd7dbe2b35/6a5e6d93-9303-4830-8133-91e42c2bd3a0/vfapf4_thumbnail.png)
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:

---
#### 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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images

Knowledge Booster
Similar questions
- When a student does not declare a major at an institution, the major field is often filled with the value "Undecided." Is the null value represented by "Undecided"? Is it appropriate to set that as the default? Make a strong case for your answer.arrow_forwardFind a SQL query that computes a set difference and returns false positive(s) over a database with null values. You may show the correctness of your answer using an example.arrow_forwardPropose and explain good indices (tree, hash, cluster, etc.) to support the following query. You do not need to write the SQL statements. SELECT D.DName, S.SName FROM Students S, Departments D WHERE S.Did = D.Did %3Darrow_forward
- To be more clear, what do you mean when you say "interpolation of characteristics"?arrow_forwardExplain the fundamental ideas of ANNs in connection to two or three examples taken from the actual world. Explain your reasoning to me. Only work with typing and fully explaining this question is required. Should the response to our query take more than two hours, we will cut down on our time allotment. Rating This line should not be ignored.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY

Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON

Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education

Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY