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

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
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

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