Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Discuss the importance of data models. What is a business rule, and what is its purpose in data modeling? How do you translate business rules

Discuss the importance of data models.
What is a business rule, and what is its purpose in data modeling?
How do you translate business rules into data model components?
Describe the basic features of the relational data model and discuss their importance to the end user and the designer.
Explain how the entity relationship (ER) model helped produce a more structured relational database design environment.
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.
Why is an object said to have greater semantic content than an entity?
What is the difference between an object and a class in the object-oriented data model (OODM)?
How would you model Question 6 with an OODM? (Use Figure 2.4 as your guide.)
What is an ERDM, and what role does it play in the modern (production) database environment?
What is a relationship, and what three types of relationships exist?
Give an example of each of the three types of relationships.
What is a table, and what role does it play in the relational model?
What is a relational diagram? Give an example.
What is connectivity? (Use a Crows Foot ERD to illustrate connectivity.)
Describe the Big Data phenomenon.
What does the term 3 Vs refer to?
What is Hadoop, and what are its basic components?
What are the basic characteristics of a NoSQL database?
Using the example of a medical clinic with patients and tests, provide a simple representation of how to model this example using the relational model and how it would be represented using the key-value data modeling technique.
What is logical independence?
What is physical independence?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

This question is quite extensive and covers various aspects of data models business rules ER models and database concepts Lets tackle them one by one Importance of Data Models 1 Design Foundation Data ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions