Identify the relationship for business rules below   Each town may be the birthplace of many people. Each person must be born in one and only one town. Each room may house one or more guest. Each guest may stay in one and only one room. Each employee must work for one and only one department. Each department may have one or more employees. Each hotel may be the host of one or more guest. Each guest may be hosted in one or more Hotels

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

 

Identify the relationship for business rules below

 

  1. Each town may be the birthplace of many people. Each person must be born in one and only one town.
  2. Each room may house one or more guest. Each guest may stay in one and only one room.
  3. Each employee must work for one and only one department. Each department may have one or more employees.
  4. Each hotel may be the host of one or more guest. Each guest may be hosted in one or more Hotels                                                                                                                                                                                                                                                                                                               
  5. Each Message must be addressed to one or more persons. Each person may be the addressee of one or more message.
  6. Each garment must have one and only one price. Each price may be for one or more garments.
  7. Each airline coupon must be used for one and only one destination. Each destination may be visited with one or more coupons.
  8. Each automobile must use one and only one tire size. Each tire size may be used by one or more automobiles.
  9. Each child must have one and only one mother. Each mother must be the parent of one or more children.
  10. Each person must be of one and only one blood type. Each blood type type may classify one or more persons.
  11. A person may be on one or more junk-mail lists. Each junk list may contain one or more persons.
  12. Each student may learn from one or more teachers. Each teacher may educate one or more students.
  13. Each school may be attended by one or more honor students. Each honor student must attend one and only one school.
  14. Each fingerprint must belong to one and only one person. Each person must have one and only one fingerprint.

 

Database Systems
Tutorial 1
3. Given the table structure shown in Figure P1.14, what problem(s) might you encounter if you
deleted building KOM?
Figure P1.14 The Table Structure for Problem 3
BUILDING CODE ROOM CODE TEACHER LNAME
TEACHER FNAME
TEACHER INITIAL
KOM
204E
Williston
Horace
G
KOM
123
Cordoza
Maria
LDB
504
Patroski
Donald
J
KOM
34
Hawkins
Anne
Risell
James
JKP
LDB
225B
301
Robertson
Jeanette
Transcribed Image Text:Database Systems Tutorial 1 3. Given the table structure shown in Figure P1.14, what problem(s) might you encounter if you deleted building KOM? Figure P1.14 The Table Structure for Problem 3 BUILDING CODE ROOM CODE TEACHER LNAME TEACHER FNAME TEACHER INITIAL KOM 204E Williston Horace G KOM 123 Cordoza Maria LDB 504 Patroski Donald J KOM 34 Hawkins Anne Risell James JKP LDB 225B 301 Robertson Jeanette
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 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