Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database Management > Midterm Study Guide > Flashcards

Midterm Study Guide Flashcards

1
Q

Which of the following is software used to create, maintain, and provide controlled access to databases?

A

Database management system (DBMS)

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

Data that describe the properties of other data are:

A

metadata.

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

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

A

user view

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

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

A

entity

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

The SDLC phase in which database processing programs are created is the ________ phase.

A

implementation

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

________ is a tool even non-programmers can use to access information from a database.

A

Structured query language

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

The traditional methodology used to develop, maintain, and replace information systems is called the:

A

Systems Development Life Cycle.

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

Legacy systems often contain data of ________ quality and are generally hosted on ________.

A

poor; mainframes

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

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

A

RAD - Rapid Application Development

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

Which organizational function should set database standards?

A

Database Administration

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

Metatdata typically describes all of the following EXCEPT:

A

location on disk

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

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

A

design

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

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A

Relationships

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

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

A

providing an integrated development environment

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

A rule that CANNOT be violated by database users is called a:

A

constraint

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

An attribute that can be calculated from related attribute values is called a ________ attribute.

A

derived

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

In the figure below, which attribute is multivalued?

Employee_ID
Employee_Name
Address
Date_Employed
(Skill)
[Years_Employed]

A

Skill

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

Customers, cars, and parts are examples of:

A

Entities

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

Which of the following criteria should be considered when selecting an identifier?

A

Choose an identifier that doesn’t have large composite attributes

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

A(n) ________ is the relationship between a weak entity type and its owner.

A

identifying relationship

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

In the figure below, which attribute is derived?

Employee_ID
Employee_Name
Address
Date_Employed
(Skill)
[Years_Employed]

A

Years_Employed

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

Data modeling may be the most important part of the systems development process because:

A

data characteristics are important in the design of programs and other systems components

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

An entity type whose existence depends on another entity type is called a ________ entity.

A

weak

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

The following figure shows an example of:

[Employee]====<[[Dependent]]

A

a strong entity and its associated weak entity

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

Which of the following is NOT a characteristic of a good business rule?

A

Inconsistent

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

An attribute that must be present for every entity (or relationship) instance is a(n):

A

required attribute

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

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

A

composite

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

Which of the following is NOT a good characteristic of a data name?

A

Relates to a technical characteristic of the system

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

The most common types of entities are:

A

strong entities

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

Which of the following is an entity that exists independently of other entity types?

A

Strong

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

In the following diagram, which answer is true?

A

Each employee can supervise one employee, no employees, or many employees

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

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

A

mandatory one

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

The number of entity types that participate in a Unary relationship is:

A

One

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

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

A

Ternary

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

For the relationship represented in the figure below, which of the following is true?
[Employee]>o——–l<[Department]

A

A department can have more than one employee

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

In the following diagram, what type of relationship is depicted?

A

Ternary

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

A relationship between the instances of a single entity type is called a ________ relationship.

A

unary

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

In the following diagram, which of the answers below is true?
[Patient]-ll————-l<[Patient history]

A

Each patient has one or more patient histories.

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

A mutually exclusive relationship is one in which:

A

an entity instance can participate in only one of several alternative relationships

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

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

A

cardinality constraint

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

The terms “data” and “information” mean essentially the same thing.

A

False

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

According to the lecture, the “meme” that is often used to describe the different levels of data needs was

A

“one person’s information is another person’s data.”

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

The term database refers to the software used to manage data.

A

False

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

Metadata is data that describes the properties or context of the actual data stored in the database.

A

True

45
Q

According to the lecture, you can generally think of structured data as being able to be organized into rows and columns much like a spreadsheet.

A

True

46
Q

According to the lecture, increased application development productivity is the most impactful advantage of relational databases over file processing systems.

A

False

47
Q

According to the lecture, the relationship between a course and a section would be:

A

one-to-many

48
Q

The logic required to read and write data in a file processing system is generally embedded directly into the program that must access that data.

A

True

49
Q

The advantages of relational databases are so huge that they have effectively replaced file processing systems.

A

False

50
Q

With relational databases, only the application that creates the data can access that data, a concept known as “maker-is-master data isolation.”

A

False

51
Q

System developers do not write SQL to access relational databases, instead relying on specialized database administrators to perform this task.

A

False

52
Q

Most databases that “back” the applications that we use on a daily basis are considered “operational” databases.

A

True

53
Q

Dr. York occasionally wanted to “punch” which kind of project team member?

A

“Operational” Database Administrators

54
Q

