437Midterm_Fall 2006_T1

Show only ship type and the number of ships of each

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: er of ships of each type. Sort by the type count descending. Your answer must appear like this: Ship Type Type_Count ---------- ----------- Tanker 5 Container 4 COMM 437 Mid-Term Exam (Fall 2006 Term 1) Page 2 of 6 (c) [5%] Provide a list of ALL ports and the ships that consider these ports their home ports. Show only the port name and ship name. Sort by port name. Your answer must appear like this: Port Name Ship Name ---------- --------------- Coquitlam Queen of Dunbar Coquitlam The Ripper Port Moody Vancouver Jolly Roger (d) [5%] Provide a list of ships that arrived in their home ports in the month of August 2006. Show only the port name and ship name. Your answer must appear like this: Port Name Ship Name ---------- --------------- Coquitlam Queen of Dunbar Coquitlam The Ripper Vancouver Jolly Roger COMM 437 Mid-Term Exam (Fall 2006 Term 1) Page 3 of 6 Question 2. Relational Database Design and Normalization (Total 20 marks) Co...
View Full Document

Ask a homework question - tutors are online