Lesson 4 ITE 5

Question 1

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

Answer 1

data model

Question 1

refers to the process of creating a specific data model for a determined problem domain

Answer 1

data model

Question 2

is a person, place, thing, or event about which data will be collected and stored. An entity represents a particular type of object in the real world.

Answer 2

entity

Question 3

is a characteristic of an entity.

Answer 3

attribute

Question 4

describes an association among entities.

Answer 4

relationship

Question 5

relationship, each entity in the first set is associated with exactly one entity in the second set, and vice versa.

Answer 5

3.1. One-to-one (1:1 or 1..1) relationship.

Question 6

one entity in the first set is associated with multiple entities in the second set, but each entity in the second set is associated with only one entity in the first set.

Answer 6

3.2. One-to-many (1:M or 1..*) relationship.

Question 7

multiple records in one table can be associated with multiple records in another table. This usually requires a junction table to handle the relationships.

Answer 7

. Many-to-many (M:N or ..) relationship.

Question 8

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

Answer 8

constraint

Question 9

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

Answer 9

business rule

Question 10

is a “blueprint” with all the instructions to build a database that will meet all end-user requirements

Answer 10

Data Modeling