Modern (alternative) systems development processes have completely abandoned unnecessary development steps like planning, analysis, design and testing.

A

False

55
Q

According to the lecture, eXtreme Programming and SCRUM are examples of Agile Methodologies.

A

True

56
Q

SQL is a technical language that is intended to be used only by specialists.

A

False

57
Q

One of the major limitations of personal databases is their lack of support for concurrent access by multiple users.

A

True

58
Q

Enterprise application databases rarely mix data from different business functions (e.g., HR and Manufacturing).

A

False

59
Q

According to the lecture, which of the following types of enterprise systems is often concerned with the administration of a manufacturing process.

A

Enterprise Resource Planning (ERP)

60
Q

According to the lecture, an increased “volume and velocity” of data has been one of the primary forces driving the evolution of database technology.

A

True

61
Q

In the context of a database, “E-R” is an acronym for:

A

Entity-Relationship

62
Q

Although you need to learn how to model data for this course, as “hands-on” IT or Cybersecurity professionals, it’s highly unlikely that you’ll actually encounter them in the real world.

A

False

63
Q

Data definitions are often assembled into a data dictionary within in a word processing document or spreadsheet file, not necessarily in a diagram or data modeling tool.

A

True

64
Q

Business rules are captured using a very technical language that is understood only by application developers and data analysts.

A

False

65
Q

Although there are numerous standards for notations, all E-R diagrams will model entities, attributes, relationships and the cardinality of the relationships.

A

True

66
Q

According to the lecture, an “Entity Type” is most closely related to the concept of a(n) ________ in object-oriented programming.

A

Class

67
Q

In general, a weak entity is less important than a strong entity, so we usually choose not to capture them.

A

False

68
Q

When naming entities, it is best to be as concise as possible; this could even include abbreviation or acronyms if they are commonly referred to that way within an organization.

A

True

69
Q

It is very common for a database have only a single Entity Instance for any given Entity Type.

A

False

70
Q

Most of the time, it is neither necessary nor desirable to capture a system’s users (the person generating input) or outputs (screens, web pages, reports, etc.) in the database model.

A

True

71
Q

If a composite identifier exists–even if it requires combining several fields–it is always desirable to use it instead of adding a surrogate identifier.

A

False

72
Q

When designing a data model, it is important to group attributes together as composite attributes because databases always require you to enter them grouped this way.

A

False

73
Q

Although a database cannot directly store multivalued attributes (i.e., attributes that can have zero or many individual values), it is important to capture these in your conceptual and logical data models.

A

True

74
Q

Without exception, every entity stored in a database will need to be identified by a key (either simple, composite, or surrogate).

A

True

75
Q

A course section requires three attributes to uniquely identify that section (semester, course_number, section_letter); this is a good example of a ______.

A

Composite Identifier

76
Q

Even for a single database vendor, there are numerous acceptable standards for drawing ERD’s.

A

True

77
Q

A ternary (or n-ary) relationship is a conceptual relationship between more than two tables in a diagram, but will not be directly modeled in the same way in a relational database.

A

True

78
Q

When creating an ERD, it is vital to represent every possible conceptual relationship between two types of entities, even those not directly relevant to the problem domain.

A

False

79
Q

Relationships between entities are always only unidirectional, meaning for example that you can only consider the relationship to be from entity A to entity B and not from B to A.

A

False

80
Q

According to the lecture, the most common degree of relationship found in most database models is what?

A

Binary

81
Q

According to the lecture, the ERD is the actual, underlying implementation of the database and it’s relationships (its “structure”), whereas the Data Model is simply a conceptual representation of this structure.

A

False

82
Q

A high-school student is assigned a locker, and a locker can be assigned to only a single student at a time. This is an example of a ______ relationship.

A

One-to-One

83
Q

An author can write many books and a book can have one or more authors. This is an example of a ______ relationship.

A

Many-to-many

84
Q

Cardinality can also capture whether a relationship is optional or required.

A

True

85
Q

One employee can work on many projects and one project can have many employees. This is an example of a ______ relationship.

A

Many-to-many

86
Q

In the “crows-foot” ERD notation, the line or circle representing whether a relationship is mandatory or optional is the symbol closest to the box representing the entity type.

A

False

87
Q

On a project, one employee can serve many roles. This is an example of a ______ relationship.

A

Insufficient Information to Determine the Correct Answer

88
Q

Cardinality refers to the number of instances of one entity type that may conceivably be related to an instance of another entity type.

A

True

89
Q

