?Simple relational database question, i\'ve answered it, so just need to check m

Question

?Simple relational database question, i've answered it, so just need to check my answers. Here's the question;

My answer;

Thank you!

EXERCISES I. Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number (MECHNUM), airport name (AIRNAME), and skill number are all unique fields. SIZE is an airport's size in acres. SKILLCAT is a skill category, such as an engine skill, wing skill, tire skill, etc. YEARQUAL is the year that a mechanic first qualified in a particular skill; PROFRATE is the mechanic's proficiency rating in a particular skill. MECHANIC Table MECHNUM MECHNAME AGE SALARY AIRNAME AIRPORT Table AIRNAME CITY STATE SIZE YEAROPENED

Explanation / Answer

A) Correct

B) Correct

C)

SELECT AIRNAME FROM AIRPORT WHERE STATE = 'CALIFORNIA' AND ( SIZE >= 20 OR YEAROPENED >= 1935 ) ;

D) Correct

E) Correct

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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