6. Break the list in Figure 1-31 into tables, each with a single theme. Create you think necessary. 7. Show how the tables you created for question 1.12 solve the three problem identified in this chapter.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
6. Break the list in Figure 1-31 into tables, each with a single theme. Create ID columns as
you think necessary.
7. Show how the tables you created for question 1.12 solve the three problems of lists
identified in this chapter.
FIGURE 1-31
The Veterinary Office List-Version Two
G
H.
K
PetName
2 King
3 Teddy
4 Filo
5 AJ
6 Cedro
7 Woolley
8 Buster
9 Jedah
PetDOB
27-Feb-12 Downs
OwnerFirstName
OwnerPhone
Date -
17-Aug-14 S
5-Sep-14 S
Charge
65.00
1
PetType
Dog
Cat
PetBreed
Std. Poodle
Cashmier
Std. Poodle
Collie Mix
OwnerLastName
OwnerEmail
Service
Marsha
Richard
Marsha
Liz
Richard
201-823-5467
201-735-9812
201-823-5467
201-823-6578
201-735-9812
201-735-9812
201-634-7865
210-634-2345
Marsha Downs@somewhere.com Ear Infection
Richard James@somewhere.com Nail Clip
Marsha Downs@somewhere.com
Liz.Frier@somewhere.com
Richard James@somewhere.com Nail Clip
Richard James@somewhere.com Skin Infection
Miles.Trent@somewhere.com
Hilary.Evans@somewhere.com
1-Feb-11 James
17-Jul-13 Downs
5-May-13 Frier
6-Jun-10 James
27.50
Dog
Dog
Cat
Cat
5-May-14 $
5-Sep-14 $
3-Oct-14 $
5-Oct-14 S
One year shots
42.50
27.50
35.00
Unknown
???
Richard
Miles
Unknown
James
Dog
Cat
Laceration Repair
Booster Shots
Border Collie
11-Dec-09 Trent
1-Jul-06 Evans
127.00
111.00
Abyssinian
Hilary
4-Nov-14 $
Transcribed Image Text:6. Break the list in Figure 1-31 into tables, each with a single theme. Create ID columns as you think necessary. 7. Show how the tables you created for question 1.12 solve the three problems of lists identified in this chapter. FIGURE 1-31 The Veterinary Office List-Version Two G H. K PetName 2 King 3 Teddy 4 Filo 5 AJ 6 Cedro 7 Woolley 8 Buster 9 Jedah PetDOB 27-Feb-12 Downs OwnerFirstName OwnerPhone Date - 17-Aug-14 S 5-Sep-14 S Charge 65.00 1 PetType Dog Cat PetBreed Std. Poodle Cashmier Std. Poodle Collie Mix OwnerLastName OwnerEmail Service Marsha Richard Marsha Liz Richard 201-823-5467 201-735-9812 201-823-5467 201-823-6578 201-735-9812 201-735-9812 201-634-7865 210-634-2345 Marsha Downs@somewhere.com Ear Infection Richard James@somewhere.com Nail Clip Marsha Downs@somewhere.com Liz.Frier@somewhere.com Richard James@somewhere.com Nail Clip Richard James@somewhere.com Skin Infection Miles.Trent@somewhere.com Hilary.Evans@somewhere.com 1-Feb-11 James 17-Jul-13 Downs 5-May-13 Frier 6-Jun-10 James 27.50 Dog Dog Cat Cat 5-May-14 $ 5-Sep-14 $ 3-Oct-14 $ 5-Oct-14 S One year shots 42.50 27.50 35.00 Unknown ??? Richard Miles Unknown James Dog Cat Laceration Repair Booster Shots Border Collie 11-Dec-09 Trent 1-Jul-06 Evans 127.00 111.00 Abyssinian Hilary 4-Nov-14 $
Expert Solution
Step 1

Access organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a spreadsheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers.

Image depicting three tables in datasheets

Each row is more correctly called a record, and each column, a field. A record is a meaningful and consistent way to combine information about something. A field is a single item of information — an item type that appears in every record. In the Products table, for instance, each row or record would hold information about one product. Each column or field holds some type of information about that product, such as its name.

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY