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

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
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 the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
Post a Comment
Read more

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 is the process called where missing data is fixed? a). Imputing   2. According to the instructor
Post a Comment
Read more