Csci 309
Database Management Systems
Course description: Data base fundamentals, data base modeling, data base evaluation and processing, data base implementation and management using appropriate software tools.
Prerequisites: Csci 308, Csci 284, or permission of department head.
Text: Database Systems Design, Implementation, and Management, by Peter Rob and Carlos Coronel, 7th edition, Course Technology, 2007.
Objectives
The student will demonstrate an understanding of:
- database concepts;
- database design;
- database implementation.
Course material
The instructor reserves the right to change the order and time spent on any portion of this syllabus.
Course material may include the following topics:
| Topics | Approx. time | Chapter |
|---|---|---|
| Database systems | ~ 1 week | Ch. 1 |
| Data models | ~ 1 week | Ch. 2 |
| Relational database model | ~ 1.5 weeks | Ch. 3 |
| Entity relationship modeling | ~ 1.5 weeks | Ch. 4 |
| Normalization of database tables | ~ 1 week | Ch. 5 |
| Introduction to SQL | ~ 2 weeks | Ch. 7 |
| Database design | ~ 1 week | Ch. 9 |
| Transaction management and concurrency control | ~ 2 weeks | Ch. 10 |
| Distributed database management systems | ~ 2 weeks | Ch. 12 |
| Exams | ~ 1 week |
Other topics as time permits.
Assessment
The Semester score for the course will be calculated by using the weights (%) indicated below:
| Weight (%) | |||
|---|---|---|---|
| 75% | Semester average | Tests | ______ % |
| Assignments | ______ % | ||
| _________ | ______ % | ||
| 25% | Final exam grade |
The Semester letter grade in the course will be assigned according to the scale below:
| Semester grade | Semester score |
|---|---|
| 90–100 | A |
| 80–89 | B |
| 70–79 | C |
| 60–69 | D |
| 0–59 | F |
Notes:
- In cases of an excused absence, the instructor reserves the right to reweight the final exam in lieu of a make-up test.
- In the case where a student's score on his final exam indicates exceptional achievement above and beyond that indicated by the semester average, the instructor reserves the right to reweight the value of the final exam in computing the semester grade.
Please read the Department's Attendance Policy.
Instructor's office hours
can be found on the MSU web site at
http://www.faculty.mcneese.edu
Click on individual instructor to view their web page.
Or navigate from MSU Home Page; select Faculty & Staff, select Faculty Web Server.
Students should visit the MSU web page at
http://www.mcneese.edu/policy/diversity.htm
for information about diversity awareness and sexual harassment policies and
procedures, as well as the Americans with Disabilities Act.
Students should also visit the MSU web page at
http://www.mcneese.edu/integrity
for information on the Academic Integrity Policy.
ANY STUDENT WITH A DISABILITY IS ENCOURAGED TO CONTACT THE OFFICE OF SERVICES FOR STUDENTS WITH DISABILITIES IN DREW HALL, ROOM 200, VOICE (337) 475-5916, HEARING IMPAIRED (337) 475-5722. IT IS EACH STUDENT'S RESPONSIBILITY TO REGISTER WITH THE OFFICE OF SERVICES FOR STUDENTS WITH DISABILITIES WHEN REQUESTING A REASONABLE ACCOMMODATION.
One week of summer school is equivalent to 2 ½ weeks of Fall or Spring classes
DMCS
Location:
Kirkman Hall, Beauregard Drive
Mail:
Box 92340, MSU, Lake Charles, LA 70609
Phone:
(337) 475–5788,
Fax:
(337) 475–5799
e-Mail:
sbradley@mcneese.edu
