Now, using Visible Analyst®, or another CASE tool, create an ERD that shows the two main entities in Danica’s shop, and the relationship between them. Add an associative entity if necessary.
What will be an ideal response?
A sample answer might use an associative entity such as WORK ASSIGNMENT. In this example one and only one mechanic receives one or many assignments. In other words, assignments are given on an individual basis, not as a team, even though several mechanics might work together.
Similarly, one, or many WORK ASSIGNMENTS can include a specific JOB. Thus, Eduardo, a mechanic, could receive a work assignment that listed four separate jobs to perform on a certain automobile. Or, Eduardo might receive four separate work assignments, each for a single job on a different vehicle. Students should see that WORK ASSIGMENT is an associative entity, much like GRADE, which links STUDENTS and CLASSES in Figure 9-26 on page 299. The sample ERD follows:
You might also like to view...
________ is used to analyze large amounts of data and identify unseen patterns or trends
Fill in the blank(s) with correct word
When you copy a selection of cells using drag and drop, which appears before you release the mouse button?
A. an outline of the new location of the selected range B. the range C. a cell reference of the old location D. shortcut tip
In which of the following mouse operations do you quickly press and release the left mouse button twice without moving the mouse?
A. double-press B. click C. double-click D. drag
As each information asset is identified, categorized, and classified, a __________ value must also be assigned to it.
Fill in the blank(s) with the appropriate word(s).