Database Models

Question 1

The first step in designing a database refers to the process of creating a specific data model for a determined problem domain (a problem domain is a clearly defined area within the real world
environment, with a well-defined scope and boundaries that will be systematically addressed.)

Answer 1

Data modeling

Question 2

It is a relatively simple representation, usually graphical, of more complex real-world data structures.

Answer 2

Data model

Question 3

What are the 3 Data Model Basic Building Blocks?

Answer 3

Entity, Attribute, and Relationship

Question 4

It is a person, place, thing, or event about which data will be collected and stored.

Answer 4

Entity

Question 5

It is a characteristic of an entity. For example, a CUSTOMER entity would be described by attributes such as customer last name, customer first name, customer phone number, customer address, and customer credit limit.

Answer 5

Attribute

Question 6

It describes an association among entities. For example, a relationship exists between customers and agents that can be described as follows: an agent can serve many customers and each customer may be served by one agent.

Answer 6

Relationship

Question 7

1:M

Answer 7

One-to-many

Question 8

M:N

Answer 8

Many-to-many

Question 9

1:1

Answer 9

One-to-one

Question 10

It is a restriction placed on the data. ___ are important because they help to ensure data integrity.

Answer 10

Constraint

Question 11

It is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

Answer 11

Business rule