Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Etherton, Garrie Ray


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.

Course

CS 360 Database Management

Semester

S1G 2006 GR

Faculty

Etherton, Garrie Ray

Title

Instuctor

Degrees/Certificates

BS M/CIS Park University
MS Information Technology

Daytime Phone

701-77705297

E-Mail

garrie.etherton@priate.park.edu

garrie_etherton@und.nodak.edu

getherton@undeerc.org

Semester Dates

9 Jan 06 – 5 Mar 06

Class Days

-----F-

Class Time

5:00 - 6:30 PM

Credit Hours

3


Textbook:
Title Edition   Author     Publisher ISBN
Database   3       Gerald V. Post  McGraw-Hill  007297129
Management
Systems      


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

Learning Outcomes:
  Core Learning Outcomes

  1. Describe a relational database and object-oriented database.
  2. Describe components of a database management system and the techniques used to store and access data within the DBMS.
  3. Utilize modeling software to build a database design.
  4. Describe normalization and perform normalization of a database model.
  5. Demonstrate the basic fundamentals of Structured Query Language (SQL).
  6. Use SQL to create the tables within a database and queries for updating tables.
  7. Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
  8. Describe the duties of the database administrator.
  9. Describe the creation and use of metadata and data dictionaries.
  10. Examine issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.
  11. Explain the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.
  12. Describe the role of web-enabling databases.


Class Assessment:
Project:

Each student is required to create a database.  The general idea is for the student to come up with something he/she as an individual would like to do.  You will be required to create the database, load sufficient test data to demonstrate its capability, and to write a description of your database.  You should plan on spending 10-20 hours outside of class planning and implementing your project.

Assignments:


Week 1 Chapters 1 & 2
Week 2 Chapters 3 & 4
Week 3 Chapter 5
Week 4 Mid Term
Week 5 Chapter 6
Week 6 Chapter 7
Week 7 Chapter 8
Week 8 Chapter 9 and Final project



Project:

Each student is required to create a database.  The general idea is for the student to come up with something he/she as an individual would like to do.  You will be required to create the database, load sufficient test data to demonstrate its capability, and to write a description of your database.  You should plan on spending 10-20 hours outside of class planning and implementing your project.

Assignments:


Week 1 Chapters 1 & 2
Week 2 Chapters 3 & 4
Week 3 Chapter 5
Week 4 Mid Term
Week 5 Chapter 6
Week 6 Chapter 7
Week 7 Chapter 8
Week 8 Chapter 9 and Final project











Late Submission of Course Materials:
B. Late and early work policy

We are going to be covering a lot of material in a very short period of time.  It's very important not to fall behind.

Most assignments are due by the date and time specified.  Exceptions will be announced.

I understand there are unavoidable circumstances, which prevent students from turning in their assignments on time.  However, it's not fair for those who met the assignment due dates not to penalize those that are late.  Therefore, points may be deducted from your grades for late submission.

Turned in Percentage of points deducted
1 day late 10 %
2 days late 15 %
3 days late 25 %
4 or more days late Not accepted without prior arrangements

If you know you can't make a deadline, please contact me so we can discuss it.  You must notify me no later than 48 hours prior to the deadline of any circumstances that may result in a delay of your work submission.

If I don't hear from you prior to the deadline, points will be automatically deducted.  Please don't attempt to argue this with me.  Only a letter from the University will waive point deductions.


You can turn in your work prior to the due date.  However, I will not grade early work until the due date.

I urge you not to submit work too far ahead.  Often times, questions arise about a particular assignment in class discussions and lectures.  I do my best to clarify them.  If your work is already turned in, you may not benefit from these discussions

Classroom Rules of Conduct:
Potential Computer Problems

Hard drive crashes are not uncommon.  Be prepared of computer problems.  Remember “Murphy's Law” will become factual someday be prepared.

Students are strongly urged to back up their data regularly.  I know that this is sometimes a hard concept to grasps but from experience it's a necessity.  Programmers are notorious for stating, “make backups” but not abiding by their own advise.   For everyone's sake /peace of mind please ” Do as I say and not as I do”. Sooner or later “Murphy's Law” will get you, voice of experience so be prepared.

If a group assignment is given, all students should have a copy of the work.

Have a contingency plan ready in the event your PC becomes inoperable for several days.  Make arrangements with work or your neighbors to use their computers.  Check with your local library or Kinko's for Pc availability and potential charges.

Expectations for Class Participation

Active classroom participation is encouraged.  Striking up dialogs and building relationships with one another is invaluable to your education process.

To maximize your learning experience and time, these ground rules must be followed during class times.

? Please be punctual.
? Don't interrupt your fellow students or me with sideline/personal chat.
? Your welcome to answer any questions posed by your classmates.
? Please don't use class time to discuss issues that don't impact other students.  Call or email me those types of issues.
? The basic agenda for class will be:
o Questions regarding prior material or Learning Event
o Questions for current material or Learning Event
o Several key concepts for current material
o Open forum for any questions

Communication / Conduct

I believe in open and honest frequent communications.

I welcome your suggestions and constructive criticisms.

Please accept my suggestions and constructive criticisms

Each of you comes to this class with different experiences and expectations.  Through my academic endeavors, I've found that students represent the full spectrum of experience levels.  Some are already experts and some are just starting out.  As you can imagine it's impossible to tailor a class to meet everyone's expectation.  Please keep that in mind throughout the session.  The following is true, “in any educational environment some may feel under challenged and some will be overwhelmed. “

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 .

Additional Information:

A.     Contact Information

 

The success of this program and this course depends on clear, effective and open communication.

 

I make a strong attempt to reply to all emails within 24 hours.  In the rare occasion I am away from my system for more than 48 hours, I will notify you via email if possible and Park University in advance.

 

Of course, we can always schedule a time for us to talk on the telephone.  Lets try to plan on scheduling such a time via use of email or pre arranged phone conversations.

 

Copyright:

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