Database Systems 14e Chapter 02 Use It – Crow’s Foot ERD Practice Questions and Solutions

3/27/26, 5:52 PM Database Systems 14e Chapter 02 Use It ( Crow s Foot ERD) Flashcards | Quizlet



Social Sciences Business Business management


Database Systems 14e Chapter 02 Use It ( Crows
1
Foot ERD)
5.0 (6 reviews)

Save




St udents also studied


Database Systems 14e Chapter 04 U... Chapter 04 Use It CSC345 Week 2 Module 2 Use It CIS 222 - Chapter

6 terms 19 terms 5 terms 5 terms




lapule210 Preview eolson2489 Preview bpeters96 Preview bw85339




Terms in this set (9)



Add the ends to the relations on the Crows Foot ERD for the see picture for diagram
business rules of the XYZ Company's motor pool (a motor pool
typically is a group of vehicles that are temporary assigned to
employees to drive for business purposes):
Each time an employee wants a vehicle a new assignment is
made.
An employee can have multiple assignments, but each
assignment is for only one employee and only one vehicle.
A vehicle may have multiple assignments.
The XYZ location at the end if the assignment is stored in the
assignment. It is assumed tht the assignment begins at the
destination of that vehicles prior assignment.
An assignment may have the status of Assigned, Out, or
Returned.
A vehicle may only be "Out" on one assignment and an
employee may only have one assignment "Out".


https://quizlet.com/1004345772/database-systems-14e-chapter-02-use-it-crow s-foot-erd-flash-cards/ 1/3