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