An airline flight can have only one pilot serving as Captain, but a pilot can be Captain on many flights. This is an example of a _______ relationship.

A

One-to-many

90
Q

The primary purpose of an associative entity is to allow for a relational database to physically model a conceptual many-to-many relationship.

A

True

91
Q

An attribute of an entity is considered “multivalued” because the entity will have just one of many possible values (e.g., a multiple-choice question with one right answer).

A

False

92
Q

If a many-to-many relationship requires that we store attributes that further describe that relationship, those attributes should be stored in the associative entity.

A

True

93
Q

A time stamp is distinct from other data types in that it only captures time (in a 24 hour UTC format), and not a date.

A

False

94
Q

You do not need an associative entity if you are resolving a many-to-many unary relationship. They are only needed for binary relationships between separate entity types.

A

False

95
Q

Strong Entity

A

A strong entity is a type of entity that doesn’t depend on any other entity in the database. It has a primary key attribute, which uniquely identifies each entity instance. Examples could be a Person, a Car, or a House.

96
Q

Weak Entity

A

A weak entity depends on a strong entity to ensure its existence. It doesn’t have a primary key attribute of its own, so it uses a foreign key combined with some other attributes to create a composite primary key. These are typically items that are incompletely identified by their own attributes. For example, a ‘Classroom’ entity might be weak if its existence depends on a ‘School’ entity.

97
Q

Associative Entity (also known as a linking or bridge entity)

A

This is often used to link many-to-many relationships. It consists of one or more foreign keys, each coming from the entities being connected. Sometimes, associative entities also contain additional attributes that provide more information about the relationship. For instance, if ‘Students’ and ‘Courses’ are entities, an ‘Enrollment’ associative entity might link them and contain extra data like ‘dateEnrolled’ or ‘finalGrade’.

98
Q

Derived Entity

A

This type of entity is one whose attributes are derived from other entities in the database. For example, an ‘Invoice’ entity might be derived from a ‘Purchase’ entity and a ‘Customer’ entity.

99
Q

Subtype and Supertype Entities

A

In certain scenarios, entities are organized into hierarchies. A supertype is a generic entity type that has a relationship with one or more subtype entities. These subtype entities inherit the attributes and relationships of the supertype. For instance, a ‘Vehicle’ supertype could have ‘Car’, ‘Bicycle’, and ‘Motorcycle’ subtypes.

100
Q

Abstract Entity

A

This entity captures common characteristics of certain entities, but it doesn’t usually exist on its own. It’s used for data modeling to simplify definitions and avoid redundancy. It’s more commonly used in Object-Oriented Database Management Systems.

101
Q

Inner Join

A

This is the most common type of join. It returns records that have matching values in both tables involved in the join. If a record in the first table doesn’t have a corresponding record in the second table, it is excluded from the result set (and vice versa).

102
Q

Left outer join (or left join)

A

This returns all records from the left table (the first table), and the matched records from the right table (the second table). The result is NULL in the right side when there is no match.

103
Q

Right outer join (or right join)

A

This returns all records from the right table, and the matched records from the left table. The result is NULL in the left side when there is no match.

104
Q

Full outer join (or full join)

A

This returns all records when there is a match in one of the tables. Therefore, it returns all the records from both tables with NULL in either side when there isn’t a match. Not all database systems support full outer joins natively, but they can typically be emulated using a union of left and right joins.

105
Q

Natural Join

A

A natural join is a type of join that implies an implicit equality condition. It performs an equi-join based on all columns with the same name in both tables being joined. The result set only includes one column for each pair of equally named columns. Most database experts advise against using natural joins, as they can lead to unexpected results, especially if the table schemas change over time. They also lack explicitness, which can make the SQL harder to understand.

106
Q

Cross Join

A

a cross join is worth noting. It returns the Cartesian product of the two tables involved, meaning every row of the first table is joined to every row of the second table. This type of join can produce very large result sets and is rarely used in practice without a limiting WHERE clause.
Remember, the “left” and “right” designations in the join types refer to the order of the tables as they are listed in the SQL statement. The “left” table is the one that appears first, while the “right” table appears second.

107
Q

Who invented the relational model?

A

The relational model for database management is a database model that was invented by E.F. Codd, a British computer scientist, while working for IBM. He introduced the concept in his seminal 1970 paper titled “A Relational Model of Data for Large Shared Data Banks,” which was published in the journal Communications of the ACM. This model became the theoretical basis for relational databases, changing how databases were constructed and used across numerous applications and industries.

108
Q
A

Database Management (1 decks)

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