|Name||:||Terry Sergeant||Office Hours|
|Description||:||Students will learn concepts and definitions foundational to modern database systems. Topics include the relational model, SQL, E-R modeling, and normalization. Concepts of database design and practice will be implemented using a modern database management system.|
A homework assignment is considered late if it is not submitted at or before the beginning of the class period on the day it is due. Late homework assignments will receive a 30% point penalty and must be completed within a week or the original due date. Assignments that miss the one week deadline will receive a grade of 0 (unless there are extenuating circumstances).
In order to do well on the quizzes and exams it will be necessary for each student to work homework assignments independently. There are times, however, when you may become stuck and require assistance. For this reason, the standard regarding independent homework is quite loose:
When working a homework assignment you must not make any sort of electronic copy of work that is not your own. Also, you must type assignments yourself. Failure to abide by these rules is a violation of the academic integrity standards for this course.
Unless directed otherwise, all assignments will be submitted by e-mail to the following address: firstname.lastname@example.org.
Office of the Director of Undergraduate Advising and Disabilities of such as soon as possible in the academic term (preferably during the first two weeks of a long semester) for which they are seeking accommodations. The director will prepare letters to appropriate faculty members concerning specific, reasonable academic adjustments for the student. The student is responsible for delivering accommodation letters and conferring with faculty members. Please refer to the most recent version of the Undergraduate Catalog for the complete policy. (Rachel King, Director of Undergraduate Advising and Disabilities, Office: SM-209, Phone: 670-5842, Email: email@example.com)
Cases of suspected academic dishonesty will be handled in accordance with university policies outlined in Undergraduate Catalog and in the Student Handbook. The current catalog prescribes that ``no student who has violated the Academic Integrity Policy will be allowed to graduate from Hardin-Simmons University with honors.'' Penalties will be assigned at the discretion of the instructor and typically range from failure on the assignment to failure of the course. A general rule-of-thumb is that a first offense (if not too major) will result in a zero on the assignment and a second offense will result in an F for the course. The current catalog states that an F earned in this way cannot be replaced by retaking the course.
Accordingly, absence from more than 25 percent of class meetings and/or laboratory sessions scheduled for a course (including absences because of athletic participation) is regarded as excessive, and a grade of F may be assigned as deemed appropriate by the professor.
|Week||Date||Topic / Schedules|
|Week 1||29 Aug||Introduction / Overview|
|Week 2||05 Sep||SQL|
|Week 3||12 Sep||SQL|
|Week 4||19 Sep||ER-Modeling / Normalization|
|Week 5||26 Sep||Normalization; Exam #1 (Thu)|
|Week 6||03 Oct||Integrity Mechanisms|
|Week 7||10 Oct||JDBC|
|Week 8||17 Oct||JDBC / Programming|
|Week 9||24 Oct||Programming / Transactions|
|Week 10||31 Oct||Indexing; Exam #2 (Thu)|
|Week 11||07 Nov||Stored Procedures|
|Week 12||14 Nov||Stored Procedures / Triggers|
|Week 13||21 Nov||NoSQL; Wed-Fri: Thanksgiving!|
|Week 14||28 Nov||NoSQL|
|Week 15||05 Dec||Misc. Topics|
|-----||Final Exam Tue 12 Dec @ 10:30am|