Upgrade to remove ads
Only A$47.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (30)
The term "____" is used to label any condition in which one or more optional relationships exist.
optionality
In the ERD, cardinality is indicated using the ____ notation.
(min, max)
Connectivities and cardinalities are usually based on ____________________ rules.
business
A person's social security number would be an example of a(n) ____________________ attribute.
single-valued
In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
existence-dependent
In an ER diagram, primary keys are indicated by ____.
underlining
The Crow's Foot model is less implementation-oriented than the Chen model.
False
Some attributes are classified as ____.
Correct simple
Relationships operate only in one direction.
false
The word "entity" in the ER model corresponds to a table.
true
The hierarchical data model was developed in the ____.
1960s
If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).
True
A(n) ____ is bidirectional.
relationship
You should always load data from the 1 side of a 1:M relationship.
True
A ____ relationship exists when two entities are associated.
binary
A(n) ____ is anything about which data are to be collected and stored.
entity
The relational database model enables you to view data ____ rather than ____.
logically, physically
The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.
mandatory
In a database context, a(n) ____ indicates the use of different names to describe the same attribute.
synonym
Referential and entity integrity are two names for the same thing.
False
Granularity refers to ____.
Correct the level of detail represented by the values stored in a table's row
A table is in 2NF if it is in 1NF and it includes no partial dependencies.
True
It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.
foreign
In _________________________ no row may contain two or more multivalued facts about an entity.
Fourth normal form (4NF)
A table is in BCNF if every determinant in the table is a foreign key.
False
Atomic attributes are attributes that can be further divided.
False
With parrtial dependencies, data redundancies occur because every row entry requires duplication of data.
True
In a real-world environment, we must strike a balance between design integrity and ____.
flexibility
Data redundancy produces ____.
data integrity problems
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 go in the normalization process.
three
Students also viewedChapter 4
19 terms
clnyce
FIT2094-L3
13 terms
Kade_Wu
IT Quiz 4
40 terms
MANDLAZI
Database Chapter 4 Quiz
25 terms
amanda_ebner3
Sets found in the same folderQuiz #2 - Fill in the Blanks
47 terms
jaetranx3
Chapter 3 (part 2)
20 terms
taniajohst
Quiz Chapter 6
20 terms
megsb20
Database Chapter 2
71 terms
cppbroncosstudystuff
Other sets by this creatorA+ Exam
94 terms
mtrench623
MBUS 304 Midterm
48 terms
mtrench623
MBUS 300 Managerial Chapter 9
15 terms
mtrench623
MBUS 300 Chapter 3 Managerial
11 terms
mtrench623
Verified questions
engineering
Tool life can be almost infinite at low cutting speeds. Would you then recommend that all machining be done at low speeds? Explain.
Verified answer
chemistry
Draw Fischer projections of the following molecules, placing the carbonyl group at the top in the usual way. Identify each as a d or l sugar.
Verified answer
physics
When a body is moved from sea level to the top of a mountain, what changes-the body's mass, its weight, or both? Explain .
Verified answer
physics
A crate is siding down a ramp that is inclined at an angle of $$ 38.0^\circ $$ above the horizontal. The coefficient of kinetic friction between the crate and the ramp surface is 0.600. Find the acceleration of the moving crate.
Verified answer
Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Fundamentals of Database Systems
7th EditionRamez Elmasri, Shamkant B. Navathe
687 solutions
Other Quizlet setsDatabase exam 1
30 terms
andrew_ripley7
Exam 2 [MGMT-382]
270 terms
DecetopPlus
admin test 1
53 terms
mikkisickle