Description

File Organization and Database Management Mini Project 2
Name:
This is a mini project for MSDS 7330, File Organization and Database Management. For this assignment, turn in a single pdf file containing all of your answers. The file should be named “yourLastNameMiniProject-Number.pdf”. For example, the file name for my mini project 1 would be ‘RafiqiMiniProject-1.pdf’.
MySQL Database
1. Produce a list of all the students in the student relation, including their ID, name and department name, sorted into ascending order by their name.
2. Produce a list of the names and salaries of professors in the Comp. Sci. and Elec. Eng. departments ordered by decreasing salary.
3. Find all courses whose identifier starts with the string ”CS-1”
4. Find the maximum and minimum enrollment across all sections, considering only sections that had some enrollment, don’t worry about those that had no students taking that section
Capture the sequence of queries and resulting output thereby demonstrating your database in operation. Turn in a pdf of screenshots of your database in operation.
Resources: