Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Introduction to Database Management: Sample Final Examination Questions and Answers, Exams of Computer Science

A sample final examination for comp 378: introduction to database management. It includes multiple-choice questions and exercises covering key concepts such as database normalization, relational database design, sql queries, database recovery techniques, and database architectures. Valuable for students preparing for their final exam in database management courses.

Typology: Exams

2024/2025

Available from 11/25/2024

passlist-passlist
passlist-passlist 🇺🇸

5

(3)

2.1K documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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
pf3
pf4
pf5

Partial preview of the text

Download Introduction to Database Management: Sample Final Examination Questions and Answers and more Exams Computer Science in PDF only on Docsity!

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

Introduction to Database Management 1 Transform these relations into 3NF (please use only the attributes described above, and do not add any new attributes). Question 2 Draw a class diagram for the following situation. An airline company has a number of planes. The attributes of a plane include plane_id (unique), name, and vendor. The airline company serves many destinations. The attributes of a destination include destination_id (unique), name, and flight_date. Each plane flies to one or more destinations; or it may be used as back-up; or it may be under maintenance, and therefore will not fly to any destination. For each plane undergoing maintenance, the company records the name of the technician and the type of maintenance performed. A destination may be served by one or more planes. Each plane’s service

2 Computer Science 378 aborted. b. A customer service representative entered an incorrect data price for a customer transaction. Several weeks after the accounting department has processed the transaction, the customer returned and discovered the mistake.

Introduction to Database Management 3 Question 6 Contrast two-tier architecture with three-tier architecture. Question 7 a. Briefly contrast transient data with periodic data in data warehousing. b. Briefly discuss the characteristics of a surrogate key, as used in a data warehouse or data mart.