Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Rejai, Barry


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.
CourseCS 360 Database Management DN
SemesterF1J2005
FacultyRejai, Barry
TitleAdjunct Faculty
Degrees/CertificatesBachelors in Computer Science
Masters in Computer Science
Daytime Phone913-762-8499
Other Phone913-485-6207
E-Mailb.rejai@park.edu
barry.rejai@mail.sprint.com
Web Pagehttp://parkonline.org/
Semester Dates8/24/2005 through 10/12/2005
Class Days---W---
Class Time5:30 - 9:50 PM
PerquisitesCS219
Credit Hours3

Textbook:
Database Systems: Design, Implementation, and Management, Sixth Edition, Rob/Coronel.  Course Technology.  ISBN: 0-619-21323-X

Additional Resources:
A Guide to SQL, Seventh Edition, Pratt.  Course Technology.  ISBN: 0-619-21674-3

http://www.course.com

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:  CS219. 3:0:3

Educational Philosophy:
Class attendance and participation is required. Teaching techniques will include lectures, class discussions, textbooks, reference materials, group exercises, etc. You are in an accelerated educational program which means you must be willing and committed to learning a lot of material in a short amount of time.

Learning Outcomes:

This is an introductory course primarily covering the foundation concepts of database management.  This course imparts knowledge and skills required for a foundation in current Relational Database Management Systems (RDBMS).  

Core Learning Objectives:

•database management system concepts and architecture
•relational database model and relational algebra
•data modeling (ERD)
•database logical and physical design concepts  
•database normalization
•database lifecycle
•Structured Query Language (SQL)
•Client/Server computing principals
•database administration  

Course Assessment:
There will be six tests plus a project.  Your final grade will be calculated as the average of all tests and the project.  No makeup tests. No incomplete grades.

Grading:
Your final grade will be calculated as the average of all tests plus the project.

Final Grade % = (Test1+Test2+Test3+Test4+Test5+Test6+Project)/7

A = 90%-100%
B = 80%-89%
C = 70%-79%
D = 60%-69%
F = less than 60%

Late Submission of Course Materials:
Late submissions of assignments will not be accepted.

Course Topic/Dates/Assignments:
CS360 Course Outline by Week:
   

 Class ActivitiesRequired StudyingTests
Week - 1Explain Course Logistics, Round-table Intro, File Systems and Evolution of databases, DBMS functions.Ch. 1 & Ch. 2-
Week - 2The Relational Database Concepts, Relational Tables, Keys, Relational Operators, Data Dictionary and basic entity relationships. Ch. 3TEST #1
Week - 3ER Modeling, ER Diagram Components, Data Modeling Skills, Case Studies and Group Exercises. Ch. 4TEST #2
Week - 4Normalization of Database Tables, Good and Poor Table Structures, Normalization Techniques. Database Life Cycle (DBLC), Systems Development Life Cycle (SDLC).Ch. 5 & Ch. 8TEST #3
Project START
Week - 5The University Lab Conceptual Design, Logical Design, and Implementation. Case studies, group exercises and real world projects.Appendix D & Appendix ETEST #4
Week - 6Structured Query Language (SQL) – Lecture & Lab
DDLs and DMLs. The basic commands and functions of SQL.
A Guide to SQL book will also be used to learn basic SQL programming.
Ch. 6 & Ch. 7-
Week - 7Structured Query Language (SQL) – Lecture & Lab
A Guide to SQL book will also be used to learn basic SQL programming.
Ch. 6 & Ch. 7TEST #5
Week - 8Basic Client/Server Computing principals and components.  Data as Corporate Asset, Roles of DA and DBA.Appendix F & Ch. 15TEST #6
Project DUE

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 2005-2006 Undergraduate Catalog
Page 85-87

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 2005-2006 Undergraduate Catalog
Page 85-87

Attendance Policy:
Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.

  1. The instructor may excuse absences for valid reasons, but missed work must be made up within the semester/term of enrollment.
  2. Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.
  3. 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 "WH".
  4. A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.
  5. 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.
  6. 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 2005-2006 Undergraduate Catalog Page 89

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. Park University is committed to meeting the needs of all learners that meet the criteria for special assistance. These guidelines are designed to supply directions to learners 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 learners 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:
http://www.park.edu/disability
 
.

Copyright:
This material is copyright and can not be reused without author permission.