Upon completion of this course, students will be able to:
There will be weekly assignments throughout the semester. The SQL assignment due dates are Mondays at 11:59 PM, unless told otherwise. Assignments should be submitted through the Canvas website, and I will return assignment grading reports to the same website. Assignments are listed under "Assignments" in Canvas. All assignments must be individually and independently completed. I will provide feedback and post assignment grades within a week of the due date.
Assignments will be in the form of SQL scripts. Scripts should be text only with the .sql extension. You will need to label your assignments with your first initial, last name, and the name of the assignment. Example: hibrahim_assignment1.Zip the files to upload to Canvas (hibrahim_assignment1.zip).
This course allows Pass/No Pass grading. Check the official calendar for the deadline to make this choice. Your final grade is determined by points you earn in the following areas:
Submission |
Total Points |
Percentage % |
SQL Assignments & Quizzes |
450 |
45% |
Final Project |
100 |
10% |
Midterm Exam |
200 |
20% |
Comprehensive Final Exam |
250 |
25% |
TOTAL |
1000 |
100% |
Grading Scale:
% of Points | Letter Grade |
90 – 100 |
A |
80 – 89 |
B |
70- 79 |
C |
60 – 60 |
D |
< 60 |
F |
Fail/Withdraw |
FW |
There will be bi-weekly quizzes listed under "Quizzes" in Canvas containing a series of multiple-choice and short-answer questions to reinforce knowledge of SQL commands and relational database systems. Quizzes are always due on Monday by 11:59 PM. Unlike assignments, late submissions will NOT be accepted for the quizzes The quizzes and exams are given online and are open book.
This is a comprehensive project that will require and integrate all of the skills you have learned in this course. This project will focus on relational databases and SQL. You will use the MySQL system for this project. The student will design, create, and populate a working database from description requirements provided by the instructor.
Midterm Exam: This is an online exam scheduled
on Friday March 16,2018.
,
Final Exam: This is an online exam scheduled
on Wednesday December 16 2018.
The exams will be available for exactly 18 hours starting 6:00 AM on the due
date and be due no later than midnight. You must take the exams within
that 18 hour period.
All exams and quizzes will take place on Canvas.
Do not wait until the last minute to take an exam as you are responsible for
unforeseen circumstances, such as if a technical problem occurs. You may see
true/false, multiple-choice, short-answer, and programming questions.
There are weekly programming assignments that assigned every Monday and due by the following Monday at 11:59 PM unless specified otherwise. Programming assignments will be accepted up to four days past the original due date. They will be considered late and will receive a 10% deduction, with no exceptions. For example, if a programming assignment is due on Monday at 11:59 PM, it can be turned in by 11:59 PM on Friday.
Since this is an online course that utilizes discussion forums, it is important for all students to participate in the course promptly actively. The Canvas Forum is the main place for our class discussion. You can ask questions regarding course materials, assignments, and exams on the forum. Students are expected to participate in all discussions. Please consider the following general participation expectations:
Think of these forums as our online classroom. The forums on the website are a good way of interact with other students, exchange thoughts, ask and answer questions as well as take part in the public discussion. I will check the weekly forums on a daily basis and will respond to questions as needed. I also highly encourage students to read and respond to posts from fellow peers. You must also post an introduction within the first week to avoid being dropped as a no-show.