The following question refers to this table. Stu_Reg           stuID stuFName StuLName courseName majorCode majorDesc 1 John Chesson Database ISDS Information Systems and Decision Sciences 2 Kevin Adams Database ISDS Information Systems and Decision Sciences 3 Jamie Spearman Statistics ACCT Accounting Referring to the table above, which of the following describes a deletion anomaly? 

What operation aims to establish associations between records, or sets of records, in a database?

What does “ETL” in the ETL process refer to?

Explain the difference between the ‘DELETE’ and ‘DROP’ commands in SQL.  Be thorough with your answer.  Detail how the outcome differs if each command is executed on a specific database object such as the ‘STUDENT’ table. 

Describe two situations that we discussed in class when a view would be beneficial to use rather than base tables.  What is the benefit that the view adds?

22. How many colleges have received applications? (4 points)  23. Report the name and GPA of students with a GPA greater than 3.5. List the results by GPA from highest to lowest. (4 points)  24. Please help LSU find the names of admitted students. (4 points)  25. For each college, report the college’s name and number of applications (rename as NumOfApp) from students with a GPA of 3.0 or above. (4 points)   26. Report the majors applied to by all students who attended a high school with fewer than 1,000 students. Do not use a nested query. Eliminate duplicate results. (4 points)  

A __________ is a software system that enables users to define, create, maintain, and control access to the database (spell out).  

What is the SQL command that specifies the columns that will show up in the result?  

Studies investigating close relationships and physical health have repeatedly found that:

For the third time in two months, Erica’s husband rushed her to the hospital emergency department because Erica thought she was having a heart attack. Her symptoms included a racing, pounding heart, weakness, feeling faint, and feeling as if she were unable to breathe. Although her doctor says she is physically healthy, Erica lives in fear of another attack. Erica is most likely suffering from which psychological disorder?