logo image

Combo with "MIS 342–Midtern–Chapter 4" and 1 other

The entity relationship diagram (ERD) represents the ____database as viewed by the end user.
conceptual
The _____notation of entity-relationship modelling can be used for both conceptual and implementation modelling.
UML
A(n) ____ is the set of possible values for a given attribute.
domain
Ideally, an entity identifier is composed of ___ attributes.
one
A ___ attribute can be further subdivided to yield additional attributes.
composite
A ___ attribute is one that cannot be subdivided.
simple
The conceptual model can handle ____ relationships and multivalued attributes.
M:N
A derived attribute is indicated in the Chen model by a ____ that connects the attribute and an entity.
dashed line
The decision to store ____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.
derived
A relationship is an association between _____.
entities
_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Cardinality
In the ERD, cardinality is indicated using the ____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.
(min, max)
When the specific cardinalities are not included on the diagram in Crow’s Foot notation, cardinality is implied by the use of ____.
symbols
Knowing the minimum and maximum number of ____ occurrences is very helpful at the application software level.
entity
An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
existence
If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) ____ entity.
strong
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
weak
The existence of a(n) ____entity indicates that its minimum cardinality is zero.
optional
The Crow’s foot symbol with two vertical parallel lines indicates ____ cardinality.
(1,1)
A ____ relationship exists when an association is maintained within a single entity.
unary
A _____ relationship exists when three entities are associated.
ternary
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship.
recursive
To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent ____ relationships whenever possible.
binary
The entity relationship model uses the associative entity to represent a(n) ____ relationship between two or more entities.
M:N
When using the Crow’s Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.
solid
If Tiny College has some departments that are classified as “research only” and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.
optional to
In organizations that generate large number of transactions, ____ are often a top priority in database design.
high processing speeds
Complex _____ requirements may dictate data transformations, and they may not expand the number of entities and attributes within the design.
information
Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to …
Three
From a structural point of view, 3NF is better than_____.
2NF
1NF, 2NF, and 3NF are _____.
normalization stages
From a structural point of view, 2NF is better than _____.
1NF
____ yields better performance.
Denormalization
An attribute that is part of a key is known as a(n) _____ attribute.
prime
A table that displays data redundancies yields ______.
anomalies
Data redundancy produces ____.
data integrity
Some very specialized applications may require normalization beyond the ______.
4NF
Of the following normal forms, _____ is mostly of theoretical interest.
DKNF
A(n) ______ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.
transitive dependency
Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
determines
A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.
repeating group
A relational table must not contain a(n) ______.
repeating group
Dependencies based on only a part of a composite primary key are known as ______ dependencies.
partial
In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.
dependency
A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in ______.
1NF
A table that is in 1NF and includes no partial dependencies is said to be in _____.
2NF
If you have three different transitive dependencies, _____different determinant(s) exist.
three
Before converting a table into 3NF, it is imperative that the table already be in _____.
2NF
A(n) _____ exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key.
partial dependency
If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have ______ based on this composite candidate key even when the primary key changes…
partial dependencies
A table that is in 2NF and contains no transitive dependencies is said to be in _____.
3NF
Improving _____ leads to more flexible queries.
atomicity
An atomic attribute ______.
cannot be further subdivided
The most likely data type for a surrogate key is _____.
numeric
Granularity refers to ______.
the level of detail represented by the values in a table’s row
From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.
derived
In a real-world environment, we must strike a balance between design integrity and _____.
flexibility
For most business transactional databases, we should normalize relations into ______.
3NF
To generate a surrogate key, Microsoft Access uses a(n) _____ data type.
AutoNumber
A table where every determinant is a candidate key is said to be in _____.
BCNF
In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.
multivalued dependency
BCNF can be violated only if the table contains more than one _____ key.
candidate
When a table contains only one candidate key, ______ are considered to be equivalent.
the 3NF and the BCNF
Most designers consider the BCNF as a special case of the _____.
3NF
A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about…
4NF
A table is in 4NF if it is in 3NF, and _____.
it has no multivalued dependencies.
When designing a database, you should ____.
make sure that entities are in normal form before table structures are created
Normalization represents a micro view of the _____ within the ERD.
entities
An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data….
temporary
The conflicts between design efficiency, information requirements, and performance are often resolved through.
compromises that include denormalization
Data warehouse routinely uses ____ structures in its complex, multilevel, multisource data environment.
2NF
_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Data warehouse

Need essay sample on "Combo with "MIS 342–Midtern–Chapter 4" and 1 other"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy