3. Consider the following small database whose records correspond to flights dep

Question

3. Consider the following small database whose records correspond to flights departing from an airport Airline Flight number Gate Destination Departure time Fly Right 122 34 Detroit 08:10 JetGreen 221 Denver 08:17 JetGreen 122 33 Anchorage 08:22 JetGreen 323 34 Honolulu. 08:30 199 13 Detroit 08:47 Fly Right JetGreen 222 Denver 09:10 Fly Right 322 34 Detroit 09:44 a. Are the attributes Airline and Destination a key for this database? f tw f attribut that keys for this datab c. She the results of the operation SELECTIAirlin Destination "Denver"] d. Show the results of the operation PROJECT[ Airline, Gate e. Show the results of the operation SELECTED "Denver"] followed by Proj f. What operation or operations should be performed if you wanted to know which airlines use gate 2 g. What operation or operations should be performed if you wanted to know whether there are any flights to Detroit departing before 9:10? 4. Th gs for the C Departm f th but for the purp tually Course number Course title Instructor Quarter CS 111 Digital Image Processing Majumder Spring CS 112 Computer Graphics Majumder Spring CS 117 Project in Computer Vision Fowlkes Fall CS 116 Computational Photography & Vision Fowlkes Winter CS 122A Introduction to Data Management Carey Spring CS 122A Introduction to Data Management Li Winter CS 122C Principles of Data Management Carey Winter a. Give a key for this database b. She f the top SELECTIC CS122A CS122C c. Show the results of the operation PROJECT[ Instructor d. Show the results of the operation SELECT[Quart Sp lfollowed by Project Course number]. Express in English what question this combination of queries is asking e. What operation or operations should be performed if you wanted to know which quarters CS 122A is being offered f What operation or operations should be performed if you wanted to know which courses are being taught by Prof. Maj f this q

Explanation / Answer

Question 3
1. No Airline and Destination are not keys for this database as using key we can determine the unique row in the database.
for example there may be many airline of same name to same destination.

2. Key for this database is (Flight number and Gate) as using them we can get unique row from the set.

3. (JetGreen 221 33 Denver 08:17) is the result of SELECT[Airline="JetGreen" ^ Destination="Denver"]

4. return all the Airline and Gate from the Database

e.

f. select Airline from database_name where gate = 22;

g. select * from database_name where Destination = 'Detroit' and Departure time < 09:10;

Question 4.

a) Course and Quarter are the key for the database.
b)

c.

d. This is asking the course number being floated in Spring.
e. select Quarter from database_name where Course number = "CS 122A";
f. select Course number, Course Title where instructor="Majumder";

Airline Gate FlyRight 34 JetGreen 22 JetGreen 33 JetGreen 34 FlyRight 13 JetGreen 22 FlyGreen 34

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.