[Solved] MSDS7330 Assignment 5

• In general, normalizing a single flat-file database results in which of the following?
  1. Many tables.
  2. Reduced data redundancy.
  3. No INSERT, DELETE or UPDATE anomalies.
  4. All of the above.
  5. None of the above.
• Normalization
  1. has no impact on performance.
  2. is necessary for read-only databases.
  3. sets the business rules.
  4. is a technical exercise that does not change thebusiness rules.
• Normalization is required to
  1. prevent updates by unauthorized personnel.
  2. update multiple instances of data at the same time.
  3. make sure the same data is stored in multiplelocations.
  4. preserve data quality.
• In a read only database
  1. denormalization is common in order to provideefficient report generation.
  2. normalization is required to prevent update anoma-lies.
  3. normalization has no impact on reads.
  4. denormalization is performed to speed up writes.
• A table normalized to first normal form (1NF) commonly
  1. includes more attributes than the non-normalizedversion.
  2. contains more records than the non-normalizedversion.
  3. contains less records than the non-normalized ver-sion.
  4. has no redundant data.
• A relation is in first normal form (1NF) if
  1. at least one attribute in every row contain only onesingle (atomic) value.
  2. every non-key attribute is fully functionally depen-dent on the primary key.
  3. at least one attribute in every row can contain morethan one value (multivalued).
  4. every attribute in every row can contain only one

single (atomic) value.

• A relation is in first normal form (1NF) if
  1. it doesnt contain an determinants.
  2. it doesnt contain any repeating groups.
  3. it doesnt contain any null values in primary keyfields.

1. it doesnt contain any functional dependences.

• A relation is in second normal form (2NF) if
  1. it is in 1NF and every key attribute is fully func-tionally dependent on the primary key.
  2. it is in 1NF and every attribute is fully functionallydependent on the primary key.
  3. it is in 1NF and every non-key attribute is fullyfunctionally dependent on the primary key.
  4. it is in 1NF and no non-key attribute is transitively

dependent on the primary key.

• A relation is in third normal form (3NF) if
  1. it is in 1NF and no non-key attribute is transitivelydependent on the primary key.
  2. it is in 2NF and no non-key attribute is transitivelydependent on the primary key.
  3. it is in 1NF and no non-key attribute is fullyfunctionally dependent on the primary key.
  4. it is in 2NF and no non-key attribute is fully

functionally dependent on the primary key.

• In fourth normal form (4NF)
  1. All occurrences of an entity must contain the samenumber of attributes.
  2. All non-key fields must be a function of the key.
  3. All non-key fields must not be a function of othernon-key fields.
  4. A row must not contain two or more independentmulti-valued facts about an entity.
• 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.]
  1. Link the relations by a common field.
  2. Remove any functional dependencies from bothrelations.
  3. Assign both relations the same primary key field(s).
  4. Create a primary key(s) for the new relation.
• Table I is in which normal form?
  1. First Normal Form (1NF)
  2. Second Normal Form (2NF)
  3. Third Normal Form (3NF)
  4. Fourth Normal Form (4NF)
• In Table I, which of the following is apparently true?
  1. StudentID TutorID
  2. CourseID Room, Topic
  3. CourseID TutorID
  4. CourseID Topic
• Normalization ensures that each fact (data) is
  1. stored in exactly one location.
  2. stored in multiple locations and updated simulta-neously.
  3. updated in all locations simultaneously.
  4. not null.
• In discussing normal form, a key is
  1. a unique identifier for a row in a table, used toselect the row in queries.
  2. a set of attributes that describe an instance of anentity.
  3. an object defined in the system model about whichdata is stored in the database.
  4. a set of attributes that cannot be used to uniquelyidentify a row in a table.
• The same fact (data) that is stored in multiple locations may become
  3. a foreign key.
• To alter a product name requires the name to be changed in 5 different places. This is an example of a potential
  1. DELETE anomaly.
  2. INSERT anomaly.
  3. UPDATE anomaly.
  4. CREATE anomaly.
• A school databases Students table contains the name and address details of each student. However there are many brothers and sisters in the school who live at the same address. Splitting the address details into their own table would occur when normalizing the Students table into:
  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF
• In a normalized table, the attribute A1 is functionally dependent on the attribute Which os the following is true?
  1. There can be repeating values in the A1
  2. The A2 column is a unique identifier.
  3. Each value for A2 identifies a single value of
  4. All of the above.
  5. None of the above.

• 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?
  1. 1NF a) 1NF
  2. 2NF b) 2NF
  3. 3NF c) 3NF
  4. 4NF d) 4NF

TABLE I STUDENT-TUTOR TABLE