Database Systems Syllabus
CSCI 4320
Spring 2024
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. |
Textbook |
: |
None required. |
Students who satisfactorily complete this course will (hopefully) be able
to:
- create, maintain, and query databases using at least two DBMS's
- understand and apply the normalization process to the design of a
database
- represent a database design in accordance with the ER Modeling scheme
and UML notation
- create, maintain, and query relational databases using SQL
- manipulate a database from control of a program
- design, create, and query a non-relational DBMS
- articulate understanding of related issues such as database
administration, transactions, query processing/optimization, etc.
Your grade in the course will be earned / calculated as follows:
homework |
|
25% |
exam #1 |
|
25% |
exam #2 |
|
25% |
final exam |
|
25% |
A |
|
90 |
– |
100 |
B |
|
80 |
– |
89 |
C |
|
70 |
– |
79 |
D |
|
60 |
– |
69 |
F |
|
0 |
– |
59 |
Homework will be assigned and graded on a regular basis. Point values (and
lead time) will vary in accordance with the difficulty of the assignment.
Due dates and times for homework assignments are provided in Canvas. Late
homework assignments will receive a 20% 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 exams it will be necessary for each student to work
homework assignments independently. Each assignment will give specific, detailed instructions regarding allowed and disallowed resources.
All assignments will be submitted in Canvas according to the instructions for
that assignment.
All exams are comprehensive. The final exam will take place at the scheduled
time during finals week. Exams will never be collaborative in nature so
receiving any form of assistance from any source other than the instructor is a
violation of the academic integrity policy. You may only use study aids during
the exam if they are expressly allowed by the instructor for that particular
exam.
An individual with a disability is defined by the Americans with Disabilities
Act (ADA) as a “person who has a physical or mental impairment that
substantially limits one or more major life activities.” Any student with a
documented disability may choose to seek accommodations. Eligible students
seeking accommodation should contact the
Director of Undergraduate Advising and Disabilities
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. (Carol Krueger, Director of
Undergraduate Advising and Disabilities, Office: Sandefer Memorial, 1st floor
Academic Advising Center, Phone: 325-670-5867, Email: disabilityservices@hsutx.edu)
Peer-to-peer academic support (tutoring) is available for all undergraduate HSU
students. The Academic Center for Enrichment (ACE) is open for virtual tutoring
sessions via Zoom. To access instructions or make an appointment, open the ACE
course on your Canvas dashboard. For additional information regarding academic
support, contact the Advising Center at 325-670-1480 or tutoring@hsutx.edu.
In addition, all full or part-time students are eligible to receive free,
confidential, and voluntary counseling services at HSU. Services include
consultation, evaluation, counseling, and crisis support services for students
facing issues impacting their overall well-being. To obtain any of these
services, students may call The Office of Counseling Services at (325) 671-2272,
email counseling@hsutx.edu, or begin the intake process by completing our online
forms at:https://www.hsutx.edu/intake.
The instructor may occasionally use email to communicate with the class as a
whole or with individuals. When contacting you for this course the instructor
will use your HSU email account. You are expected to check your HSU email
account at least once per day and you will be held responsible for any content
distributed in this way.
Regarding class attendance, the Undergraduate Catalog states:
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.
Date |
Exam |
|
Wed 14 Feb |
Exam #1 |
|
Wed 03 Apr |
Exam #2 |
|
Wed 08 May |
Final Exam (at 1:00pm) |
|