This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: DISC 3376 Homework No. 9 Due: Tuesday, February 19, 2008 This assignment focuses first on some of the exercises on pages 298-303 of Chapter 6. Let’s start by doing Exercises 10 and 11. Comment On exercise 11, a correct response to part a would be: Answer to the question: E. Mills, R. Brooks, L. Silva, R. Lence, E. Blair, H. Newman. The relational algebra operation would be a projection operation on the Dr_name attribute. For example, using the pseudocode discussed in class: PROJECT DRIVER OVER DRIVER.Dr_name GIVING ANSWER. ________________________________________________________________________ In addition, let’s get some more practice creating ER diagrams. This time you have been asked to design a database for the Kemah International Airport. The database is used to keep track of airplanes, their owners, airport employees, and pilots for the airport. From the requirements for this database, the following information was collected. Each AIRPLANE has a registration number, is of a particular following information was collected....
View Full Document
- Spring '08
- Relational model, Pan American World Airways, Boeing 707, Owner Degree