QUESTION 1

Redundant data increases the risk of data anomalies when you perform which of the following actions:

		Insert data
		Update data
		Delete data
		All of the above

 

QUESTION 2

Microsoft Access is an example of which of the following:

		Enterprise-class database system
		Personal database system
		Business-class database system
		None of the above

 

QUESTION 3

One of the desirable characteristics of a primary key is:

		It contains useful information about the row.
		It may change and adapt as the database grows.
		It is minimal.
		It should allow us to use the same value to identify multiple rows.

 

QUESTION 4

A surrogate key should be avoided if at all possible.

 True

 False

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 5

The process of breaking a table into with more than one theme into two or more tables each with only one theme, thus eliminating redundancy, is called:

		Functional dependency
		Relating
		Deconstructing
		Normalization

 

QUESTION 6

SQL stands for:

		Sequential Language
		Successive Query Language
		Structured Query Language
		Structured Qualifying Language

 

QUESTION 7

All versions of SQL run properly with Microsoft Access.

 True

 False

 

QUESTION 8

In a 1:N relationship, the entity on the “one” side of the relationship is referred to as the __ and the entity on the “many” side is referred to as the __.

		Parent…child
		Child...Parent
		Preceding…Succeeding
		Succeeding…Preceding

 

 

 

QUESTION 9

An entity that cannot exist in a database unless another type of entity also exists is called a:

		Dependent entity
		Strong entity
		Special entity
		Weak entity

 

QUESTION 10

An attribute of a supertype entity that indicates which of the subtypes is appropriate for a given instance is called a(n):

		Discriminator
		Determiner
		Instance option
		Association

 

QUESTION 11

Write the SQL SELECT statement to display the property type, rooms, and rent sorted by the Type.

Use the following PROPERTY table to answer the question:

PropertyID	Type	Rooms	Rent
306	Apt	3	550
308	House	6	1000
325	Apt	4	625
397	Apt	3	550
412	House	7	1250
441	Apt	2	475

 

 

 

 

 

 

 

 

 

 

 

 

 

UESTION 12

Write the SQL SELECT statement to display the average rent of the properties.

Use the following PROPERTY table to answer the question:

PropertyID	Type	Rooms	Rent
306	Apt	3	550
308	House	6	1000
325	Apt	4	625
397	Apt	3	550
412	House	7	1250
441	Apt	2	475

 

QUESTION 13

What is normalization?  Explain why it is important.

QUESTION 14

List and describe the 4 components of a database system.

 

Attachments:

• 1507810855-Wk4 Review Questions.docx