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.
![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 $](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F29205d83-83ce-4e53-88da-a8624b56c47c%2Fd1a89823-47f1-4b8e-b987-9c332413f107%2Fygynmxp_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
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.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)