ACCT 6940 Quiz 1 with (10 out of 10 points)

$10.00

Category: Tag:

Description

Questions

  1. __________ is an attribute or a set of attributes that uniquely identify a specific instance of an
  2. __________ is the process of restructuring a relational database in order to reduce data redundancy and improve data
  3. Analyzing the effect of minimum wage changes on teenage employment across the 48 contiguous S. states from 1980 to 2004 is an example of using:
  4. Studying inflation in the United States from 1970 to 2006 is an example of using:
  5. A candidate key is __________.
  6. _________ database maintains the advantages of the relational database but stores data as objects or classes first.
  7. The first step of the normalization process is to __________.
  8. Analyzing the behavior of unemployment rates across S. states in March of 2006 is an example of using:
  9. The accompanying table is an example of:
Industry Time Sal Pay Cap Abat
Ind 1 1991 12.78 56.78 100.89
Ind 1 1992 10.78 48.89
Ind 1 1993 124.78 30.89
Ind 2 1991 123.67 29.56 67.89
Ind 2 1992
Ind 2 1993 139.99 18.89
Ind 3 1991 178.90 20.78
Ind 3 1992 21.22 67.89 1.28
Ind 3 1993 21.24

 

  1. In a relational database design, all relationships are expressed by __________.
  2. What is the main characteristic of Hierarchical database?
  3. The accompanying graph is an example of:
  4. The accompanying graph is an example of:
  5. Panel Data:
  6. In some instances, an entity will have more than one attribute that can serve as a primary Any key or minimum set of keys that could be primary key is called?
  7. Given the relations:

STUDENT (SID, StudentName, Major, AdvisorID)

ADVISOR (AdvisorID, AdvisorName, Office, Phone)

such that each student is assigned to one advisor, which of the following is true?

  1. __________ is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table
  2. The accompanying table is an example of:
Month Customer ID Amount Spent Basket Size
January A1 3020 8
February A1 3524 18
March A1 2678 15
April A1 3577 7

 

  1. What type of analytics seeks to determine what is likely to happen in the future?
  2. The accompanying table is an example of:
Customer ID Amount Spend Basket Size
A1 3020 8
A2 4936 15
A1 3524 18
A3 2746 23
A4 2525 12
A2 7774 10
A4 1856 6
A1 2678 15
A4 6675 15
A5 2033 9
A3 5655 29
A4 6951 17
A1 3577 7
A5 5190 11