Basic Course Info
Title: Data Base Management Systems
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
Course Outline: I will cover material in the order that I determine as the class progresses.
If you'd like to see how things were covered last year, please see the Fall 2005 online syllabus,
go to the calendar, change the year to 2005, and look at August thru December. Because of a redesign
of the textbook in edition 10 and other considerations based upon past class performance, however,
I plan to significantly modify the order and method of teaching this year to reflect these changes.
So, show up and hang on. The course will be taught with a very heavy lean toward using Oracle
(database design and writing SQL and PL/SQL) although Microsoft Access will also be used toward
the beginning as a simplified look at a relational database.
Policies (Grading, etc)
- These point allocations are just an estimate.
- Assignments, 350 points total (1,2,3: 50 each; 4,5: 100 each)
- 2 tests (100 and 200 points respectively), 300 points total
- Comprehensive final exam 300 points
- Pop quizzes between 10 - 20 points each.
- 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.
- 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%.
- Exemption policy: You will be individually notified if you are exempt from
the final exam. Exemption is awarded if you have taken all tests,
have earned a combined average of at least 90% on those tests,
and have turned all assignments in on time. Assignment points are not a part of the exemption calculation.
- 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 not tolerated, and is not worth the risk. I will treat you like a
computer professional, and I expect the same courtesy in return. Cheating is both a personal
and professional violation of that trust and respect.
"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."
lholder@utm.edu
(731) 881-7890 (Office of Information Technology Services)
102 Crisp Hall (Computer Center)
Work Hours: Monday thru Friday, 8 a.m. to 5 p.m.
Scheduling of appointments recommended.