Reference no: EM131322034

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

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

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

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

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.

A surrogate key should be avoided if at all possible.

True
False

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

All versions of SQL run properly with Microsoft Access.

True
False

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

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

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