United States Naval Academy

Computer Science Department

IT360: Applied Database Systems (2-2-3) – Spring 2012

http://www.usna.edu/Users/cs/adina/teaching/it360/spring2012

 

 

Instructors:

Dr. Adina Crainiceanu, Phone x3-6822, MI362, adina@usna.edu

 

 

Course Description:

This course will introduce the principles underlying Database Management Systems (DBMS) with a special emphasis on database management system structure and function when integrated with web-based database applications.

 

Learning Objectives: 

Upon completing this course, students should be able to

1.      Explain the main advantages of modern database management systems over file systems.

2.      Design, create, and query relational databases to satisfy user requirements.

3.      Design, build and deploy database-backed applications with dynamic website front-end.

4.      Implement data access control mechanisms for database and application security.

5.      Analyze the ethical issues and responsibilities related to records management and its impact on privacy, discrimination, etc. and its local and global impact on society.

 

ABET Program Outcomes:

e. An understanding of ethical issues and responsibilities; (Supported by Learning Objective 5)

g. An ability to analyze the local and global impact of computing on society; (Supported by Learning Objective 5)

IT-j.  An ability to use and apply current technical concepts and practices in the core information technologies (Supported by Learning Objective 3)

IT-k. An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems (Supported by Learning Objective 2)

IT-l. An ability to effectively integrate IT-based solutions into the user environment (Supported by Learning Objective 2 and 4)

 

Textbooks:

Recommended: Database Processing 11/E: Kroenke & Auer, Prentice Hall 2010

Recommended: PHP and MySQL Web Development, Fourth Edition, L Welling and L Thomson, 2009

 

Prerequisites:

IC312 Data Structures

IT350 Web and Internet Programming

 

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%

25%

15%

Exam 2

 

35%

15%

Homework, Quizzes

10%

10%

9%

Labs

30%

30%

21%

Projects

 

17%

Final Exam

 

 

23%

 

Projects:

There will be one group project, with two major parts, assigned throughout the semester.  Project must be completed entirely by the students making the submission. The project grade will be based upon the instructor’s estimation of the group’s collective results, adjusted for each team member based upon the other group members’ estimation of the individual’s teamwork and contribution.

 

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. You can use your own written notes during the exams.

Use of any electronic devices is not permitted during the exams.

 

Quizzes:

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

 

Late Assignments:

Unless otherwise specified, all assignments are due electronically at 2359 on the due date, and paper copies before the beginning of class on the next day. Paper and electronic copies must exactly match. If there is no class on the next day, the assignments are due at 0800, under the instructor’s office door.

Late penalty: 10% first business day (rounded up), 25% second business day (rounded up), not accepted if more that 2 days late.

 

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 Programming Projects, COMPSCIDEPTINST 1531.1C

 

These references can be found at http://www.usna.edu/cs/documents/honor.htm

 

In particular:

1. You may collaborate on laboratory assignments to the following extent:  collaborative conversations with regard to syntax, strategies and methods for accomplishing the goal of the labs are encouraged; however design and implementation must be the work of the individual student handing in the final product (no line-by-line collaboration). Sharing or copying of any 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 or smokeless tobacco 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.

 

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                                                                                               Dr. Steve Miner 

Assistant Professor                                                                                                     Chair