A software developer has built a relational database model for the Learning Management System of an online learning website. Various relations (tables) are defined to store data records related to each entity in a separate relation. Three of the Relations (STUDENT, COURSE, and ENROLLMENT) defined in that database model along with their attributes are given below: The developer needs to extract the following information given in Table-1 from his defined database model using the relational database queries that consist of SELECT, PROJECT and JOIN operators. Now, in the below given table (Table-2), some relational database operations (Queries) related to the above database model are defined along with the name of resulting new relation. The name of the resulting new relation is also used as reference to identify that query (i.e. each query is referenced as A, B, C, D, E, F, G, H, I, J, K, and L). This table (Table-2) contains both syntactically correct and incorrect relational database queries (referenced as A to N ). Out of these twelve (12) queries, six (6) syntactically correct queries can be used to extract the information required in the table-l. You are required to identify the correct relational database query from Table-2: Relational Queries for each of the "Required Information" entry in Table-1 and mention its reference label in the 2nd column of the below given table against the Sr. no. of Required Information. For example, the answer to "Sr. no. 1 entry of "Required Information" column is query "A" which is solved in the below given table. Now, you need to fill the remaining five (5) entries in the below given table with the Reference label of correct relational database against each Sr. No. of the required information table. (Provide your Answer only in the below given Table) Note: You don't need to copy the assignment statement or write any queries in your solution file. Just mention the "reference label" of the correct relational database query from table-2 against the Sr. No. of "Required Information" in the above table
