IT 203_Week03_Homework

IT 203_Week03_Homework - IT 203 Trinity Martin Week 03...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
IT 203 Trinity Martin Week 03 Homework A. You want to track class sections and student enrollments at a technical school. Each student attends at least four classes. You need to quickly retrieve student and class information. The most efficient way to store this information is a one-to-many relationship. a. True b. False B. What is the minimum number of tables required to establish a many-to-many relationship? a. 2 b. 3 c. 4 d. 5 C. You are setting up a database for a video rental company. You need to track the videos rented by each customer. Your design includes a Customer entity and a Video entity. How should you design these entities? a. Two unrelated entities b. One-to-many with Video as the weak entity c. One-to-many with Customer as the weak entity d. Two entities with a many-to-many relationship D. You are designing employee tables for a business. Each employee fills out a time card each week. Your design includes an Employee entity and a TimeCard entity. How should you design these
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/26/2011 for the course IT 203 taught by Professor Accampo,e during the Spring '11 term at ITT Tech Pittsburgh.

Page1 / 2

IT 203_Week03_Homework - IT 203 Trinity Martin Week 03...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online