Technology - Discuss the importance of data models

Technology

QUESTION 6 and 9 must be created in .vsdx file. (Visio)

Explain and make sure to completely answer the questions.

FOR 6 – 9 must look like figures below. (NOT SAME. THOSE ARE JUST FOR REFERENCE)

4-5 pages are enough. (plus 2 Visio files.)

1. Discuss the importance of data models.

2. What is a business rule, and what is its purpose in data modeling?

3. How do you translate business rules into data model components?

4. Describe the basic features of the relational data model and discuss their importance to the end user and the designer.

5. Explain how the entity relationship (ER) model helped produce a more structured relational database design environment.

6. Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer.” Use this scenario as the basis for an entity relationship diagram (ERD) representation.

7. Why is an object said to have greater semantic content than an entity?

8. What is the difference between an object and a class in the object-oriented data model (OODM)?

9. How would you model Question 6 with an OODM? (Use Figure 2.4)

10. What is an ERDM, and what role does it play in the modern(production) database environment?

(SAMPLE OF THE ERD)