Announcements

• The 10th edition of the textbook (ISBN 0-13-167267-3) will again be used for Fall 2009.

Basic Course Info

Description: Fundamentals of data base processing. Network, hierarchical, and relational data bases. Comparison of data base systems. Data base implementation.

Prereq: CSCI 222 or CSCI 250

Textbooks and Materials: "Database Processing - Fundamentals, Design, & Implementation" by David M. Kroenke, 10th edition, Prentice Hall, ISBN 0-13-167267-3.

General Course Objectives, Student Outcomes: Students should gain an understanding and appreciation of the modeling, design, development, operation, maintenance, and management of databases.

Specific Course Objectives:

• Learn the role of databases and database applications in contemporary organizations
• Learn and practice data modeling using the entity-relationship and semantic object models
• Learn and practice developing database designs
• Understand the use of SQL and learn SQL syntax
• Learn emerging Internet technology that is relevant to database processing including the use of XML, ASP scripting, and OLE DB
• Understand the special needs of multi-user database processing and learn techniques for controlling the consequences of concurrent data access
• Learn the need for both database administration and data administration
• Understand the issues involved in enterprise data sharing and learn the nature of data warehouses
• Learn the features and functions of OLAP and understand its relationship to database processing
• Understand the need for object database management and learn the basics of the SQL3 and ODMG standards

• 6 Assignments, 550 points total:
  • Assignment 1 - 50 points (SQL queries at end of chapter 2, MDC)
  • Assignment 2 - 50 points (assignment at end of chapter 3, MDC)
  • Assignment 3 - 50 points (tables and relationships of Airport in Access)
  • Assignment 4 - 100 points (create pre-written user, load tables, export schema in Oracle)
  • Assignment 5 - 150 points (create and populate airport schema in Oracle)
  • Assignment 6 - 150 points (itinerary and other query in Oracle)
• 2 tests, 200 each, 400 points total
• Comprehensive final exam 400 points
• Pop quizzes between 10 - 25 points each.
• Total possible points is 1,350 plus quizzes.

• Compute total points awarded, divided by the total points possible, then use scale: 90%=A, 80%=B, 70%=C, 60%=D, 59% and below=F.

• Exemption policy: You will be individually notified if you are exempt from the final exam. Exemption from final exam requires taking all tests and earning at least an 87% combined average on them, plus satisfactory attendance, plus all assignments turned in on time. Assignment points are not a part of the exemption calculation. Instructor determines "satisfactory attendance".

• Low Test Replacement: If you earned less than 80% of the total possible on your lowest test (but not less than 10% of the total possible for that test prior to any points "given back" on that test), then if the percentage awarded on the final exam is more than the percentage awarded on that test, the final exam percentage will replace that test percentage, up to a cap of 80%.

• Assignments are due by either the beginning of class, or 5.p.m., on the due date, as specified by the instructor. An assignment not turned by the date and time due as a result of an excused absence will be accepted at the class meeting immediately following the excused absence. Late assignments may not accepted, or may be accepted with points deducted for lateness.

• Attendance: Roll will be taken periodically. While there is no specific deduction of points for absences, regular attendance is encouraged. Tests, quizzes, and exams missed without excuse yeild zero. Acceptance of excused absence is at my sole disgression. Clearance beforehand is best, although medical and family emergencies may be explained afterwards. Athletes, etc, should provide documentation of activities that will require them to miss class, which should be prepared by their coach, etc, on official letterhead. If a test is missed with an excused absence, please check with me as to whether a make-up test will be arranged or the final exam will be used as a proportional make-up instead.

• Cheating is both a personal and professional violation of trust and respect. I will treat you like a computer professional, and I expect the same courtesy in return.

"Any student eligible for and requesting academic accommodations due to a disability is requested to provide a letter of accommodation from P.A.C.E. or Student Academic Support Center within the first two weeks of the semester."