Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Brunski, Katarina Z.


Tinker AFB, Midwest City, OK Summer 2005 <br>
COURSE SYMBOL AND NUMBER: CS360 <br>
COURSE TITLE: Database Management <br>
TERM COURSE BEING TAUGHT: Summer 2005 <br>
NAME OF FACULTY MEMBER: Katarina Z. Brunski <br>
TITLE OF FACULTY MEMBER: Contract Instructor <br>
FACULTY PARK EMAIL ADDRESS:katarina.brunski@park.edu <br>
DATES OF THE TERM: June 1 to July 27 2005 <br>
CLASS SESSIONS DAYS: Tuesday and Thursday <br>
CLASS SESSION TIME: 7:30 - 10:20pm <br>
PREREQUISITE: CS219 <br>
CREDIT HOURS: 3 <br>
<br>
MISSION STATEMENT <br>
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. <br>
<br>
VISION STATEMENT <br>
Park University will be a renowned international leader in providing innovative educational opportunities for learners within the global society. <br>
<br>
COURSE DESCRIPTION: 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 various aspects of data base design system, application development in a different type of database environment with emphasis in setting up, modifying, and querying a database. Prerequisite CS 219. 3:0:3 <br>
<br>
Course Textbook(s): Gerald V. Post, Data Base Management (third edition)<br>
ISBN: 0072973129<br>
<br>
Learning Objectives:<br>
This is an introductory course, the primary focus is to gain foundation concepts of database management, with intent to attain knowledge to develop business application database with the use of modern database design tools.<br>
Learning Objectives: <br>
Database management system concepts and architecture <br>
Data modeling <br>
Database logical and physical design <br>
Database lifecycle <br>
Database administration <br>
Relational database model and Entity Relational Diagrams, Object Oriented Approach and Unified Modeling Language will be covered <br>
Ability to explain and understand terms of business process modeling<br>
Understand and describe data base design and data base design related problems<br>
Illustrate data base examples, program code and data base operation<br>
Structured Query Language (SQL) <br>
Other topics in database management systems as appropriate <br>
<br>
<br>
<br>
<br>
<br>
Park University’s Policy <br>
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.” <br>
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.” <br>
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. <br>
LATE SUBMISSION OF COURSE MATERIALS: Late assignments will only be accepted in those special circumstances where class is missed for a legitimate reason at the discretion of the instructor. <br>
COURSE ASSESSMENT: You will be assigned chapters to read and study in the textbook. You will be expected to complete weekly written homework assignments and to participate in classroom discussions. You will also complete a project on Database design. (Group project) <br>
<br>
CLASSROOM RULES OF CONDUCT: <br>
<br>
Homework and Labs: Homework and labs must be done independently. You may collaborate with your classmates to exchange ideas and methods for going about such, but points will only be awarded for original work. Do not share your assignments and labs, as no points will be given for any works copied. Please refer to the student handbook for further explanations of academic honesty. <br>
<br>
Attendance: The student is expected to be present for all classes and for the full time period. A student may be excused prior to class for legitimate reasons such as previous work commitments where the student will be out of town on that day, scheduled surgery etc. For excused absences, the instructor must be informed prior to the day of the class that will be missed. Any absences that are not previously scheduled will be considered an unexcused absence. <br>
<br>
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 <br>
<br>
CLASS MEETING AND EXAMINATION SCHEDULE <br>
<br>
General Information :( instructor notes)<br>
<br>
<br>
Instructor will stay 30 minutes after every class to answer students questions if needed<br>
Instructor will try to organize a field trip based on the students interest<br>
There will be a group and individual take home project assignments on the subject covered. (Subject to change)<br>
Alternate information to reach instructor <br>
Instructor: Katarina Z. Brunski <br>
Phone 405-280-4316 (work) <br>
405-820-4127 (cell voice mail) <br>
email: kbrunski@cox.net (home) <br>
email: kbrunski@hertz.com (work) <br>
<br>
<br>
<br>
<br>
<br>
Class Schedule <br>
<br>
Week #1: <br>
Introduction, students knowledge assessment (one page autobiography on self background and knowledge on the subject). Course requirements: Lecture on Chapter 1 Component and Introduction to Database Management, Database Environment and History <br>
Review & lecture <br>
<br>
Week2: Lecture on Relational and Object Oriented Data Base Design <br>
<br>
Week 3: Data Normalization (i.e. Normalized tables, Data integrity what does it mean, Problems, Rules) <br>
<br>
Week 4: Overview of Data Queries (practice to write and run SQL queries) Midterm (subject to change) <br>
<br>
Week 5: Learn more advance SQL Queries and sub queries. <br>
<br>
Week 6: Overview of Forms, Reports, and Applications and Data Warehousing<br>
<br>
<br>
Week 7: Data base Administration (distributed databases, internet, and client server)<br>
<br>
Week 8 Course Review – go over any topics missed & presentation on the projects<br>
Note: problem exercises in class and homework assignment will be discussed in the first class<br>
final exam <br>
<br>
Grading Plan: <br>
<br>
There are multiple components in the grade. They are as follows: <br>
<br>
Class Participation and work assignments 20 % <br>
Individual an group Project assignments 40% ( subject to change)<br>
Midterm Exam 20% <br>
Final Exam 20% <br>
Extra exam will be discussed ( two of best to be used for grade) <br>
Note: Reading a chapter prior to class is greatly encouraged<br>
Attendance Policy <br>
Follow the Park’s guidelines <br>
Grading is as follows: A (90-100%), B (80-89%), C (70-79%), D (60-69%) and F (less then 60%)<br>
<br>