________ database specification indicates all the parameters for data storage that are theninput to database
implementation.A) LogicalB) PhysicalC) SchematicD) Conceptual A form of database specification which maps conceptual requirements is called:A) logical specifications.B) response specifications.C) security specifications.D) physical specifications Data is represented in the form of:A) data trees.B) tables.C) data notes.D) chairs. A two-dimensional table of data sometimes is called a:A) group.B) set.C) declaration.D) relation. ________ is a component of the relational data model included to specify business rules tomaintain the integrity of data when they are manipulated.A) Business rule constraintB) Data integrityC) Business integrityD) Data structure An attribute (or attributes) that uniquely identifies each row in a relation is called a:A) column.B) foreign field.C) primary key.D) duplicate key. An attribute in a relation of a database that serves as the primary key of another relation in thesame database is called a:A) link attribute.B) link key.C) foreign key.D) foreign
attribute. A primary key whose value is unique across all relations is called a(n):A) global primary key.B) inter-table primary key.C) enterprise key.D) foreign global key A
primary key that consists of MORE THAN ONE ATTRIBUTE IS CALLED A:A) foreign key.B) composite key.C) multivalued key.D) cardinal key. In the SQL language, the ________ statement is used to make table definitions.A) create sessionB) create tableC) create indexD) select In the figure below, the primary key for "Order Line" is which type of key?A) CompositeB) ForeignC) StandardD) Grouped A domain definition consists of all of the following components EXCEPT:A)
domain name.B) data type.C) integrity constraints.D) size. Which of the following are properties of relations?A) Each attribute has the same name.B) No two rows in a relation are identical.C) There are multivalued attributes in a relation.D) All columns are
numeric Which of the following violates the atomic property of relations?A) SamB) HinzC) Sam HinzD) Atomic The entity
integrity rule states that:A) no primary key attribute can be null.B) referential integrity must be maintained across all entities.C) each entity must have a primary key.D) a primary key must have only one attribute The ________ states that no primary key attribute may be null.A) referential integrity
constraintB) entity integrity ruleC) partial specialization ruleD) range domain rule In the figure below, Customer_ID in the CUSTOMER Table is which type of key?A) CompositeB) CandidateC) StandardD) Grouped All of the following are the main goals of normalization EXCEPT:A) minimize data redundancy.B) simplify the enforcement of referential integrity.C) maximize storage space.D) make it easier to maintain data When all multivalued attributes have been removed from a relation, it is said to be in:A) first normal form.B) second normal form.C) Boyce-Codd normal form.D) third normal form The normal form which removes any remaining functional dependencies because there wasmore than one primary key
for the same nonkeys is called:A) fifth normal form.B) fourth normal form.C) Boyce-Codd normal form.D) sixth normal form. The normal form which deals with multivalued dependencies is called:A) fifth normal form.B) fourth normal form.C) Boyce-Codd normal form.D) sixth normal form. A relation that contains no multivalued attributes and has nonkey attributes solely dependenton the primary key but contains transitive dependencies is in which normal form?A) FirstB) SecondC) ThirdD) Fourth A constraint between two attributes is called a(n):A) functional relation.B) attribute dependency.C) functional dependency.D) functional relation constraint A candidate key must satisfy all of the following
conditions EXCEPT:A) the key must uniquely identify the row.B) the key must indicate the row's position in the table.C) the key must be nonredundant.D) each nonkey attribute is functionally dependent upon it. The attribute on the left-hand side of the arrow in a functional dependency is the:A) candidate key.B) determinant.C) foreign key.D)
primary key. Chapter 4 Database Design Flashcards
ionicons-v5-c
Physical
security specifications
Tables
Relation
Data integrity
primary
key
Foreign Key
Enterprise Key
Composite Key
create table
COMPOSITE
integrity constraints.
No two rows in a relation are identical.
Sam Hinz
no primary key attribute can be null.
entity integrity rule
Candidate
Maximize Storage Pace
First
normal form
Boyce-Codd normal form.
fourth normal form.
Second
functional dependency
the key must indicate the row's position in the table
determinant.
partial functional
A functional dependency in which one or more nonkey attributes are functionally dependenton part, but not all, of the primary key is called a ________ dependency.A) partial key-basedB) partial functionalC) cross keyD) merged relation
transitive dependency.
A functional dependency between two or more nonkey attributes is called a:A) partial functional dependency.B) partial nonkey dependency.C) transitive dependency.D) partial transitive dependency.
Deletion
________ problems are encountered when removing data with transitive dependencies.A) InsertionB) ModificationC) DeletionD) Merging
merge
The need to ________ relations commonly occurs when different views need to beintegrated.A) metadataB) systemC) dropD) merge
synonyms
Two or more attributes having different names but the same meaning are called:A) homonyms.B) aliases.C) synonyms.D) alternate attributes.
homonym
An attribute that may have more than one meaning is called a(n):A) homonym.B) alias.C) double defined attribute.D) synonym.
alias.
An alternative name for an attribute is called a(n):A) synonym.B) alias.C) alternate attribute.D) related characteristic
one must be able to check the output of a CASE tool.
Understanding the steps involved in transforming EER diagrams into relations is importantbecause:A) one must be able to check the output of a CASE tool.B) there are rarely legitimate alternatives from which to choose.C) CASE tools can model any situation.D) CASE tools model hypothetical business problems
descriptor
A nonkey attribute is also called a(n):A) column.B) unimportant datum.C) descriptor.D) address.
create two new relations, one containing the multivalued attribute.
When a regular entity type contains a multivalued attribute, one must:A) create a single relation with multiple lines for each instance of the multivalued attribute.B) create two new relations, one containing the multivalued attribute.C) create two new relations, both containing the multivalued attribute.D) delete the relation and start over.
Strong entity/weak entity
In the figure below, what type of relationship do the relations depict?A) Strong entity/weak entityB) MultivaluedC) Composite foreign keyD) One-to-many
one-to-Many
In the figure below, what type of relationship do the relations depict?A) Strong entity/weak entityB) One-to-manyC) TernaryD) Many-to-many
An associative entity
In the figure below, what is depicted?A) A one-to-one relationshipB) A unary relationshipC) A one-to-many relationshipD) An associative entity
Recursive foreign
In the figure below, what type of key is depicted?A) PrimaryB) Recursive primaryC) CompositeD) Recursive foreign
A component is always used in only one item.
Referring to the figure below, which of the following is NOT true?A) A component is part of an item.B) A component is always used in only one item.C) A component can be part of an item.D) A component may be used in many items
Ternary
The figure below is an example of mapping which type of relationship?A) FirstB) SecondC) UnaryD) Ternary
Modification
________ are anomalies that can be caused by editing data in tables.A) InsertionB) DeletionC) ModificationD) Creation
well-structured
A relation that contains minimal redundancy and allows easy use is considered to be:A) clean.B) simple.C) complex.D) well-structured
True
Data structures include data organized in the form of tables with rows and columns. T / F
referential integrity constraint.
A rule that states that each foreign key value must match a primary key value in the otherrelation is called the:A) referential integrity constraint.B) key match rule.C) entity key group rule.D) foreign/primary match rule.
TRUE.
In the figure below, each employee has exactly one manager.Answer : T / F
Discuss when it is best to create a surrogate key for an associative entity
Discuss the two possible scenarios when mapping an associative entity
What is an anomaly, and what are the three types of anomalies?