test review part 7

Question 1

A(n) _____________ represents something of importance to the user that needs to be represented in the database

Answer 1

entity

Question 1

is a missing value in a cell in a relation

Answer 1

null value

Question 2

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

a) True
b) False

Answer 2

b) False (that would be an application)

Question 3

types of relationships

Answer 3

1. Unary: 1st degree (recursive)
2. Binary: 2nd degree
3. ternary: 3rd degree

Question 4

This form has the following characteristics:

• each table is in 3NF and all determinants are candidate keys

-All remaining determinants of that entity are candidate keys (i.e. could be the PK)

Answer 4

BCNF (Boyce Codd Normal Form)

Question 5

Which normal forms are the most critical for developing a working database?

-The other forms, outside the scope of a database intro course, add refinements that are valuable but not as critical

Answer 5

The first three

Question 6

Data analysis used for research is stored in this type of db.

-this is an example of Business Intelligence

Answer 6

OLAP