Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Database > Chapter 2 - Slides > Flashcards

Chapter 2 - Slides Flashcards

(91 cards)

Start Studying
1
Q

The ____ is very popular because of its

simplicity and mathematical foundation

A

Relational Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False? Relational model shows data to the user in a very simple, logical view as a two-dimensional table.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the strongest characteristic of the Relational Model?

A

the ability to establish relationships among tables, which helps to reduce redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What was the first commercial implementation of the Relational Model?

A

SQL/DS on MVS OS by IBM and the Oracle DBMS in 1980s

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a model?

A

a simplified version of real-life

complex objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a data model?

A

a simplified graphical
representation of a database structure and is a
tool to represent the various entity types and
relationships among the entity types.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does the Entity-Relationship (ER) model provide?

A
  1. An excellent communication tool.

2. A simple graphical representation of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The E-R model uses _____ for

graphical representation of the database components

A

E-R diagrams (ERD)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is an Entity?

A

it is represented by a
rectangle. The name of the entity (set) is written within
the rectangle. Some tools prefer to use uppercase
letters only for entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The name of an entity set is a _____

A

single noun

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

EMPLOYEE, CUSTOMER, and DEPARTMENT are examples of what?

A

Singular entity set names

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A ___ represents relationship between the two

entities

A

line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

The name of the relationship is an ____ in lowercase letters.

A

active verb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

works, manages, and employs are examples of what?

A

relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How is 1:1 represented on the ER Model?

A

With 2 vertical lines on each side. (-||——||–) ie. manages

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How is 1:M represented on the ER Model?

A

With 1 set of vertical lines on one side and angled lines on the right hand side.
(-||–||-)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

How is M:N represented on the ER Model?

A

With 2 angled lines on each side.

