Course website : https://blogs.cofc.edu/olmsteda
Email: Please use firstname.lastname@example.org with Subject = CSIS672
Office: Harber Walk East CS 5
Office hours: MWF 9:00am – 10:00am
Class place and time
Thursday 6:00-8:45 PM
INFS 211 Database Security
This course covers database security and auditing. The focus is on the key components of information assurance as it relates to database systems – confidentiality, integrity, and availability, and how these components can be managed and measured. Prerequisite: DISC 210
- Understand the various database security models and their advantages or disadvantages
- Explain the various access control models and their advantages or disadvantages
- Understand the replication models used to increase availability and understand their advantages and disadvantages
- Understand common attacks used against database confidentiality and explain how to defend against the attack
- Use common integrity constraints to guarantee information correctness
I am assuming because you are in this class you want to learn about object-oriented
programming. Therefore, it is my job to use the 40 hour long classes and 80 hours of outside
work to get you there.
- SQL server 2008 administration : real world skills for MCITP certification and beyond / Tom Carpenter
- Pro MySQL / Michael Kruckenberg and Jay Pipes
- CompTIA Security+ 2008 in Depth
100-90 (A); 89-87 (A-); 86-84 (B+); 83-80 (B); 79-77 (B-); 76-74 (C+); 73-70 (C); 69-67 (C-); 66-60 (D); else (F)
50% – Assignments
30% – Tests
20% – Final Exam
Over the semester you will be given several assignments implementing security measured discussed in class. You will be required to demonstrate your understanding and implementation of these assignments
We will have 2 tests over the semester covering the material discussed in class and implemented in the assignments. Each test will be worth 20% of your final grade.
We will have a comprehensive final exam covering all material discussed in class over the semester.
Any student who feels he or she may need an accommodation based on the impact of a disability should contact me individually to discuss your specific needs. Also, please contact the College of Charleston, Center for disability Services http://www.cofc.edu/~cds/ for additional help.
Student Honor Code
I expect you to abide by the Honor Code and the Student Handbook: A Guide to Civil and Honorable Conduct. If you have a question about how to interpret the Honor Code, ask before acting! I encourage collaboration, but you must document it. Thus, each student will submit their own homework and, when collaborating, provide a reference to those people and documents consulted.
Attendance at regular classes is not mandatory, but is a great way to engage the course material and to ask questions. Attendance for tests and the exam is expected (rescheduling for sickness is accommodated). Please do not attend class if you are sick or believe you are becoming ill. It is best to document your absence through an absence report in Undergraduate Academic Services. ATTENDANCE WILL BE TAKEN AT ALL CLASS SESSIONS.
The use of electronic devices, both stand-alone and network capable, will play an increasingly important roll in teaching and learning at the College of Charleston, including their use in our classrooms. Just be respectful about unnecessary distractions to you and to others seated around you.
How to report an absence
Come to 67 George Street (white house next to Stern Center) to discuss absences and fill out the appropriate forms. Or get forms online at: http://www.cofc.edu/studentaffairs/general_info/absence Forms can be faxed to the College at 953-2290.
Students will need documentation for health, personal or emergency situations. Athletic Teams and school-sponsored trips will have documented lists of students participating on our letterhead as early in the semester as we get the information from the organization. We would like all information on scheduled outings to reach us at least two full weeks in advance. We will then turn the information back to the coach or advisor.
Lying, cheating, attempted cheating, and plagiarism are violations of our Honor Code that, when identified, are investigated. Each incident will be examined to determine the degree of deception involved.
Incidents where the instructor determines the student’s actions are related more to a misunderstanding will be handled by the instructor. A written intervention designed to help prevent the student from repeating the error will be given to the student. The intervention, submitted by form and signed both by the instructor and the student, will be forwarded to the Dean of Students and placed in the student’s file.
Cases of suspected academic dishonesty will be reported directly by the instructor and/or others having knowledge of the incident to the Dean of Students. A student found responsible by the Honor Board for academic dishonesty will receive a XF in the course, indicating failure of the course due to academic dishonesty. This grade will appear on the student’s transcript for two years after which the student may petition for the X to
be expunged. The student may also be placed on disciplinary probation, suspended (temporary removal) or expelled (permanent removal) from the College by the Honor Board.
Students should be aware that unauthorized collaboration–working together without permission– is a form of cheating. Unless the instructor specifies that students can work together on an assignment, quiz and/or test, no collaboration during the completion of the assignment is permitted. Other forms of cheating include possessing or using an unauthorized study aid (which could include accessing information via a cell phone or computer), copying from others’ exams, fabricating data, and giving unauthorized assistance.
Research conducted and/or papers written for other classes cannot be used in whole or in part for any assignment in this class without obtaining prior permission from the instructor. Students can find the complete Honor Code and all related processes in the Student Handbook at http://studentaffairs.cofc.edu/honor-system/studenthandbook/index.php