Blog

Match the following definitions with the correct terms in the drop-down menu.

Which type of database management system is MySQL?

The primary key can uniquely identify a row within a table.

Which option below is the best choice for primary key for the following Student table? (All the columns are required that is NOT NULL) Name LSUID Email GPA Degree Grad_YR John Smith 891107180 johnsmith@lsu.edu 3.7894 ISDS 2021

Q22-Q23 are based on the following business requirement for LSU Club management system II. At LSU, there are multiple clubs within the “LSU Club Association.” A club has many members and a person can be a member of many clubs. Each club has a president and a treasurer. One person can be the treasurer of more than one club, but can only be president of one club in his or her lifetime within the Association.

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 Relational Data Model for the LSU Club management system II?

Q36-Q42 refer to the schema depicted below. Click here to open in a new tab.You will need to use table department, student, professor, course, ta_assignment. For your convenience, the data rational model is attached here (underlined attributes are the primary keys (PKs); attributes in italic are foreign keys (FKs)).

Which one of the following commands removes only specified records (rows) from a table?

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