United States Naval Academy

Computer Science Department

SI440: Database Systems (3-0-3) – Fall 2007

http://www.usna.edu/Users/cs/adina/teaching/si440/fall2007

 

 

Instructor: Dr. Adina Crăiniceanu, Phone 3-6822, MI362, adina@usna.edu

 

Course Description:

This course offers an introduction to modern database management systems. Concepts covered include relational model, schema design, SQL, query optimization, concurrency control, and recovery. The course focuses on the design and internals of the modern database systems. 

 

Learning Objectives: 

Upon completing this course, students should be able to

  1. Query relational databases using SQL;
  2. Design, and create relational databases to satisfy user requirements;
  3. Build parts of a real database management system;
  4. Explain the main functionality provided by modern database management systems: query optimization, concurrency control, crash recovery;
  5. Analyze the ethical issues and responsibilities related to records management.

ABET Program Outcomes:

4. Apply the basic principles of requirements gathering, specification, design, implementation, and testing to solve problems and make effective use of the foundational core. (Supported by Learning Objectives 1, 2, 3)

7. Can communicate effectively orally, in writing, and via multimedia in both a technical and non-technical manner. (Supported by Learning Objective 2)

8. Can collaborate effectively in a team environment. (Supported by Learning Objective 2 or 3)

9. Evaluate contemporary legal, social, and ethical issues in computing professions. (Supported by Learning Objective 5)

 

Textbooks:

Required: Database Management Systems, 3rd Edition, Raghu Ramakrishnan and Johannes Gehrke, McGraw Hill, 2003

 

Prerequisites:

SI321 Advanced Data Structures, strong programming skills (C++)

 

Extra Instruction (EI):

EI is available and encouraged. Since this course continually builds upon material previously presented, it is crucial that you seek EI as soon as you have problems understanding the material. However, you must come prepared with specific questions or areas to be discussed (i.e. have read the assigned readings). If you have missed class, get the notes from a classmate. Do not ask or expect to receive EI on material that you have slept through.

 

Grading:

 

6-Week

12-Week

Final

Exam 1

60%

20%

15%

Exam 2

 

40%

15%

Homework, Labs, Quizzes

40%

25%

20%

Projects

 

15%

25%

Final Exam

 

 

25%

 

Projects:

There will be one or two group projects assigned throughout the semester.  Projects must be completed entirely by the students making the submission.

 

Exams:

The 6 and 12-week exams will primarily focus on the recent material. The final exam will be comprehensive. If for some reason a make-up exam will be required, inform the instructor at least 1 week in advance.

All exams will be closed books/ open notes. Use of any electronic devices is not permitted during the exam.

 

Quizzes:

Expect frequent quizzes. Quizzes may be open or closed book/notes, as announced. No makeup quizzes will be given.

 

Late Assignments:

Unless otherwise specified, all assignments are due before the beginning of class on the due date. If there is no class on the due day, the assignments are due at 0800, under the instructor’s office door.

Late penalty: 3n %, where n is the number of business days late. 

Re-grade requests have to be submitted to the instructor at most 7 days after the assignment was graded.

 

Honor:

You are expected to follow the guidance given in:

  • Honor Concept of the Brigade of Midshipmen, USNAINST 1610.3F
  • Policies Concerning Graded Academic Work, USNAINST 1531.53
  • Policy Concerning Graded Academic Work, COMPSCIDEPTINST 1531.1C

 

These references can be found at http://www.usna.edu/CS/academics/honor.htm.

 

In particular:

1. You may collaborate on homework assignments, but you need to write your own solution. Sharing or copying of any submitted /to be submitted work is never permitted. We reserve the right to divide the grade between any students who violate this policy.  In addition, you must identify all those that you collaborate with on your assignment cover sheet.  Consult your instructor if you need further clarification.

2. All work on exams/quizzes must be your own.

3. All work on the projects must be the work of the students in the team making the submission.

 

Classroom Decorum:

1.        No food is permitted in the classroom or in the labs. Drinks with closeable caps are permitted.

2.        Sleeping is not allowed in class. If you feel you may fall asleep at your desk, stand in the back of the room.

3.        No use of computer equipment for any purpose other than as outlined in the class activity will be tolerated, i.e. reading e-mail, playing games, or IMing classmates.  These actions will subject the abuser to immediate dismissal from class to report to their Company Officer.

 

Section Leader:

A section leader and an alternate section leader will be designated by the instructor. The duties of the section leader include:

    • calling the section to attention at the beginning and end of class
    • reporting absences to the instructor
    • contacting the department office (3-6800, Room 346) if the instructor is more than 10 minutes late for class
    • directing the class in productive work if the instructor is absent. The section leader is not authorized to cancel class, even if the instructor is absent.

 

Miscellaneous:

1.        Reading assignments are expected to be completed prior to class for which it is assigned.  Practical exercises will expand on concepts introduced in these readings. 

2.        Please inform the instructor in advance if you will miss class (for instance, due to a movement order).

 

Submitted by:                                                                                                                       Approved by:

 

__________________                                                                                                      __________________                     

Dr. Adina Crainiceanu                                                                                                         CAPT Thomas Logue, USN              

Assistant Professor,                                                                                                            Chairman,

Computer Science Department                                                                                          Computer Science Department