Identify at least four business rules for the following ER diagram. aircraft PK aircraft D seats PK seat Number passengers PK passenger Number
Identify at least four business rules for the following ER diagram. aircraft PK aircraft D seats PK seat Number passengers PK passenger Number
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter3: The Relational Database Model
Section: Chapter Questions
Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...
Related questions
Question
100%
Using the writing a business rule PDF, write the business rules relating to the provided png relationships
Transcribed Image Text:Rule 1: (Entity1)
Rule 2: (Entity2)
(Relationship Verb)
(Relationship Verb)
Entity1 and Entity2 are the entities in the relationship. In
the examples below, they are Customer and Order.
The Relationship Verb is a business term for the
relationship. In the example below, the relationship is built
around a customer placing an order.
Customer
The participation and cardinality should be worded like
this:
Business Rule 1
(Participation and Cardinality of Entity2) (Entity2)
(Participation and Cardinality of Entity1) (Entity1)
++
A customer can place
Rule 1: (Entity1) (Relationship Verb)
Symbol
Ot
||
OF
K
Participation Cardinality
Optional
Mandatory
Optional
Mandatory
Order
One
One
Many
Many
Wording for a
Business Rule
zero to many
orders
(Participation and Cardinality of Entity2) (Entity2)
Zero to one
One and only one
Zero to many
One to many
Transcribed Image Text:Identify at least four business rules for the following ER diagram.
aircraft
PK aircraftl D
PK
seats
seat Number
+++
passengers
-O+ PK passenger Number
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 2 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
continuing
Transcribed Image Text:Using the figure in previous problem, list each entity and state what foreign key, if
any, would be within the entity to form the relationships shown.
Entity
aircraft
seats
passengers
FK
Solution
by Bartleby ExpertKnowledge 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 Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole