Reference no: EM132487500
Assignment - 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.
Note - Complete solution required.
|
What is the average daily collection float
: What is the average daily collection float? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
|
|
Discuss the role of the labour market in caribbean society
: Discuss the role of the labour market in Caribbean society and differentiate between the types of markets.
|
|
Describe the trend in global inequality
: Describe the trend in global inequality over the course of the last century, especially since 1970. Based on where we have been and where we are now
|
|
What challenges face oakhurst in 2011
: What challenges face Oakhurst in 2011 and beyond? How do Oakhurst's efforts to reduce carbon emissions through operation changes help address the challenges
|
|
Description of your front end language and the backend DBMS
: Description of your front end language and the backend DBMS (in a text file). SQL script files for the database creation and sample values to be inserted
|
|
What adjusting entry will wilson company make
: What adjusting entry will Wilson Company make if Allowance for Doubtful Accounts has a credit balance of $2,500 before adjustment?
|
|
What the borrower will pay
: Molson Brewing Co. issued a $60,000, 60-day, discounted note to National Bank. The discount rate is 6%. At maturity, assuming a 360-day year, the borrower will
|
|
Discuss strategies that should be used by crm instructors
: We have covered the key components in CRM that should be included in CRM training programs. CRM scenarios should be included in LOFT and other types of flight.
|
|
How does valuation compare with the closing price
: Closed at $53.82 per share on March 8, 2017, the date the 10-K was filed with the SEC. How does your valuation compare with this closing price
|