Description

File Organization and Database Management Homework Assignment 5
For each question, in the Homework Answer Sheet state the letter of your chosen answer and write out the explanation why the answer is correct. Note that the explanation involves also explaining why the other answers are not correct.
Your answer Word document should be submitted on the Canvas system for the quiz number equal to the homework number. For example, the homework 2 should be submitted for homework

assignment 2.
1) In general, normalizing a single flat-file database results in which of the following?
a) Many tables.
b) Reduced data redundancy.
c) No INSERT, DELETE or UPDATE anomalies.
d) All of the above.
e) None of the above.
2) Normalization
a) has no impact on performance.
b) is necessary for read-only databases.
c) sets the business rules.
d) is a technical exercise that does not change thebusiness rules.
3) Normalization is required to
a) prevent updates by unauthorized personnel.
b) update multiple instances of data at the same time.
c) make sure the same data is stored in multiplelocations.
d) preserve data quality.
4) In a read only database
a) denormalization is common in order to provideefficient report generation.
b) normalization is required to prevent update anoma-lies.
c) normalization has no impact on reads.
d) denormalization is performed to speed up writes.
5) A table normalized to first normal form (1NF) commonly
a) includes more attributes than the non-normalizedversion.
b) contains more records than the non-normalizedversion.
c) contains less records than the non-normalized ver-sion.
d) has no redundant data.
6) A relation is in first normal form (1NF) if
a) at least one attribute in every row contain only onesingle (atomic) value.
b) every non-key attribute is fully functionally depen-dent on the primary key.
c) at least one attribute in every row can contain morethan one value (multivalued).
d) every attribute in every row can contain only one
single (atomic) value.
7) A relation is in first normal form (1NF) if
a) it doesn’t contain an determinants.
b) it doesn’t contain any repeating groups.
c) it doesn’t contain any null values in primary keyfields.
d) it doesn’t contain any functional dependences.
8) A relation is in second normal form (2NF) if
a) it is in 1NF and every key attribute is fully func-tionally dependent on the primary key.
b) it is in 1NF and every attribute is fully functionallydependent on the primary key.
c) it is in 1NF and every non-key attribute is fullyfunctionally dependent on the primary key.
d) it is in 1NF and no non-key attribute is transitively
dependent on the primary key.
9) A relation is in third normal form (3NF) if
a) it is in 1NF and no non-key attribute is transitivelydependent on the primary key.
b) it is in 2NF and no non-key attribute is transitivelydependent on the primary key.
c) it is in 1NF and no non-key attribute is fullyfunctionally dependent on the primary key.
d) it is in 2NF and no non-key attribute is fully
functionally dependent on the primary key.
10) In fourth normal form (4NF)
a) All occurrences of an entity must contain the samenumber of attributes.
b) All non-key fields must be a function of the key.
c) All non-key fields must not be a function of othernon-key fields.
d) A row must not contain two or more independentmulti-valued facts about an entity.
11) When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity? [Hint: more than one answer is correct.]
a) Link the relations by a common field.
b) Remove any functional dependencies from bothrelations.
c) Assign both relations the same primary key field(s).
d) Create a primary key(s) for the new relation.
12) Table I is in which normal form?
a) First Normal Form (1NF)
b) Second Normal Form (2NF)
c) Third Normal Form (3NF)
d) Fourth Normal Form (4NF)
13) In Table I, which of the following is apparently true?
a) StudentID → TutorID
b) CourseID → Room, Topic
c) CourseID → TutorID
d) CourseID → Topic
14) Normalization ensures that each fact (data) is
a) stored in exactly one location.
b) stored in multiple locations and updated simulta-neously.
c) updated in all locations simultaneously.
d) not null.
15) In discussing normal form, a key is
a) a unique identifier for a row in a table, used toselect the row in queries.
b) a set of attributes that describe an instance of anentity.
c) an object defined in the system model about whichdata is stored in the database.
d) a set of attributes that cannot be used to uniquelyidentify a row in a table.
a) normalized.
b) inconsistent.
c) a foreign key.
d) outdated.
17) To alter a product name requires the name to be changed in 5 different places. This is an example of a potential
a) DELETE anomaly.
b) INSERT anomaly.
c) UPDATE anomaly.
d) CREATE anomaly.
a) 1NF
b) 2NF
c) 3NF
d) 4NF
19) In a normalized table, the attribute A1 is functionally dependent on the attribute A2. Which os the following is true?
a) There can be repeating values in the A1 column.
b) The A2 column is a unique identifier.
c) Each value for A2 identifies a single value of A1.
d) All of the above.
e) None of the above.

20) A table contains data about products and customers. 21) During normalization it is first noticed that each time a Splitting this table into two would occur when normal- particular value in attribute p occurs attribute q has the izing the table into: same value. Which normal form is being considered?
a) 1NF a) 1NF
b) 2NF b) 2NF
c) 3NF c) 3NF
d) 4NF d) 4NF
U1 St1 23.02.03 Tut1 GMT 629 4.7 Deumlich tut1@fhbb.ch
U2 St1 18.11.02 Tut3 GIn 631 5.1 Zehnder tut3@fhbb.ch
U1 St4 23.02.03 Tut1 GMT 629 4.3 Deumlich tut1@fhbb.ch
U5 St2 05.05.03 Tut3 PhF 632 4.9 Dmmlers tut3@fhbb.ch
U4 St2 04.07.03 Tut5 AVQ 621 5.0 SwissTopo tut5@fhbb.ch