redchecks.gif (1881 bytes)

Database Management & Design Course Syllabus

| Home |

redchecks.gif (1881 bytes)

COURSE INFORMATION METHODS OF INSTRUCTION
COURSE DESCRIPTION COURSE REQUIREMENTS
COURSE OBJECTIVES ASSESSMENT OF STUDENT LEARNING

COURSE INFORMATION:uptotop

COURSE NAME: CIS 295 Database Management & Design CREDIT(S): 3 semester hours

INSTRUCTORS: Sally Tilstra 

OFFICE:  STI Technology Center - Room 202
e-ADDRESS: sally.tilstra@southeasttech.com   madhack.gif (7546 bytes)
PHONE: (605)367-5561

TEXT(S): Database Processing David M. Kroenke, Ninth Edition

SOFTWARE: Microsoft ACCESS, MS SQL Server, ER Modeling software (Visio)

COMPANION WEBSITE:  www.prenhall.com/kroenke

COURSE DESCRIPTION: uptotop

The course begins with a review of relational database concepts.   Database design and modeling is introduced, primarily using entity relationship diagrams. Normalization is covered early in the course. Implementation of the model to build relational databases is practiced using available software (such as Microsoft Access, SQL Server, and/or Oracle) to demonstrate features of SQL.   The course concludes with an overview of database access standards and enterprise database processing.

COURSE OBJECTIVES:  uptotop

Upon successful completion of this course, the student shall be able to

  1. Define and utilize database terminology effectively.
  2. Create queries using SQL.
  3. Diagram users' requirements using modeling techniques.
  4. Transform data models into normalized relations.
  5. Explain the complexities of sharing enterprise data.
  6. Describe database access standards.
  7. Apply the design & implementation phase of database development to a project situation.

METHODS OF INSTRUCTION: uptotop

COURSE REQUIREMENTS:uptotop

Schedule: 2 hours lecture per week Lab Time: 2 hours instructor-supervised lab per week

Attendance: Attendance is strongly encouraged and the student should not miss more than 3 classes per term.

Prerequisites: Course in microcomputer relational database software (ie Access) or CIS 295 instructor consent.

Test Makeups and Retakes: If a student is absent on the day of an exam, the student will need to take the exam within 1 week of the exam date. Test retakes may be considered by the instructor, and arranged on an individual basis. Test retakes are averaged with the original exam score.

Late Assignments: Students shall demonstrate responsibility and commitment to learning by submitting all assignments on or before the designated due date and by attending all scheduled classes. Up to 10% of the points may be deducted from late assignments. Some late assignments may not be accepted, as decided by the instructor.

Unethical Behavior: Cheating or plagiarism may result in at the very least a zero for that work for all parties involved. Repeated cheating will be reported to Student Services for follow-up actions. (See student handbook)
Examples of cheating, but not limited to just these:
 * using email or the network to pass files with answers or code to another student, which is much more than 'working together'
* cutting and pasting code or answers written by someone else into a document then passing it off as your own work
* taking code from libraries or folders with or without permission of another
* retrieving code printouts from the waste basket and using it as your own
* downloading code from another student
* using instant messaging during an exam or quiz or performance test
* extensive collaboration - if in doubt, check with the instructor
Computer privileges may be modified or discontinued if they are abused. See STI Student Handbook for current policies.

ASSESSMENT OF STUDENT LEARNING:uptotop

Exams & Quizzes (60% of grade) Exams will be given after major topics. Quizzes may be given unannounced. Test questions may consist of coding, multiple choice, true/false, fill-in-the-blank, logic questions, definitions, short answer, completion, and matching. Some tests may be performance-based.

Labs/Database Projects (20% of grade) Lab problems may be individual or team learning exercises, which may involve presentations. Group and individual grades are combined to balance independent work as well as team-oriented exercises.

Misc. Assignments (20% of grade) Review questions or exercises, written reports, worksheets, attendance, class participation.
A+ 99-100% B+ 89% C+ 79% D + 69% F = 59% and Below
A 94-98% B 84-88% C 74-78% D 64-68%  
A- 90-93% B- 80-83% C- 70-73% D- 60-63%  

The instructors and the faculty members in this course will act with integrity and strive to engage in equitable verbal and nonverbal behavior with respect to differences arising from age, gender, race, handicapping conditions and religion. If you have special needs as addressed by the American with Disabilities Act and need course materials in alternative formats, notify your instructor immediately. Reasonable efforts will be made to accommodate your special needs

Violations of safety to self and others and/or violation of safe operating practices of equipment may result in: the reduction or loss of your daily grade; removal from class; and/or other disciplinary action.


| Back to Top | Home |

Revised August 8, 2003 by Sally Tilstra