National University of Computer and Emerging Sciences, Islamabad CS -484 Homework6 Triggers and Procedures. - Metropolitan State University ICS 311 —Database Management Systems Homework #6 Due: see syllabus Homework #6
Download the file named “assignment6_database.sql” from D2L. Run the file in MySQL
workbench. Familiarize yourself with the database before starting to write your queri
...[Show More]
National University of Computer and Emerging Sciences, Islamabad CS -484 Homework6 Triggers and Procedures. - Metropolitan State University ICS 311 —Database Management Systems Homework #6 Due: see syllabus Homework #6
Download the file named “assignment6_database.sql” from D2L. Run the file in MySQL
workbench. Familiarize yourself with the database before starting to write your queries.
Once you are familiar with the data, start working on the following questions.
What to submit:
1. A .sql file with all your answers. Make sure that all of your SQL works without
error. If there is a failure in your answers (E.g. missing semi colon), grades will be
deducted.
Answer the following questions based on the above database:
1) (4 Points) Create a view called “Flight_Rating_V” that includes the following
Employee First and Last Name, Earned rating date, Earned rating name for all
employees who earned their rating between Jan 1st, 2005 and Jan 1st, 2015. Your
answer should include both the SQL statement for view created along with the
contents of the view (You get the contents of the view by Select * From
[Show Less]