Spring 2024 — Exam1 guide
Tentative plan as of 14-Jan-2024
Where and When
- Test date: 13-March-2024
- Test time: 12:00pm-12:50pm EST (class time)
- Test location:
Rice 130
- The exam is a paper-based exam.
It will be administered in a classroom, in-person.
Conflicts
- All conflicts should have been reported and
an alternative exam date must be arranged in advanced.
Make-up exam
Please refer to the
Make-up exam section
on the course
Policies page.
SDAC accommodation
If you need accommodation, please submit proper documents to SDAC.
We unfortunately cannot provide accommodation in class or during office hours.
Please schedule to
take the exam at SDAC.
Please visit
https://www.studenthealth.virginia.edu/SDAC or
use the direct link
https://yukon.accessiblelearning.com/virginia/Default.aspx
to schedule your exam.
What to bring
- Pens, pencils, erasers, writing utensils
- One cheat sheet (see detail in test specific) -- this is optional
- No calculators, scratch paper, backpacks, books, laptops,
or anything else should be brought.
These items will be left in the back/front of the room if you bring them.
Test specific
- Exam1 is closed book / notes / laptops / web / electronic devices / neighbors;
paper-based, administered in class, no collaboration.
No online version. No take-home version.
- The only exception is a single sheet of 8 1/2 x 11 paper
with
handwritten by the person taking the exam
(may write on both sides of the sheet).
- A cheat sheet must be in your handwriting.
- Only handwriting on a single sheet of paper is allowed.
- **NO** writing on electronic device(s) and print.
- We must take away any sheet that violates this rule
and/or assign a zero grade on the exam.
- Refer to the Coverage section below for the exam coverage.
- Only what has been introduced or discussed in Spring 2024 CS 4750 will be covered.
We will not ask you for anything that has not been covered in this course this semester.
- The format of the exam will be similar to POTDs, activities, and homework assignments.
- You may expect different kinds of questions:
- Short answer
- Multiple choices (less likely but possible)
- Matching (less likely but possible)
- True/false (less likely but possible)
- Problem-solving
- Discussion
- Design and diagram drawing
- (SQL) Code reading, writing, and fixing
- Very minor syntax errors are acceptable.
Major syntax errors result in point deductions.
Major things you can expect
- Some questions related to the material discussed in class
- Some questions related to POTDs, activities, examples, homework assignments
Coverage
- General understanding of database systems
(meetings 2-3, and concepts we discussed throughout the semester)
- Database design: E-R model
(meetings 4-7)
- Database design: functional dependencies, normalization
(meetings 8-11)
- SQL (meetings 12-18) — excluding advanced SQL which will be covered in Exam2
- Basics
- Aggregates
- Joins
- Subqueries
- Subqueries in WHERE and quantifiers
Study guide
- Review the lectures / materials / slides / online resources / class recordings
- Redo POTDs, activities, examples
- Review or redo homework assignments
- Practice writing SQL
- You are expected to remember the fundamental and syntax covered in class
and be able to write SQL with correct syntax.
- A few very minor syntax errors is OK.
But if you are really off we will take off points.
- Get a good night's sleep
A sample/past exam will be available in Canvas/Files.
Note: the emphasis of some content/materials may be different between semesters.
The sample exam is provided for additional practice only.
Our exam will be based on what is introduced/discussed/emphasized in Spring 2024.
A final note
Here is A Time-effective Strategy for Taking Exams
by Professor Jeff Offutt.
Good luck !
Copyright © 2024 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2024-01-14 12:23