hw2print.docx - Question 1 2 out of 2 points is one of the categories of update anomalies Selected Answer Inconsistent data Answers a c Qualification b

hw2print.docx - Question 1 2 out of 2 points is one of the...

This preview shows page 1 - 4 out of 15 pages.

Question 1 2 out of 2 points ____ is one of the categories of update anomalies. Selected Answer:c.Inconsistent dataAnswers:a.Qualificationb.Functional splittingc.Inconsistent datad.Functional dependence Question 22 out of 2 pointsWhen you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns. Question 3 2 out of 2 points Which of the following symbols is used to qualify column names? Question 4 2 out of 2 points A relation is a characteristic or property of an entity.
Image of page 1
Question 5 2 out of 2 points The same column name can appear in two different tables in a relational database. Selected Answer:TrueAnswers:TrueFalse Question 6 2 out of 2 points A record is another term for a(n) ____. Question 70 out of 2 pointsIn the one-to-many type of relationship, the word many always indicates a large number. Selected Answer: [None Given] Question 8 2 out of 2 points A secondary key is the unique identifier for a table.
Image of page 2
Question 9 2 out of 2 points An unnormalized relation is a relation that may contain repeating groups. Selected Answer:TrueAnswers:TrueFalse Question 10 2 out of 2 points In a relation, all values in a column are values of the same attribute. Question 11 2 out of 2 points A tabular database is a collection of tables.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 15 pages?

  • Spring '16
  • Maksim

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture