Exam 1

Question 1

Any attribute whose value directly determines other values in that row.

Answer 1

Determinant

Question 2

Not being able to insert data even though its available due to poor design

Answer 2

Insert Anomaly

Question 3

No transitive dependencies

Answer 3

3NF - Third Normal Form

Question 4

data access is unaffected by

changes in the physical data storage characteristics.

Answer 4

Data Independence

Question 5

provides a global view of an
entire database and describes the main data objects,
avoiding details.

Answer 5

Conceptual Model

Question 6

changes in the

database schema do not affect data access.

Answer 6

Structural Independence

Question 7

An identifier composed of one or more attributes that uniquely identifies a row.

Answer 7

Primary Key

Question 8

An attribute whose value is calculated from other attributes. No need to store it.

Answer 8

Derived Attribute

Question 9

The condition in which every reference to an entity instance by another entity instance is valid.

Answer 9

Referential Integrity

Question 10

Does the inheriting from supertype.

Foreign students and domestic students in relation to students.

Answer 10

Subtype

Question 11

the grouping of
common attributes into a supertype entity.

creates parent from subtypes

Answer 11

Generalization

Question 12

internal model can be

changed without affecting the conceptual model.

Answer 12

Logical Independence

Question 13

When you can’t update in one place but have to update in multiple places.

Answer 13

Update Anomaly

Question 14

A person, place, thing, concept, or event for which data can be stored.

Object of interest to the end user

Answer 14

Entity

Question 15

An attribute or attributes in one table whose values must match the primary key in another table.

Used to ensure referential integrity.

Answer 15

Foreign Key

Question 16

An entity that is existence-independent, that is, it

can exist apart from all of its related entities.

Answer 16

Strong Entity

Question 17

Whether each supertype needs to be a subtype or not.

Partial - not every supertype is a subtype member

total- every supertype is a subtype member

Answer 17

Completness Constraint

Question 18

How many relationships take place.

Answer 18

Relationship Degree

Question 19

No partial dependencies

Answer 19

2NF

Question 20

bridge entity.

Links two entities that have M: M relationship

Answer 20

Associative Entity

Question 21

The type of relationship between entities. Classifications

include 1:1, 1:M, and M:N.

Answer 21

Connectivity

Question 22

A characteristic of an entity. Has a name and a data type.

Answer 22

Attribute

Question 23

Data about data.

Can be used to define domain.

Answer 23

Metadata

Question 24

multiple-attribute key

Answer 24

Composite Key

Question 25

attribute is dependent on | only a portion (subset) of the primary key.

Answer 25

Partial Dependency

Question 26

An attribute that can have many values for a single entity occurrence. Its repeating data

Answer 26

Multi-Valued Attribute

Question 27

How many children a parent can have. Numerical limit.

Answer 27

Cardinality

Question 28

not being able to delete intended data without also deleting unintended data.

Answer 28

Delete Anomaly

Question 29

represents the receipt as a whole

Answer 29

Header

Question 30

represents the lines on the receipt

Answer 30

Line Entities

Question 31

Focused on one type of user.

Answer 31

External Model

Question 32

an attribute that can have only one value

Answer 32

Single Valued Attribute

Question 33

relationship exists whenever the primary key of the related entity contains the primary key of the parent entity.

Answer 33

Strong Relationship

Question 34

Specialization is based on grouping unique characteristics and relationships of the subtypes. subtypes inherit from parent

Answer 34

Specialization Hierarchy

Question 35

An attribute or attributes that uniquely identity each entity in a table. Gets inherited.

Answer 35

Supertype

Question 36

Every entity must be distinct. Shouldn't overlap.

Answer 36

Entity Integrity

Question 37

Decides which subtype and entity belongs to.

Answer 37

Subtype Discriminator

Question 38

A relationship found within a single entity type. For example, an EMPLOYEE is married to an EMPLOYEE or a PART is a component of another PART.

Answer 38

Recursive Relationship

Question 39

An entity that displays existence dependence and inherits the primary key of its parent entity. For example, a DEPENDENT requires the existence of an EMPLOYEE. Created when repeating data exists

Answer 39

Weak Entity

Question 40

attribute is dependent on | another attribute that is not part of the primary key.

Answer 40

Transitive Dependency

Question 41

No repeating data

Answer 41

1NF - first normal form

Question 42

A process that assigns attributes to entities so that | data redundancies are reduced or eliminated.

Answer 42

Normalization

Question 43

uniquely identify any row but has superfluous data

Answer 43

superkey

Question 44

what data we have must create a bridge entity

Answer 44

Internal Model

Question 45

A logical grouping of database objects, such as tables, indexes, views, and queries, that are related to each other.

Answer 45

Schema

Question 46

A system-assigned primary key, generally numeric | and autoincremented.

Answer 46

surrogate key

Question 47

index that has only one pointer value associated with it

Answer 47

Unique Index

Question 48

orderly arrangement used to logically access rows in a table used to locate items quickly

Answer 48

index

Question 49

when two subtypes don't overlap like foreign and domestic students

Answer 49

disjoint subtype