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

The following choices characterize the cardinality of the entities participating in four different binary relationships. Select the one invalid binary relationship among them.

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_________________________________;