View the step-by-step solution to:

(TCO 3) First normal form (1NF) states which of the following?

(TCO 3) First normal form (1NF) states which of the following? (Points: 2)
All fields must contain single values only.
Part of the primary key may not determine a non-key field.
A non-key field may not determine a non-key field.
In an all-key table, part of the key can determine multiple values of, at most, one other field.


3. (TCO 3) The second normal form (2NF) states which of the following? (Points: 2)
All fields must contain single values only.
Part of the primary key may not determine a non-key field.
A non-key field may not determine a non-key field.
In an all-key table, part of the key can determine multiple values of, at most, one other field.


4. (TCO 3) The third normal form (3NF) states which of the following? (Points: 2)
All fields must contain single values only.
Part of the primary key may not determine a non-key field.
A non-key field may not determine a non-key field.
In an all-key table, part of the key can determine multiple values of, at most, one other field.


5. (TCO-2) One concept behind Relational Database Design is to: (Points: 2)
design tables that are logically DEPENDENT on each other
design tables that are logically INDEPENDENT of each other.
provide a low-level, detailed view of the physical implementation of the database
None of the above


6. (TCO-2) Using the analogy of building a house, the ____________ would be considered the floor plan, while the __________are the blueprint. (Points: 2)
Entity Relationship Diagram, Detailed Table Structures
Detailed Table Structures, Entity Relationship Diagram
Detailed table structures, Physical table design
None of the above


7. (TCO-2) Which of the following is are reasons redundant data is bad? (Points: 2)
unnecessary space is used.
data integrity problems will arise
data might get changed in one place, but not in another, resulting in inconsistent data
All of the above


8. (TCO-2) When a database design is NOT normalized, problems can result. One problem which could result is featured in this list of data:

StudentID____Lastname____Course______GradeToDate
123_________Ward________BIS-144________ B
345_________Walker_______ BIS-234________A
333_________Daemion_____BIS-567_________F
123_________Ward_______BIS-445__________C

If this is the only table in the database, and Ward decides to drop BIS-445, this means we lose BIS-445 from the database when an administer removes the last row of the table from the database, due to Ward's withdrawal. This loss of data is called a(n) _________.
(Points: 2)
Insertion anomaly
Modification anomaly
Deletion Anomaly
Updation Anomaly


9. (TCO-2) Consider the following data, which may look the same as in a previous question:

StudentID____Lastname____Course______GradeToDate
123_________Ward________BIS-144________ B
345_________Walker_______ BIS-234________A
333_________Daemion_____BIS-567_________F
123_________Ward_______BIS-445__________C

Let's say we also have a course offered called MGMT404, but no one else has signed up for it yet. The fact that we need a student to enroll in the course before we can even show it exists in our database is called a(n) ____________:
(Points: 2)
Deletion anomaly
Insertion Anomaly
Update Anomaly
Addition Anomaly


10. (TCO-2) When a database design is NOT normalized, problems can result. One problem which could result is featured in this list of data:

StudentID____Lastname____Course______GradeToDate____Class Average
123_________Ward________BIS-144________ B____________75
345_________Walker_______ BIS-234________A____________80
333_________Daemion_____BIS-144_________F____________75
123_________Ward_______BIS-445__________C____________90

Notice how the course BIS-144 has two students in it -- one is Ward, and the others is Damion. Both rows show the class average, which must be the same for both students. If you want to change the class average, there is a risk you might change the average in the row containing Ward, but forget to change the average in the row containing Damion's information. This kind of a anomaly is called a:
(Points: 2)
Deletion Anomaly
Insertion Anomaly
Update Anomaly
Data Mismatch Anomaly


11. (TCO-2) Consider the following table and columns in Design View:

CustomerTable
CustomerID (PK)
LastName
FirstName
OrderAmountNumber1
OrderAmountNumber2
OrderAmountNUmber3

Based only on the information provided in this question, this table violates the first normal form because


(Points: 2)
All data in the table is not atomic.
There is no column to uniquely identify each row in the table
There are repeating columns in the table design
None of the above


12. (TCO-2) Consider this table:

OrderProductTable
OrderID (PK) (FK)
ProductID (PK) (FK)
Quantity
OrderDate
(Points: 2)
This table shows a second normal form violation because it has repeating columns
This table shows a second normal form violation because the quantity of the product sold is dependent only on the OrderID, and not the ProductID
This table shows a second normal form violation because the table contains the OrderDate, which is dependent only on the OrderID, not both the OrderID AND the ProductID
This table is correct, and shows absolutely no 2nd Normal Form violations


13. (TCO-3) Consider the following table:

BuildingTable
BuildingID(PK)
BuildingDescription
RoomID
RoomNumber
RoomCapacity

Which of the following statements is correct?
(Points: 2)
This table violates the first normal form because there is no column that can uniquely identify each row in the table.
This table violates the second normal form because the buildingdescription column does not depend on the BuildingID primary key
This table violates the third normal form because the RoomCapacity column does not depend on the buildingID column; it depends on the non-key column RoomID.
This table has no normal form violations of any kind.


14. (TCO-2) Which of the following represent an advantage of normalization? (Points: 2)
It produces far more tables, which is a good thing.
Queries pull from multiple tables
A normalized database put less stress on CPU usage, storage capacity and input/output resources.
Overall organization is improved


15. (TCO-2) Consider the following table, which has normalization problems:

PatientTable
PatientID (Primary Key)
PatientFirstName
PatientLastName
PatientStreet
PatientCity
PatientState
PatientZip
PatientPhone
DoctorID
DocFName
DocLname
DocPhone
DocBeeper
DocSpecialtyNumber1
DocSpecialtyNumber2
DocSpecialtyNumber3
DocSpecialtyNumber4

a) Name at least one normal form that is violated, such 1NF, 2NF or 3NF
b) Describe why that normal form is violated, citing specific columns that have created the violation
(Points: 4)



16. (TCO-5) Describe at least 4 ways of ensuring Data Validation, and thus preventing GIGO (Garbage-In, Garbage-Out). Be specific, using the terminology from the textbook, and explaining in your own words how the technique prevents invalid data from being stored in the database. (Points: 4)



17. (TCO-5) Provide one advantage and one disadvantage of using the Form Wizard, compared to using creating a form from scratch in form design view. (Points: 4)

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question