Quiiz 2

MG 651: Managing Web & Database Tech

Chapter 2

Due Date: 13/10

Question 4:

There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-22 described by that point.

Answer:

1. Entities PRODUCTS and PRODUCT LINES. Relationship INCLUDES. Mandatory One-To-Mandatory Many

2. Entities CUSTOMER and ORDER. Relationship Submits. Mandatory One-To-Many.

3. Entities ORDERS and PRODUCTS. Associative Entity ORDER LINE.

4. Entities CUSTOMERS and TERRITORY. Associative entity Does Business In.

5. Entities SALESPERSON and TERRITORY. Relationship Serves. Mandatory Many-To-Mandatory One.

6. Entities PRODUCT and RAW MATERIAL. Associative Entity USES.

7. Entities RAW MATERIAL and VENDOR. Associative Entity SUPPLIES.

8. Entities WORK CENTER and PRODUCT. Associative entity PRODUCED IN.

9. Entities EMPLOYEE and WORK CENTER. Associative entity WORKS IN.

10. Entity EMPLOYEE. Relationship Supervises. Many-To-One.

-------------------------------------------------

Question 5:

You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that did not directly translate into the tool’s notation?

Answer:

I personally faced many problems while drawing the E-R diagrams. The tool I used is https://www.draw.io/ . I felt lot comfortable while using this tool compared to other tools. The main problem that I faced is I was not able to draw Fig 2-15 and Fig 2-22 with that tool. I was not able to sketch the tables, though I sketched I was not able to type PK in the specified location. I also noticed that some of many to many options are not available in the tool that I used....