Please Help me With question # 1.16 show how the tables you create for question 1.15 solve the three problems of the list identified in this chapter 1.15 Ans: Three themes can be identified. They are: Pet details Owner detais Service details Pet details table: The following attributes, including "PetName," "PetType," "PetBreed," and "PetDOB," are included in the pet information table. PetName PetType PetBreed PetDOB King Dog Std.Poodle 27-Feb-15 Teddy Cat Cashmier 1-Feb-15 Fido Dog Std.Poodle 17-Jul-17 AJ Dog Collie mix 5-May-17 Cedro Cat Unknown 6-Jun-14 Woolley Cat Unknown ??? Buster Dog Border Collie 11-Dec-13 Jiddah Cat Abyssinian 1-Jul-10 Owner details:Owner Lname, Owner Fname, OwnerPhone, and Owner Mail are some of the properties found in the owner details table. Owner Last Name Owner First Name Owner Phone # Owner Email Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com Frier Liz 201-823-6578 Liz.Frier@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com Trent Miles 201-634-7865 Miles.Trent@somewhere.com Evans Hilary 201-634-2345 Hilary.Evans@somewhere.com ID column creation: OwnerID Owner Last Name Owner First Name Owner Phone # Owner Email 1 Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com 2 James Richard 201-735-9812 Richard.James@somewhere.com 3 Frier Liz 201-823-6578 Liz.Frier@somewhere.com 4 Trent Miles 201-634-7865 Miles.Trent@somewhere.com 5 Evans Hilary 201-634-2345 Hilary.Evans@somewhere.com Explanation: The information from the owner database may be found in the table below, with the ID columns specified to eliminate duplication. In order to address discrepancies, the Owner table has an additional ID field named Owner id and duplicate records (Downs, James) are eliminated. Service details table: The Service details table has the following properties, including "Service," "Date," and "Charge." Service Date Charge Ear infection 17-Aug-16 $66.00 Nail clip 5-Sep-16 $27.50 One year shots 5-May-16 $42.50 Nail clip 5-Sep-16 $27.50 Skin infection 3-Oct-1 $36.00 Laceration problem 5-Oct-16 $127.00 Booster shots 4-Nov-16 $111.00 ID column creation: ServiceID Service Date Charge 1 Ear infection 17-Aug-16 $66.00 2 Nail clip 5-Sep-16 $27.50 3 One year shots 5-May-16 $42.50 4 Skin infection 3-Oct-1 $36.00 5 Laceration problem 5-Oct-16 $127.00 6 Booster shots 4-Nov-16 $111.00 Explanation: The information from the service table is contained in the following table, which specifies the ID fields to be used to weed out duplicates. To prevent discrepancies, the duplicate entry (Nail Clip) in the service information database is eliminated and replaced with the service id as the ID field.
Please Help me With question # 1.16 show how the tables you create for question 1.15 solve the three problems of the list identified in this chapter 1.15 Ans: Three themes can be identified. They are: Pet details Owner detais Service details Pet details table: The following attributes, including "PetName," "PetType," "PetBreed," and "PetDOB," are included in the pet information table. PetName PetType PetBreed PetDOB King Dog Std.Poodle 27-Feb-15 Teddy Cat Cashmier 1-Feb-15 Fido Dog Std.Poodle 17-Jul-17 AJ Dog Collie mix 5-May-17 Cedro Cat Unknown 6-Jun-14 Woolley Cat Unknown ??? Buster Dog Border Collie 11-Dec-13 Jiddah Cat Abyssinian 1-Jul-10 Owner details:Owner Lname, Owner Fname, OwnerPhone, and Owner Mail are some of the properties found in the owner details table. Owner Last Name Owner First Name Owner Phone # Owner Email Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com Frier Liz 201-823-6578 Liz.Frier@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com James Richard 201-735-9812 Richard.James@somewhere.com Trent Miles 201-634-7865 Miles.Trent@somewhere.com Evans Hilary 201-634-2345 Hilary.Evans@somewhere.com ID column creation: OwnerID Owner Last Name Owner First Name Owner Phone # Owner Email 1 Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com 2 James Richard 201-735-9812 Richard.James@somewhere.com 3 Frier Liz 201-823-6578 Liz.Frier@somewhere.com 4 Trent Miles 201-634-7865 Miles.Trent@somewhere.com 5 Evans Hilary 201-634-2345 Hilary.Evans@somewhere.com Explanation: The information from the owner database may be found in the table below, with the ID columns specified to eliminate duplication. In order to address discrepancies, the Owner table has an additional ID field named Owner id and duplicate records (Downs, James) are eliminated. Service details table: The Service details table has the following properties, including "Service," "Date," and "Charge." Service Date Charge Ear infection 17-Aug-16 $66.00 Nail clip 5-Sep-16 $27.50 One year shots 5-May-16 $42.50 Nail clip 5-Sep-16 $27.50 Skin infection 3-Oct-1 $36.00 Laceration problem 5-Oct-16 $127.00 Booster shots 4-Nov-16 $111.00 ID column creation: ServiceID Service Date Charge 1 Ear infection 17-Aug-16 $66.00 2 Nail clip 5-Sep-16 $27.50 3 One year shots 5-May-16 $42.50 4 Skin infection 3-Oct-1 $36.00 5 Laceration problem 5-Oct-16 $127.00 6 Booster shots 4-Nov-16 $111.00 Explanation: The information from the service table is contained in the following table, which specifies the ID fields to be used to weed out duplicates. To prevent discrepancies, the duplicate entry (Nail Clip) in the service information database is eliminated and replaced with the service id as the ID field.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
![Q: [ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on…A: A relational database contains tables. Tables are also known as relations and they contain rows and…](/questions-and-answers/slide-15-.png-q1.-please-write-sql-codes-to-create-below-member-database-table-based-on-the-previous/3b4446fb-5348-4dbb-944d-a99326b9259f){kind=link}
Question
Please Help me With question # 1.16 show how the tables you create for question 1.15 solve the three problems of the list identified in this chapter
1.15 Ans:
Three themes can be identified. They are:
- Pet details
- Owner detais
- Service details
Pet details table:
The following attributes, including "PetName," "PetType," "PetBreed," and "PetDOB," are included in the pet information table.
|
PetName |
PetType |
PetBreed |
PetDOB |
|
King |
Dog |
Std.Poodle |
27-Feb-15 |
|
Teddy |
Cat |
Cashmier |
1-Feb-15 |
|
Fido |
Dog |
Std.Poodle |
17-Jul-17 |
|
AJ |
Dog |
Collie mix |
5-May-17 |
|
Cedro |
Cat |
Unknown |
6-Jun-14 |
|
Woolley |
Cat |
Unknown |
??? |
|
Buster |
Dog |
Border Collie |
11-Dec-13 |
|
Jiddah |
Cat |
Abyssinian |
1-Jul-10 |
Owner details:Owner Lname, Owner Fname, OwnerPhone, and Owner Mail are some of the properties found in the owner details table.
|
Owner Last Name |
Owner First Name |
Owner Phone # |
Owner Email |
|
Downs |
Marsha |
201-823-5467 |
Marsha.Downs@somewhere.com |
|
James |
Richard |
201-735-9812 |
Richard.James@somewhere.com |
|
Downs |
Marsha |
201-823-5467 |
Marsha.Downs@somewhere.com |
|
Frier |
Liz |
201-823-6578 |
Liz.Frier@somewhere.com |
|
James |
Richard |
201-735-9812 |
Richard.James@somewhere.com |
|
James |
Richard |
201-735-9812 |
Richard.James@somewhere.com |
|
Trent |
Miles |
201-634-7865 |
Miles.Trent@somewhere.com |
|
Evans |
Hilary |
201-634-2345 |
Hilary.Evans@somewhere.com |
ID column creation:
|
OwnerID |
Owner Last Name |
Owner First Name |
Owner Phone # |
Owner Email |
|
1 |
Downs |
Marsha |
201-823-5467 |
Marsha.Downs@somewhere.com |
|
2 |
James |
Richard |
201-735-9812 |
Richard.James@somewhere.com |
|
3 |
Frier |
Liz |
201-823-6578 |
Liz.Frier@somewhere.com |
|
4 |
Trent |
Miles |
201-634-7865 |
Miles.Trent@somewhere.com |
|
5 |
Evans |
Hilary |
201-634-2345 |
Hilary.Evans@somewhere.com |
Explanation:
- The information from the owner
database may be found in the table below, with the ID columns specified to eliminate duplication. - In order to address discrepancies, the Owner table has an additional ID field named Owner id and duplicate records (Downs, James) are eliminated.
Service details table:
The Service details table has the following properties, including "Service," "Date," and "Charge."
|
Service |
Date |
Charge |
|
Ear infection |
17-Aug-16 |
$66.00 |
|
Nail clip |
5-Sep-16 |
$27.50 |
|
One year shots |
5-May-16 |
$42.50 |
|
Nail clip |
5-Sep-16 |
$27.50 |
|
Skin infection |
3-Oct-1 |
$36.00 |
|
Laceration problem |
5-Oct-16 |
$127.00 |
|
Booster shots |
4-Nov-16 |
$111.00 |
ID column creation:
|
ServiceID |
Service |
Date |
Charge |
|
1 |
Ear infection |
17-Aug-16 |
$66.00 |
|
2 |
Nail clip |
5-Sep-16 |
$27.50 |
|
3 |
One year shots |
5-May-16 |
$42.50 |
|
4 |
Skin infection |
3-Oct-1 |
$36.00 |
|
5 |
Laceration problem |
5-Oct-16 |
$127.00 |
|
6 |
Booster shots |
4-Nov-16 |
$111.00 |
Explanation:
- The information from the service table is contained in the following table, which specifies the ID fields to be used to weed out duplicates.
- To prevent discrepancies, the duplicate entry (Nail Clip) in the service information database is eliminated and replaced with the service id as the ID field.
Transcribed Image Text:FIGURE 1-35
The Veterinary Office List-Version One
PetName
2 King
3 Teddy
4 Fido
6 A
6 Cedro
Woolley
8 Buster
9 Jiddah
FIGURE 1-36
2 King
3 Techly
4 Fido
6 AJ
6 Cedre
7 Wooley
& Buster
Dog
Cat
PetType-
Dvy
Deg
Cat
Cat
Dep
Cat
Dog
Cat
Dog
Dog
Cat
Cat
Dog
Cat
PetBreed-
Std. Poodle
Cachmier
Std Poodle
Collie Mix
Unknown
Unknown
Border Collie
Abyssinian
1.3
1.4
1.5
1.6
1.7
1.8
1.9
1.10
1.11
PerDOB-
Puttheed
31. Poodle
Castr
Sid Poodle
Colle Mix
Unknown
Unknown
Border Coll
Abyssinian
OwnerlastName
27-Feb-16 Downs
1-Feb-15 James
17-Jul-17 Downs
5-May-17 Frier
6-Jun-14 James
James
771
11-Dec-13 Trent
1-Jul-10 Evans
The Veterinary Office List-Version Two
OwnerFirstName-
Marsha
Richard
Marsha
Liz
Richard
Hichard
Miles
Hilary
Read the description of the search process on the Pearson Web site in this chapter.
Using your own computer, find another retailer Web site (other than those dis-
cussed or mentioned in this chapter), and search for something of interest to you.
Write up a description (with screen shots if possible) of your search.
Why is the study of database technology important?
What is the purpose of this book?
Name the two themes in the list in Figure 1-35.
What is an ID column?
Describe the purpose of a database.
What is a modification problem? What are the three possible types of modification
problems?
Chapter 1 Getting Started 63
Figure 1-35 shows a list that is used by a veterinary office. Describe three modifica-
tion problems that are likely to occur when using this list.
OwnerPhone
201-823-5467
201-735-9812
201-823-5467
201-023-6670
201-735-9812
201-/35-9812
201-634-7865
201-634-2345
Hilary Evans somewhere.com
Excel 2019, Windows 10, Microsoft Corporation.
Miles Trent@somewhere.com
OwnerEmail
Marsha Dawsomewhere.com
Richard James@somewhere.com
Marsha Downa@somewhere.com
Liz Frien@somewhere.com
Break the list in Figure 1-35 into two tables, each with data for a single theme.
Assume that owners have a unique phone number but that pets have no unique col-
umn. Create an ID column for pets like the one created for customers and courses
for the Art Course database tables in Figure 1-12.
1.12
1.13
1.14
1.15
1.16
1.17 Describe in your own words and illustrate with tables how relationships are repre-
sented in a relational database.
Show how the tables you created for question 1.11 solve the problems you de-
scribed in question 1.8.
PYOXD
27-Feb-16 Downs
1-Feb-15 Jan
17-J6-17 Down
5 May 17 For
Jun 14 James
777
James
11-One-13 Trom
Sulud-10 Frans
Bichard James@somewhere.com
Hichard Jamesomewhere.com
What does SQL stand for, and what purpose does it serve?
Another version of the list used by the veterinary office is shown in Figure 1-36.
How many themes does this list have? What are they?
1.18 Name the four components of a database system.
1.19
Define the term database.
Masta
Richael
Marsha
Liz
Break the list in Figure 1-36 into tables, each with a single theme. Create ID col-
umns as you think necessary.
Richard
Richard
Miles
Show how the tables you created for question 1.15 solve the three problems of lists
identified in this chapter.
201-823-5467
201-735-9612
201-023-6467
201 823 6678
201-755-0012
201-735-9012
201-634-7865
205-634-2345
Masha Darat.com Election
Richard Jeres@varts.com Nail Clip
Maraha Duws@va.com
Liz Filen@samwhA
One year Shots
Bichat James Quatrs.com Nail Clip
Bichart@amster.com San Infection
17-Aug-18 S
5-Sep-18 S
5-May-18 S
55ep 18 S
3-0c-15 S
Laceration Repair 5-01-18 5
Hisy Databes.com Booster Thors 4-in-15 S
Excel 2019, Windows 10, Microsoft Corporation.
45.00
27.60
42.50
27.50
35.00
127.00
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education