CS360 Database Management

for F2QQ 2004

Printer Friendly

SYLLABUS Park University

COURSE DESCRIPTOR: Course descriptor relates to the fact the course is MGE
COURSE TITLE: Data Base Management
TITLE OF FACULTY MEMBER: Senior Instructor, Computer Science
FACULTY OFFICE LOCATION: Hill AFB, Utah, Bldg 383, Room 232
FACULTY OFFICE HOURS: Monday – Sunday evenings until 9:00 p.m.
FACULTY OFFICE TELEPHONE NUMBER: Home (801) 525-9841 (until 9:00 p.m.)
FACULTY PARK EMAIL ADDRESS: Robert.Hanrahan@pirate.park.edu
OTHER FACULTY EMAIL ADDRESS: HanrahanBobster@aol.com
DATES OF THE SEMESTER/TERM: October 25, 2004 – December 19, 2004
CLASS SESSIONS DAYS: Monday and Wednesday evening
CLASS SESSION TIME: 7:30 – 10:15 p.m.
PREREQUISITE (S): Prerequisite: a grade of "C" or better in CS219 3:0:3
The mission of Park University, an entrepreneurial institution of learning, is to provide access to academic excellence, which will prepare learners to think critically, communicate effectively and engage in lifelong learning while serving a global community.

Park University will be a renowned international leader in providing innovative educational opportunities for learners within the global society.

This course provides an overview of database system concepts. The course will deal with file organization methods, database models, data integrity and security, and database administration issues. The student will be introduced to application program development in a database environment with emphasis on setting up, modifying, and querying a database. Prerequisite: CIS 219. 3:0:3

My educational philosophy is one of interactiveness based on lectures, readings, dialogue, practical programming (keeping it “simple”), random quizzes, examinations, Internet, videos, web sites and writings. I will engage each learner in what is referred to as disputatious learning to encourage the lively exploration of ideas, freedom to explore the technology at hand (programming, software engineering, computer science etc.), and issues/contradictions with regard to programming style.

To provide the student with an understanding of the basic concepts and theory of data base management systems. The course will provide an introductory overview of data base management systems, describe traditional types of data base management systems and focus on the current Relational data base management system technology. The course will describe management issues as well as provide a foundation of technical knowledge designed to prepare the student for both further academic study and "real world" application. The student will be made aware of emerging database technologies such as the object-oriented paradigm and object database systems.

COURSE TEXTBOOK (S): Database Processing, Kroenke, Prentice Hall, 9th Edition, 2002 (ISBN: 0-13-101514-1)

ACADEMIC HONESTY: “Academic Honesty is required of all members of a learning community. Hence, Park will not tolerate cheating or plagiarism on tests, examinations, papers or other course assignments. Students who engage in such dishonesty may be given failing grades or expelled from Park.”

PLAGIARISM: Plagiarism—the appropriation or imitation of the language or ideas of another person and presenting them as one’s original work—sometimes occurs through carelessness or ignorance. Students who are uncertain about proper documentation of sources should consult their instructors.”

ATTENDANCE POLICY: Instructors are required to keep attendance records and report absences. The instructor may excuse absences for cogent reasons, but missed work must be made up within the term of enrollment. Work missed through unexcused absences must also be made up within the term of enrollment, but unexcused absences may carry further penalties. In the event of two consecutive weeks of unexcused absences in a term of enrollment, the student will be administratively withdrawn, resulting in a grade of “F”. An Incomplete will not be issued to a student who has unexcused or excessive absences recorded for a course. Students receiving Military Tuition Assistance (TA) or Veterans Administration (VA) educational benefits must not exceed three unexcused absences in the term of enrollment. Excessive absences will be reported to the appropriate agency and may result in a monetary penalty to the student. Reports of F grade (attendance or academic) resulting from excessive absence for students receiving financial assistance from agencies not mentioned above will be reported to the appropriate agency.

Roll will be checked each class meeting. Classes missed for legitimate reasons, such as temporary duty and illness, are excusable; however, the student must make up the missed work as follows: The instructor for both assignments and programs will provide new assignments. Temporary duty orders may be given to the instructor or turned in to the school office.

LATE SUBMISSION OF COURSE MATERIALS: Assignments turned in late will be assessed a 20% penalty for each class it is late.

Students are required to read all assigned material prior to class and be prepared to discuss the reading material and assignments. Participation in class discussion is required to obtain full value from the material under consideration. There will be mid term and final exams, pop quizzes, an application of moderate complexity (project), textbook homework assignments and points for class participation. Textbook homework assignments and computer-based assignments will be turned in no later than the first class of the week after an assignment is given (Monday and Wednesday assignments will be due on Monday of the following week).

Computers and Interactive Development Environments (IDEs) make programming and testing much easier and more productive. Students must recognize though that technology can also cause problems. Printers run out of ink and hard drive crash. Students must be responsible for planning ahead and meeting deadlines in spite of technology. Be sure to save copies of your work to disk, hard drive, and print out paper copies for backup purposes.

DISABILITY GUIDELINES: Park University is committed to meeting the needs of all students that meet the criteria for special assistance. These guidelines are designed to supply directions to students concerning the information necessary to accomplish this goal. It is Park University’s policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the American with Disabilities Act of 1990, regarding students with disabilities and, to the extent of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Additional information concerning Park University’s policies and procedures related to disability can be found on the Park University web page: www.park.edu/disability.

Date Chapter Topic Study Assignment

25 Oct 1 Introduction to Database Processing All Sections
27 Oct App A Data Structures for Database Processing All of the Appendix
2 The Entity-Relationship Data Modeling: Tools and Techniques All Sections

1 Nov 3 The Entity-Relationship Data Modeling: Process and Examples All Sections

3 Nov 4 The Relational Model and Normalization All Sections

8 Nov 5 Database Design All Sections

10 Nov 6 Introduction to Structured Query Language (SQL) All Sections

15 Nov 7 Using SQL in Applications All Sections

8 Database Redesign All Sections

22Nov 9 Managing Multi-User Databases All Sections

24 Nov 10 Managing Databases with Oracle 9i All Sections

29 Nov 11 Managing Databases with SQL Server 2000 All Sections

1 Dec Lab

6 Dec 12 ODBC, OLE DB, ADO, and ASP All Sections
13 XML and ADO.NET All Sections

8 Dec 14 JDBC, Java Server Pages, and MySQL All Sections
13 Dec 15 Sharing Enterprise Data All Sections
16 Object-Oriented Database Processing All Sections
****** Review for final examination ******

! *** Last Lab and all lab assignments to be turned in ***

The final course grade will be determined by the following measurements:
Textbook 10% 100 points
Computer 20% 200 points
* (Or both combined into an application design and development project)
Class Participation 5% (Survey, prepared/class participation) 50 points
Quizzes 5% (two 25 point “pop quizzes”) 50 points
Midterm Exam 25% 250 points
Final Exam 35% 350 points
The midterm exam will cover Chapters 1 through 7 and Appendix A and topics discussed in class.
The final exam will be cumulative and cover all the assigned textbook chapters, sections and related topics covered in class.
The course letter final grades will be determined by the following:
900 - 1000 A
800 - 899 B
700 - 799 C
600 - 699 D
Below 600 F (or four or more continuous inexcusable absences)
There will be no curve used in the grading nor will extra work be accepted for credit, except as previously described for participation credit for excused absences or participation credit for excused absences.