· You will be asked to demonstrate your ability to apply what you’ve learned so far by writing SQL statements, drawing diagrams and normalizing data.
· The exam is issued in the class lab, so you many use our class materials, your personal notes and the SQL server software to assist you with answering questions. You may NOT use another person, or software which facilitates communication with another person (IM, chat, email, Twitter, Facebook, etc…)
· I will use classroom monitoring software during the exam to observe what each student has on his/her screens. Any student not completing the exam on their own merit or found assisting another student will receive a zero on the exam.
· You will access the exam questions through Blackboard, and upload your answers to Blackboard when you’re finished via the provided submission file.
· Some questions will require fudgemart tables from the lab; some will require NetFlix tables from the assignment.
· There will be 5 questions, worth 3 points each. You will be awarded
o 3 points for a correct answer,
o 2 points for an incorrect answer with only 1-2 minor mistakes,
o 1 point for an incorrect answer with serious errors (more than 3 mistakes).
o 0 points for an unanswered question, or completely incorrect question.
· You will receive a RAW exam score out of 15 which will then be translated into a score out of 100.
· There will be a final “wildcard” bonus question worth 1 extra credit point. If you answer it correctly 1 point will be added to your RAW score up to a maximum 15/15.
You will be asked to:
1. Take specific data requirements and draw an equivalent conceptual ERD from those requirements (similar to the conceptual modeling lab).
2. Take an existing conceptual ERD and map it to a logical model diagram (similar to the logical modeling lab).
3. Create SQL tables, keys, and constraints from a given logical model diagram (as required on the assignment).
4. Identify functional dependencies, normal forms, and produced tables in 3NF from a sample data set (like quiz 6).
5. Use SQL to migrate and convert data from one SQL table to another (similar to the last lab).