Considering the above database, display the list of employees who are certified for Boeing aircraft.
computer science
Description
(Solution to be uploaded
individually to the folder shared with you. Please do not mail with any
attached file.
Assignment due date: 8th
April, Wednesday.)
The following
relations keep track of airline flight information:
Flights(flno:
integer, from: string, to: string, distance: integer, departs: time, arrives:
time, price: integer)
Aircraft( aid:
integer, aname: string, cruisingrange: integer)
Certified( eid:
integer, aid: integer)
Employees( eid:
integer, ename: string, salary: integer)
(Note that the
Employees relation describes pilots and other kinds of employees as well; every
pilot is certified for some aircraft, and only pilots are certified to fly. )
Considering the
above database, display the list of employees who are certified for Boeing
aircraft. Have the database connected to any of the programming languages to
retrieve the values from the database. Choices of the backend DBMS and
programming language for the front end are to be made by you.
(Python,
HTML/PHP, Java, C are the usual choices. Choose based on your comfort.)
You are free to
extend your Web Tech project concept and adapt your solution to the given
database.
Submission
model: submit a zip file with the following contents. Focus is on the database
connectivity. So, front end design can be kept minimal.
1. Description
of your front end language and the backend DBMS (in a text file)
2. Source
code file(s) for your front end program logic.
3. SQL
script files for the database creation and sample values to be inserted.
4. Snapshots
of the query execution – output
