



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
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
1 / 5
This page cannot be seen from the preview
Don't miss anything!
Introduction to Database Management 1
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.