(->—

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

The types of relationships (1:1, 1:M, and M:N) between entities are called:

A

connectivity or

multiplicity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How would you illustrate the following:
An EMPLOYEE supervises a DEPARTMENT, and a
DEPARTMENT has one EMPLOYEE supervisor

A

E -||–(supervises)–||-D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How would you illustrate the following:
A DIVISION contains many FACULTY members, but
a FACULTY works for one DIVISION.

A

D -||–(employs)–

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

How would you illustrate the following:
An INVOICE contains many ITEMS and an ITEM
can be in more than one INVOICE.

A

INV ->–(contains)–

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The relationship between two entities can be given
using the lower and upper limits. This information is
called the ____.

A

cardinality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

The ____ is written next to each entity in the

form (n, m)

A

cardinality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

a (1, 1) next to
EMPLOYEE means that an employee can supervise a
___ of one and ___ of one department.

A

minimum; maximum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
The value (1, N) next to an entity means
a minimum of one and a | maximum equal to any number
26
True or False? Some modern tools do not show cardinality in an E-R diagram.
True
27
True or False? In reality, corporations do not set rules for the minimum and maximum values for cardinality.
False, they do.
28
A corporation may decide that a department must have a minimum of 10 employees and a maximum of 25 employees, which results in cardinality of:
(10,25)
29
An employee can be part of zero or more than one department, and an item may not be in any invoice! These types of decisions are known as ___.
business rules
30
In real life, it is possible to have an entity that is not related to another entity at all times. The relationship is known as:
an optional relationship.
31
What is the symbol of an optional relationship?
Angled lines with a circle | ->o--o
32
The decomposition from M:N to 1:M involves a third | entity, known as a
composite/associative entity
33
The ____ is created with the primary key from both tables with M:N relationships. The new entity has a ___, which is a combination of primary keys from the original two entities.
composite entity; composite key
34
In a database, there are entities that cannot exist by | themselves. Such entities are known as
weak entities
35
The following example, is an example of what type of entity? In the employee database, there is an entity called EMPLOYEE with employees’ demographic information and another entity called DEPENDENT with information about each employee’s dependents.
Weak Entities
36
The _____ entity cannot exist by itself. In other | words, you need the existence of an employee for his or her dependent to exist in the database.
DEPENDENT
37
Weak entities are symbolically represented as
Double-lined rectangles
38
What are Simple attributes?
attributes that cannot be subdivided; for | example, last name, city, or gender.
39
What are Composite attributes?
attributes that can be subdivided, into atomic form; for example, a full name can be subdivided into the last name, first name, and middle initial.
40
What are Single-valued attributes?
attributes with a single value; for example, Employee ID, Social Security number, or date of birth.
41
What are Multivalued attributes?
attributes with multiple values; for example, degree codes or course registration. The multivalued attributes have to be given special consideration.
42
Every table in the database should have a ___, which uniquely identifies an entity
primary key
43
For integrity of data, a ____ should be defined for each table in the database
primary key
44
Each table has other columns that do not make up the primary key for the table, such columns are called the _____.
nonkey columns
45
The nonkey columns are _____ on the primary key column
functionally dependent
46
What are the three types of Dependency?
1. Total or full dependency 2. Partial dependency 3. Transitive dependency
47
What is total dependency?
When a nonkey column is dependent on all primary key columns and shows total dependency
48
What is Partial dependency?
When a nonkey column is dependent on part of the primary key
49
What is Transitive dependency?
When a nonkey column is dependent on another nonkey | column
50
When would you need to make a composite key?
When no primary key is possible, you need to combine 2 columns with unique data to make a composite.
51
Based on the following column dependencies, would it be partially/transitive/total dependency? Columns A & B are nonkey columns that are dependent only on a part of the primary key column C.
Partially Dependent
52
Based on the following column dependencies, would it be partially/transitive/total dependency? The nonkey column A is not dependent on any primary key column but is dependent on another nonkey column, B.
Transitive Dependency
53
Based on the following column dependencies, would it be partially/transitive/total dependency? The nonkey column A is dependent on both B and C.
Total Dependency
54
The first and foremost step in database creation is _____, which involves a certain degree of common sense.
database design
55
_______ involves an attempt to | synthesize the database structure to get the “first draft”.
Relational database design
56
The initial draft goes through an _____ to | improve the structure
analysis phase
57
In the ______, entities and their relationships are identified. The characteristics or the columns of all entities are also identified, and the designer defines the domains for each column.
synthesize phase
58
A process called _____ is a process of analyzing | the tables created by the synthesis process.
normalization
59
____ keys will be used to establish relationships
Foreign
60
There is a large amount of ____ data in a table | with just eight rows and can pose problems.
redundant
61
The redundancy may also lead to ____
anomalies
62
A _____ results when the deletion of information about one entity leads to the deletion of information about another entity
deletion anomaly
63
An ______ occurs when the information about an entity cannot be inserted unless the information about another entity is known.
insertion anomaly
64
An _____ can occur, if the item price changes to a new price. The price change is valid after the change date, but not before the change date
update anomaly
65
Unnecessary and unwanted redundancy and anomalies are not appropriate in databases. Such tables are in _____
lower normal form
66
______ is a technique to reduce redundancy and  It is a decomposition process to split tables.
Normalization
67
The ____ in Normalization is performed carefully so that no | information is lost.
splitting
68
The higher the normal form is, the ____ the | redundancy.
lower
69
A table is said to be in first normal form, or can be | labeled 1NF, if the following conditions exist:
1. The primary key is defined. This includes a composite key if a single column cannot be used as a primary key. 2. All nonkey columns show functional dependency on the primary key components 3. The table contains no multivalued columns. In a singlevalued column, the intersection of a row and a column returns only one value. In a normalized table, the intersection of a row and a column is a single value.
70
What are some disadvantages of 1NF?
A table that is 1NF: 1. may have redundant data. 2. does not show data consistency and integrity in the long run
71
A table is said to be in second normal form, or can be labeled 2NF, if the following requirements are satisfied:
1. All 1NF requirements are fulfilled | 2. There is no partial dependency
72
____ exists in a table in which nonkey columns are partially dependent on part of a composite key
Partial dependency
73
Partial dependency only exists in a table with a | _____.
composite key
74
If a table is in 1NF and does not have a composite key, it is in 2NF, because there is ______.
no partial dependency
75
A table is said to be in third normal form, or can be labeled 3NF, if the following requirements are satisfied:
1. All 2NF requirements are fulfilled | 2. There is no transitive dependency
76
A table that has _____ is not in 3NF, but it needs to be decomposed further to achieve 3NF
transitive dependency
77
A table in 2NF that does not contain any ______ does not need any further decomposition and is automatically in 3NF
transitive dependency
78
Other higher normal forms are also possible:
1. Boyce-Codd normal form (BCNF) 2. Fourth normal form (4NF) 3. Fifth normal form (5NF) 4. Domain key normal form (DKNF)
79
A ___ is used to show total (full), partial, and transitive dependencies in a table
dependency diagram
80
In a dependency diagram: The _____ components are highlighted. They are in bold letters and in boxes with a darker border, and are connected to each other using a bracket.
primary key
81
In a dependency diagram: The _____ are shown with arrows drawn above the boxes.
total and functional dependencies
82
In a dependency diagram: The ____ are shown with arrows at the bottom of the diagram
partial and transitive dependencies
83
In the 1NF-to-2NF conversion, all _____ are removed
partial dependencies
84
The ____ process splits tables into smaller tables. These tables are joined through common columns to retrieve information from different tables
normalization
85
The more tables you have in a database, the more ___ are needed to get the desired information. In a multi-user environment, it is a costly overhead, and system performance is affected
joins
86
____ is the reverse process of normalization. It reduces | the normal form, and it increases data redundancy.
Denormalization
87
With _____ , the information is stored with duplicate data, more storage is required, and anomalies and inconsistent data exist. The designer has to weigh this against performance to come up with a good design and performance
denormalization
88
A table is supposed to describe one ____
entity
89
If a table describes multiple entities, it needs to be | _____.
decomposed
90
When tables are _____, there should be enough foreign keys to establish relationships among tables.
decomposed
91
_____ should not end up with a table that is not related to any other table in the database.
Database design process

Database (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions