Match the following normalization phase with its objective:

Please list the name and GPA for all students:SELECT s.sName, s.GPAFROM  ______________________;

Select the answer that does not describe a view (only 1 answer):

List full details of courses in the database. Order the list by course name in alphabetical order.

The following relationship ‘supervises’ is a ________ relationship type

Q18-Q19 are based on the following business requirement for a hotel management system. A hotel can have many rooms and it must have one room. A room (in the database) has to belong to one hotel and only one hotel. A particular room within a hotel has certain features (one king bed or two queen beds, handicap-accessible, etc.). For hotel, name, city, address, contact email, and contact phone needs to be recorded.

Which one of the following is the proper ER Model for the hotel management system?

Report the number of admissions (i.e., “yes” decisions) for each college that has admitted more than two applicants. Rename the total as “Admitted”:SELECT cName, COUNT(*) AS AdmittedFROM applyWHERE decision = “Y”GROUP BY cName_________________________________;

Q24-Q25 are based on the following business requirement for Car-sharing management system. Chicago runs a car-sharing program to reduce the number of cars in the city and curtail pollution. In this program, people share the ownership of vehicles – one car may be partially owned by several people. The number of owners per car may vary and each person can own a different percentage of the car. A person also might invest in ownership of more than one car. Drivers reserve future use of a car; obviously, only one person can reserve a car for any particular time. Participants in the sharing program can reserve any car, even ones they do not share ownership of. 

Which one of the following is the proper Relational Data Model for the HR managment system?