Final Exam

1. Multiple Choice Exam (40 points).

Download the file Final Exam. Save this file as "final-exam-name.docx". Where "name" is replaced with your real name. Answer the 40 questions in this document.

2. SQL Quiz (30 points).

Select the link "SQL Quiz" (see red box below) under at W3 Schools. You will have to scroll down to find this link. You can take this quiz as many times as you like. For full credit, continue taking this quiz until you have correctly answered all questions.

Take a screen capture of your monitor (similar to the image below) showing your final score. Insert your screen capture at the end of your document "final-exam-name.docx" that you saved in (Part 1).

3. Entity-Relationship (E-R) Diagram (30 points)

Create an Entity-Relationship (E-R) diagram that models the information below. Insert your E-R diagram at the end of your document "final-exam-name.docx" that you saved in (Part 1).

Assume the following:

• Each student is assigned one and only one faculty adviser and must have an adviser. One faculty member may advise several students, but faculty members are not required to advise students. Only the fact of this assignment is to be recorded in the data model—not possible related data (such as the date the adviser was assigned to the student).
• Each student may be assigned one and only one mentor, but students are not required to have a mentor. One mentor may mentor several students, and a person may be listed as a mentor before he or she is actually assigned students to mentor. Only the fact of this assignment is to be recorded in the data model—not possible related data (such as the date the mentor was assigned to the student).
• Each mentor is assigned to work and coordinate with one and only one faculty member, and each mentor must work with a faculty member. One faculty member may work with several mentors, but faculty members are not required to work with mentors. Only the fact of this assignment is to be recorded in the data model—not possible related data (such as the date the faculty member was assigned to the mentor).
• Each mentor may be an alumnus, but mentors are not required to be alumni. Alumni cannot, of course, be required to become mentors.

  Hint: Recreate the following diagram adding the appropriate Crow's Foot notation.

  

4. Upload your file "final-exam-name.docx" to YOUR-CLASS-WEBSITE.  Help

5. For students in IS 4293. Press on "Learning Modules" / "Week 16" for this course on NSU Blackboard. Then press the hyperlink that corresponds to the course reference number (CRN) you are enrolled in (e.g., "Final Assessment Exam (IS 4293 - CRN 31233"). This will launch the NSU "Watermark Student Learning and Licensure" (assessment) software application. Answer the 40 multiple choice questions.