Computer W5 - Data Models

Question 1

Are plans drawn to scale.

Answer 1

Blueprints

Question 2

An abstract way of describing how data are organized.

Answer 2

Data Model

Question 3

Used to represent data in a way that is close to the user’s view of the model environment.

Answer 3

Object-Based Logical Model

Question 4

A diagram that relies on the different attributes of a database to define it.

Answer 4

Entity-Relationship Diagram

Question 5

Represents the entity sets.

Answer 5

Rectangle ( ▭ )

Question 6

Represents the attributes.

Answer 6

Ellipse ( ⬭ )

Question 7

Represents relationships among entity sets

Answer 7

Diamond ( ◇ )

Question 8

Links the attributes to the entity sets and links the entity sets to relationships.

Answer 8

Line ( ─── )

Question 9

Are used to specify the overall logical makeup of the database.

Answer 9

Record-Based Logical Models

Question 10

A set of tables representing the data and the relationships among the data.

Answer 10

Relational Model

Question 11

Corresponds to a collection of records and relationships.

Answer 11

Network Model

Question 12

Are the records from the student table.

Answer 12

Parent Nodes

Question 13

Are the records from the subjects table.

Answer 13

Child/Children Nodes

Question 14

Are arranged as a collection of sub-trees from a single source, called the root

Answer 14

Hierarchical Model

Question 15

Used to describe model found at the lowest level

Answer 15

Physical Data Model