ISDS 3003 QUESTIONS AND ANSWERS
In the Excel file, open the Student Adviser Dept List tab.
Let us assume that an adviser belongs to only one department. Examine the data in the
list. What problem or problems do you see in the data of the list? Check all that apply. -
Answer -Adviser Taing is listed with more than 1 department , Adviser Valdez is listed
with more than 1 department
Based on the data in the Student Adviser Dept List, an adviser
_________________________. - Answer -may advise more than 1 student
Based on the data in the Student Adviser Dept List, a department
________________________. - Answer -may have more than 1 adviser
The Student Adviser Dept list allows a student to have _______________. - Answer -
only 1 adviser
Which of the following might be an assumption you made in Part A about functional
dependencies? - Answer -(PropertyName, ServiceDate, Description) → Amount
Assuming that the same PropertyName can exist in more than one city, a PropertyID
field should be created to uniquely identify a property. PropertyID would be a
________________. - Answer -surrogate key
Assuming that we use the PropertyID field to uniquely identify a property and the
following functional dependencies exist:
PropertyID à (PropertyName, PropertyType, Street, City, Zip)
(PropertyID, Description, ServiceDate) à Amount
What is wrong with the relation design in Part B-4.?
PROPERTY(PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate,
Description, Amount) - Answer -PropertyID does not determine ServiceDate.
Assuming that we use the PropertyID field to uniquely identify a property and the
following functional dependencies exist:
PropertyID → (PropertyName, PropertyType, Street, City, ZIP)
(PropertyID, Description, ServiceDate) → Amount
What is wrong with the relation design in Part B-7? Choose all that apply.
In the Excel file, open the Student Adviser Dept List tab.
Let us assume that an adviser belongs to only one department. Examine the data in the
list. What problem or problems do you see in the data of the list? Check all that apply. -
Answer -Adviser Taing is listed with more than 1 department , Adviser Valdez is listed
with more than 1 department
Based on the data in the Student Adviser Dept List, an adviser
_________________________. - Answer -may advise more than 1 student
Based on the data in the Student Adviser Dept List, a department
________________________. - Answer -may have more than 1 adviser
The Student Adviser Dept list allows a student to have _______________. - Answer -
only 1 adviser
Which of the following might be an assumption you made in Part A about functional
dependencies? - Answer -(PropertyName, ServiceDate, Description) → Amount
Assuming that the same PropertyName can exist in more than one city, a PropertyID
field should be created to uniquely identify a property. PropertyID would be a
________________. - Answer -surrogate key
Assuming that we use the PropertyID field to uniquely identify a property and the
following functional dependencies exist:
PropertyID à (PropertyName, PropertyType, Street, City, Zip)
(PropertyID, Description, ServiceDate) à Amount
What is wrong with the relation design in Part B-4.?
PROPERTY(PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate,
Description, Amount) - Answer -PropertyID does not determine ServiceDate.
Assuming that we use the PropertyID field to uniquely identify a property and the
following functional dependencies exist:
PropertyID → (PropertyName, PropertyType, Street, City, ZIP)
(PropertyID, Description, ServiceDate) → Amount
What is wrong with the relation design in Part B-7? Choose all that apply.
