Employee EmployeeNum LastName FirstName Street City State PostalCode WageRate

Employee employeenum lastname firstname street city

This preview shows page 347 - 350 out of 403 pages.

Employee ( EmployeeNum , LastName, FirstName, Street, City, State, PostalCode, (WageRate, SocSecNum, DepartmentNum) ) Question 8 1 out of 1 points A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____. Selected Answer: b. user view Answers: a. user field b. user view c. user attribute d. user table Question 9 1 out of 1 points The first step in creating a user view is to normalize the tables. Selected Answer: Fals e Answers: True Fals e Question 10 1 out of 1 points The type of information collected on the survey form that describes how data is updated is ____. Selected Answer: d. Processing information Answers: a. Entity information b. Attribute information c. Relationships d. Processing information
Image of page 347
Question 11 1 out of 1 points The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications. Selected Answer: top- down Correct Answer: Evaluation Method Correct Answer Exact Match top-down Question 12 1 out of 1 points How can you attempt to avoid the problem of creating a table that is not in third normal form? Selecte d Answer: To avoid the problem of creating a table that is not in third normal form: 1.we have to be cautious when representing user views 2. Should always attempt to determine whether the determinants exist and include them in tables. Particularly these kind of problems arise when we merge the result, the result might not be in third normal form and hence we have follow the steps mentioned above. Correct Answer: First, you should be cautious when presenting user views. The problem occurs when a column A in one user view functionally determines a column B in a second user view. Thus, column A is a determinant for column B, yet column A is not a column in the second user view. If you always attempt to determine whether determinants exist and include them in the tables, you often will avoid this problem. Question 13 1 out of 1 points The second step in creating a user view is to represent the user view as a collection of tables. Selected Answer: Fals e Answers: True Fals e Question 14 1 out of 1 points In an E-R diagram, a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship. Selected Answer: Fals e Answers: True Fals e Question 15 1 out of 1 points
Image of page 348
The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables. Selected Answer: d. columns Answers: a. rows b. data c. DBMS d. columns Sund Question 1 1 out of 1 points If two or more users are waiting for the other user to release a lock before they can proceed, this is known as a ____. Selected Answer: c.
Image of page 349
Image of page 350

You've reached the end of your free preview.

Want to read all 403 pages?

  • Fall '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture