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

Set up relationships (determining foreign keys) by
mapping your ER/EER to relations and showing what
are FK and PK in your relations.

Hospital Employees
Employee ID LastName
First Name
Educational
Hire Date Address
City
State Zip
Home Phone
Degree
2
Becker
Todd
MS.
4-Aug-92 908 W.Capital Way
Tacoma
WA
98401
(206) S55-9482
Bowie
Ros ie
B.S.
6-Mar-94
4726 - 11th Ave. N.E.
Seatle
WA
98105
(206) SSS-1189
3
Carrington
Maram
MS.
1l-Apr-92
722 Moss Bay Blvd.
Kirkland
WA
98033
(206) 555-3412
17-Oct-93
Coventy House
Mirer Rd.
6
Chu
Liu
MS.
Tacoma
WA
98402
(71) 555-73
9
Dennis
Ame
MS.
S-Nov-94
7 Hounds tooth Rd.
Bellingham
WA
98047
(71) SSS-4444
5
Peters
Peter
B.S.
17-Oct-93
14 Garett Hill
Bellingham
WA
98047
(71) 5S5-4948
1-May-92 s07- 20th Ave. E.
Apt. 2A
Edgeham Hollow
Wirches ter Way
3-May-93 4110 Old Redmond Rd.
1
Plotter
Mary
PhD.
Seatle
WA
98122
(206) 55S-9857
7
Wally
Robert
AA.
12-Jan-94
Seatle
WA
98125
(71) SSS-5598
4
Walters
Magaret
MS.
Redmond
WA
98052
(206) 555-8122
Transcribed Image Text:Hospital Employees Employee ID LastName First Name Educational Hire Date Address City State Zip Home Phone Degree 2 Becker Todd MS. 4-Aug-92 908 W.Capital Way Tacoma WA 98401 (206) S55-9482 Bowie Ros ie B.S. 6-Mar-94 4726 - 11th Ave. N.E. Seatle WA 98105 (206) SSS-1189 3 Carrington Maram MS. 1l-Apr-92 722 Moss Bay Blvd. Kirkland WA 98033 (206) 555-3412 17-Oct-93 Coventy House Mirer Rd. 6 Chu Liu MS. Tacoma WA 98402 (71) 555-73 9 Dennis Ame MS. S-Nov-94 7 Hounds tooth Rd. Bellingham WA 98047 (71) SSS-4444 5 Peters Peter B.S. 17-Oct-93 14 Garett Hill Bellingham WA 98047 (71) 5S5-4948 1-May-92 s07- 20th Ave. E. Apt. 2A Edgeham Hollow Wirches ter Way 3-May-93 4110 Old Redmond Rd. 1 Plotter Mary PhD. Seatle WA 98122 (206) 55S-9857 7 Wally Robert AA. 12-Jan-94 Seatle WA 98125 (71) SSS-5598 4 Walters Magaret MS. Redmond WA 98052 (206) 555-8122
Customers and Pets
CustamerID Type of Custamer Custamer Name
Street/Apt
City
State Zip Code
Phane Number Fax Number
Pet Name
PetD
Type Of Animal
Breed
DoB
Gender
АC001
2
All Creatures
21 Grace St.
Tall Pines
WA
98746
(206) 555-6622 (206) 555-7854
Bobo
AC001-01
RABBIT
Long Ear
4/8/92
M
Fido
AC001-04
DOG
German Shepherd
6/1/90
M
Presto Chango
AC001-02
LIZARD
Chameleon
5/1/92
Stinky
AC001-03
SKUNK
8/1/91
M
AD001
1
Johnathan Adams
66 10th St
Mountain View
WA
984101012
(206) 555-7623 (206) 555-8855
Patty
AD001-01
PIG
Potbelly
2/15/91
F
Rising Sun
AD001-02
HORSE
Palomino
4/1 0/90
M
AD002
1
William Adams
1122 10th St
Lakeville
OR
974011011
(503) 555-6187 (503) 555-7319
Dee Dee
AD002-01
DOG
Miked
2/15/91
F
AK001
2
Animal Kingdom
15 Marlin Lane Borderville
ID
834835646
(208) 555-7108
Jerry
AK001-03
RAT
2/1/88
M
Luigi
AK001-07
DOG
Веagle
8/1/92
M
Daily Visits Report
CustomerName
PetName
VisDate Vetainaian
ServiceD
Treament/Medication
Price
Adam Johnson
Fi Fi
5/9/99 Walters, Margaret
T1003
Lab Work - Misc
$35.00
T1001
Lab Work - Cerology
$75 00
T0300
General Exam
$50.00
M0202
Zinc Oxide - 4 oz
$7.80
Pet Total:
$16780
Customer Total:
$16780
All Creatures
Fido
11 4/9 8 Carrington, Maram
T2003
Flea Spray
$25.00
Nyostatine - 1 oz
Xaritain Glycon ol - 2 oz
MO500
$1 1. 50
MO702
$34. 50
T0404
Repair compl cz fracture
$230.00
T0408
Cast affected area
$120.00
Transcribed Image Text:Customers and Pets CustamerID Type of Custamer Custamer Name Street/Apt City State Zip Code Phane Number Fax Number Pet Name PetD Type Of Animal Breed DoB Gender АC001 2 All Creatures 21 Grace St. Tall Pines WA 98746 (206) 555-6622 (206) 555-7854 Bobo AC001-01 RABBIT Long Ear 4/8/92 M Fido AC001-04 DOG German Shepherd 6/1/90 M Presto Chango AC001-02 LIZARD Chameleon 5/1/92 Stinky AC001-03 SKUNK 8/1/91 M AD001 1 Johnathan Adams 66 10th St Mountain View WA 984101012 (206) 555-7623 (206) 555-8855 Patty AD001-01 PIG Potbelly 2/15/91 F Rising Sun AD001-02 HORSE Palomino 4/1 0/90 M AD002 1 William Adams 1122 10th St Lakeville OR 974011011 (503) 555-6187 (503) 555-7319 Dee Dee AD002-01 DOG Miked 2/15/91 F AK001 2 Animal Kingdom 15 Marlin Lane Borderville ID 834835646 (208) 555-7108 Jerry AK001-03 RAT 2/1/88 M Luigi AK001-07 DOG Веagle 8/1/92 M Daily Visits Report CustomerName PetName VisDate Vetainaian ServiceD Treament/Medication Price Adam Johnson Fi Fi 5/9/99 Walters, Margaret T1003 Lab Work - Misc $35.00 T1001 Lab Work - Cerology $75 00 T0300 General Exam $50.00 M0202 Zinc Oxide - 4 oz $7.80 Pet Total: $16780 Customer Total: $16780 All Creatures Fido 11 4/9 8 Carrington, Maram T2003 Flea Spray $25.00 Nyostatine - 1 oz Xaritain Glycon ol - 2 oz MO500 $1 1. 50 MO702 $34. 50 T0404 Repair compl cz fracture $230.00 T0408 Cast affected area $120.00
Expert Solution
Step 1

primary key is a column that uniquely identifies a table.

Foreign key is a column group of columns  that is a primary key in another table. It provides a link between 2 tables. It can contain duplicate values and NULL values

steps

Step by step

Solved in 2 steps

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