7. The table below shows the database of vehicles on a used car lot. It\'s actua

Question

7. The table below shows the database of vehicles on a used car lot. It's actually just a portion of the list, but for the purposes of this question, assume it lists all the vehicles Category Sedan Truck SUV Sedan Sedan Minivan Sedan Make Chevrolet Ford Ford Toyota Honda Honda Chrysler Color Yellow Black Silver Maroon Blue Blue Red Year 2008 2013 2013 2003 2002 2010 2014 a. Give a key for this database. b. Show the results of the operation SELECT[Category -"Sedan" A Year > "2008"]. c. Show the results of the operation PROJECT[Color] d. Show the results of the operation SELECT[Make = "Ford"] followed by PROJECT[Color]. 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 vehicles were made by Honda and made after 2005?

Explanation / Answer

a. The database key is combinaiton of keys Category and Make.i.e) Primary key=(Category,Make).This can be uniquely identifies the table.

b.) Selects all rows with the category =Seden and year >2008

Category Make Color Year

Seden Chrysler Red 2014

c) Select all unique values in column - Color

Color

Yellow

Black

Silver

Maroon

Blue

Red

d) .Select all rows with make =ford and with all projected colors

Category Make Color Year

Truck Ford Black 2013

SVU Ford Silver 2013

e) SELECT [Make="Honda" ^ Year>2005 ]

Output : Category Make Color Year

Minivan honda Blue 2010

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

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