Introduction to Database Management
1
COMP 378 COMPUTER SCIENCE 378:
INTRODUCTION TO DATABASE
MANAGEMENT SAMPLE FINAL
EXAMINATION ACTUAL ONLINE WRITTEN
QUESTIONS AND ANSWERS
You will have 2 hours to complete a similar closed-book examination.
Question 1
A real estate company uses a database to store information about customers, property, and
contracts. The following relations are used in the database:
Customer: Customer number (unique), name, mailing address, Balance, lawyer name,
Discount. Contract: Customer number (unique), Agent number (unique), Property_ID (one
per contract), Date of contract, Property addresses, Property value, Type, Number of rooms,
Land size, Built size, Tax value)
The following functional dependencies
apply. customer_no 🡒 name
customer_no 🡒
mail_address customer_no
🡒 balance customer_no 🡒
lawyer_name customer_no
🡒 discount
{customer_no, Agent_no} 🡒 property_id
{customer_no, Agent_no} 🡒
date_contract property_id 🡒
property_address property_id 🡒 value
property_id 🡒 type
property_id 🡒
number_rooms property_id
🡒 land_size property_id 🡒
built_size property_id 🡒
tax_value
