Skip to main content

Assignment: Chapter 02 Use It

Add the ends to the relations on the Crows Foot ERD for the 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):
  1. Each time an employee wants a vehicle a new assignment is made.
  2. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle.
  3. A vehicle may have multiple assignments.
  4. 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.
  5. An assignment may have the status of Assigned, Out, or Returned.
  6. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out".


1. What image should go into the square marked 1?

Hide Feedback
Correct
2. What image should go into the square marked 2?
Hide Feedback
Correct
3. What image should go into the square marked 3?
Hide Feedback
Correct
4. What image should go into the square marked 4?
Hide Feedback
Correct
5. What image should go into the square marked 5?
Hide Feedback
Correct
6. What image should go into the square marked 6?
Hide Feedback
Correct
7. What image should go into the square marked 7?
Hide Feedback
Correct
8. What image should go into the square marked 8?
Hide Feedback
Correct


Use the following business rules to assign name to the tables on the ERD:

Note: These rules are in the context of a small retail store and their charge account process. The case contains simplifying assumptions that may not accurately represent a real-world example.

1) A customer may be responsible for one account.

2) An account can have several charges posted to it but a charge may only be posted to a single account.

3) A charge may include an item and an item may be included on many charges.

4) An account may have several payments made against it but a payment may only be credited to a single account.

Write the business rules for the following ERD shown in the figure below. The diagram represents the “Charge Account” at a small retail store. The ERD may contain simplifying assumptions that may not accurately represent a real-world example.







Hide Feedback

Correct




 

Labels:

Comments

Post a Comment

Popular posts from this blog

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in t...
Post a Comment
Read more

IS-5113 Data Mining and Data Visualization [Jan 25 Syllabus]

  Lesson 1 Quiz One of the key differences between business analytics and data science is their primary focus either on business problems or on mathematical algorithms. True Analytics and analysis are essentially the same thing; they both focus on the granular level representation of complex problems through decomposition of the whole into its lower-level parts. False If a data scientist is analyzing historical data to identify problems and root causes, he/she is essentially conducting descriptive analytics. True ERP stands for enterprise resource planning and is used for the integration of company-wide data. True The most important driver behind business analytics popularity is the need for business managers to make experience and intuition driven business decisions. False Business analytics and data science have the same purpose: to convert data into actionable insight through an algorithm-based discovery process. True Major commercial business intelligence products and services...
Post a Comment
Read more