Lesson 2

Question 1

Elements of Database Approach

Answer 1

1. Data models
2. Entities
3. Relationships
4. Relational Database

Question 2

Graphical system capturing nature
and relationship of data. (Enterprise
& Project Data Model)

Answer 2

Data Models

Question 3

High-level entities and relationships for the organization.

Customer
l
l (Places)
V (Is placed by)
Order
l (Contains)
l
V (Is contained by)
Product

Answer 3

Enterprise Data Model

Question 4

More detailed view, matching data structure in database or data warehouse.

Customer (Customer ID) Product Id
l ^
V l
Order (Order ID, CID, OD) –> Order Line

Answer 4

Project Data Model

Question 5

● Noun form describing a person,
place, object, event, or concept
● Composed of attributes.

Answer 5

Entities

Question 6

It is a characteristic that
describes that entity.

Answer 6

Attribute

Question 7

● Between Entities
● Usually one-to-many (1:M) or
many-to-many (M:N)

Answer 7

Relationships

Question 8

Database technology involving:
1. Tables (relations)
2. Primary/foreign keys

Answer 8

Relational Databases

Question 9

representing entities.

Answer 9

Tables (relations)

Question 10

representing relationships.

Answer 10

Primary/foreign keys