Answer Happy

Part 1 Basic Selects:
1. Use the Students table and display the city and first name for
each student, ordered by
city and first name in alphabetical order Marks 1
2. Use the Staff table and display the first/last names of all
staff who have a first name that
starts with the letter D and a last name that starts with the
letter K Marks 1
Part 2 Joins:
1. Use the Faculty and Staff tables to display the first and last
names of everyone who is
currently ‘On Leave’ Marks 1
2. Use the Students, Student_Schedules and Classes tables to
display the first and last
names of everyone currently taking a course with duration > 140.
Marks 1
3. Use the Faculty and Faculty_Classes tables to display the
StaffID of all people who
aren’t teaching a course. Marks 1
Part 3 Unions:
1. Use the Staff and Students tables to display the first and last
names of all staff and
students who live in ‘Long Beach’ Marks 1
Part 4 Grouping:
1. Use the Students and Student_Schedules tables to display each
student’s name as well
as the number of courses they are taking. Marks 1
2. Use the Students and Student_Schedules tables to display each
student’s average grade
Marks 1
3. Use the Students and the Student_Schedules tables to display the
first and last names of
all students who are taking more than 2 classes Marks 1
Part 5 Database Creation:
1. Create a new database in your phpmyadmin called “MusicDB”
4. Your database needs to store the following data: Artist first
name, artist last name,
album name, album year, Total Sale create a normalized database
that does this. Make
sure you have primary/foreign keys. Marks 1
2. Show your professor your database diagram in PHPMyAdmin
Total Marks: 10