CS360 Database Management

for F2B 2007

Mission Statement: 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.

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

McAfee Memorial Library- Online information, links, electronic databases and the Online catalog. Contact the library for further assistance via email or at 800-270-4347.

Park University Online Bookstore- Select "Distance Learning - Graduate," or "Distance Learning Internet," and then click on the appropriate course code (ex. AC 201, PA 501) to see the list of required and optional texts for each course that you are enrolled in.

Advising - Park University would like to assist you in achieving your educational goals. Your Campus Center Administrator can provide advising to you, please contact them for assistance. If you need contact information for your Campus Center, click here.

Online Tutoring Services- Park University has arranged for Online students to receive five hours of free access to Online tutoring and academic support through Smarthinking. If you would like Online tutoring, please contact me to receive their recommendation and information on how to access the Online tutoring.

Career Counseling- The Career Development Center (CDC) provides services for all stages of career development. The mission of the CDC is to provide the career planning tools to ensure a lifetime of career success.

Course Description: This course provides an overview of database system concepts. The course deals 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: CS 219. 3:0:3

Educational Philosophy:

I will do my best to present the material in an understandable and enjoyable manner. However, I cannot do the learning for you, so you must take personal responsibility for your education. Part of that responsibility involves respecting those around you and their right to learn. Outside conversation should be kept out of the classroom. Tardiness is also a disruption and should be avoided unless absolutely necessary.

Learning Outcomes:Core Learning Outcomes

Analyze the difference between Data and Database management (1, 2, 3)

Explain the duties of the data and database administrator. (41, 42, 45)

The core assessment for this course is a final exam which counts for 20% of the grade. Questions on the final exam will be developed to test at least eight of the eight course core objectives. Correspondence between core learning outcomes and the sample final exam artifact are as follows:

There will be daily quizzes starting the second class period. The quizzes will be worth 10% of your final grade and will cover material reviewed up to that point. There will be between 12 and 14 quizzes, but only 10 will count towards your final grade. I will use your top 10 grades. Since I treat the quizzes in this way, quizzes cannot be made-up for any reason. There will also be weekly assignments. These assignments will count for 60% of your final grade. There will be a final exam on the last day of class covering all material from the beginning. This exam will count for 20% of your final grade. Your participation in class, which also includes attendance and classroom behavior, will count for the remaining 10% of your final grade.

Grading:

Based on the above assessment, the grading scale is as follows: Grading Scale: The following grading scale will be used. A = 90% or higher, B = 80-89.9%, C = 70-79.9%, D = 60-69.9%, F = Below 60%. Extra credit will NOT be given to offset low scores or absences.

Late Submission of Course Materials:

Assignments should be turned in at the beginning of class. Late assignments must be approved by me. All absences must be made up by HANDING IN the completed assignment as soon as possible after the absence. Work must be shown that indicates how each answer was obtained, wherever possible. Failure to make up an absence results in a reduction of 1% of the final grade for each absence. If extenuating circumstances arise, please make them known to me so that I can work with you in your situation. Four (4) unexcused absences will force an "Academic Withdrawal" to occur. Only 1 "two-week" T.D.Y. will be allowed during the course. When you turn in an assignment, include your full name, the date, and the assignment number in the upper right corner. Concerning grading, I am human and I will make mistakes. You have until the next class period to return an assignment to me if you feel I graded it incorrectly. I will review the assignment and return points to you as needed. However, whether I have made a mistake or not, assignments cannot be returned for review after the next class period. I will be happy to review the issue, but no more points will be awarded. My late policy is as such: There will be an automatic 24-hour grace period after an assignment is due during which I will not deduct points. This grace period is useful if you have car trouble, get sick, or have any other situation that requires missing class. After this grace period, 10 points will be deducted for every day the assignment is late, including weekends. Assignments more than 11 days late will not be accepted.

Classroom Rules of Conduct: I expect you to conduct yourselves in a professional manner. You should respect both yourself and those around you. Outside conversation has no place during class time. There will be periodic breaks during the class. Any conversation with others not relating to the class should be kept to this time. I will not tolerate any rude comments, including discriminatory or sexual comments, and I will dismiss students from the class, if I feel it is necessary. I think a learning environment based on mutual respect is beneficial to everyone.

Course Topic/Dates/Assignments:

Assignments will be determined weekly based on class progress, and they will include book and programming assignments. Some assignments will be assigned as homework, and others will be completed in class. I try to make assignments that reflect what you have learned to that point, so while I do have an agenda and objectives, I will be flexible according to how the class is progressing. In addition, assignments will be posted on the Park eCompanion, so they will always be available for you to see.

Academic Honesty:Academic integrity is the foundation of the academic community. Because each student has the primary responsibility for being academically honest, students are advised to read and understand all sections of this policy relating to standards of conduct and academic life. Park University 2007-2008 Undergraduate Catalog Page 85-86One note: I encourage you to work with others to learn and understand the material better, but any work you submit must be wholly your own. If I suspect any students of cheating, I will address the issue with those students first, but I reserve the right to send the issue up for resolution.

Plagiarism:Plagiarism involves the use of quotations without quotation marks, the use of quotations without indication of the source, the use of another's idea without acknowledging the source, the submission of a paper, laboratory report, project, or class assignment (any portion of such) prepared by another person, or incorrect paraphrasing. Park University 2007-2008 Undergraduate Catalog Page 85

The instructor may excuse absences for valid reasons, but missed work must be made up within the semester/term of enrollment.

Work missed through unexcused absences must also be made up within the semester/term of enrollment.

Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.

In the event of two consecutive weeks of unexcused absences in a semester/term of enrollment, the student will be administratively withdrawn, resulting in a grade of "F".

A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.

Students receiving Military Tuition Assistance or Veterans Administration educational benefits must not exceed three unexcused absences in the semester/term of enrollment. Excessive absences will be reported to the appropriate agency and may result in a monetary penalty to the student.

Report of a "F" grade (attendance or academic) resulting from excessive absence for those students who are receiving financial assistance from agencies not mentioned in item 5 above will be reported to the appropriate agency.

Park University 2007-2008 Undergraduate Catalog Page 87-88Please contact me if you have an emergency or are expecting to be absent. I will not always be able to answer my phone depending on what time it is and where I am. I should be available by phone between the hours of 6 P.M. and 10:00 P.M. on Thursdays, Fridays, Saturdays, and Sundays. However, the best way to reach me is by email. I check my email regularly even when I am at work, so I can respond quicker in this manner. Please feel free to send me emails, but include CS 360 Database Management in the subject line. Please call me only if you have not been able to reach me any other way, or it is an emergency.

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 Americans with Disabilities Act of 1990, regarding students with disabilities. In the case 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: http://www.park.edu/disability .

The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is not demonstrated when less than 1 out of 3 questions are correctly answering regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases.

Synthesis Outcomes3,7

The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 10 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology

The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 7 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology

The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 5 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology

The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is not demonstrated when less than 5 out of 10 questions are correctly answered regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology

Analysis Outcomes1,6

The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 14 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management

The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 10 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management

The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management

The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is not demonstrated by correctly answering less than six 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management

The artifact demonstrates student ability to use principles as they relate to core course topics. Application is not demonstrated by correctly answering less than 7 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage

The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 8 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL

The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 6 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL

The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL

The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is not demonstrated by correctly answering less than 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL

Copyright:

This material is protected by copyright and can not be reused without author permission.