ClassInfo

CSC 451 Database Design for Information Systems (Formerly CSC 451)

Dolores Kalayta

Office: CDM 617
Winter 2012-2013
Class number: 24252
Section number: 802
W 5:45PM - 9:00PM
LEWIS 01110 Loop Campus

Summary

This course is an introduction to database systems from requirements analysis to implementation. Concepts we will cover include:

  • Introduction to Database Systems
  • The Entity-Relationship Model
  • Entity-Relationship Mapping
  • The Relational Database Model
  • Functional Dependencies and Normalization
  • SQL for Database Implementation
We will cover most chapters of Bagui and Earp's book.



Texts

Required Text:Database Design Using Entity-Relationship Diagrams, by Sikha Bagui and Richard Earp, 2nd Edition ISBN: 978-1-4398-6176-9

Suggested SQL Text: Not Required Practical Guide to Using SQL in Oracle, by Richard Walsh Earp and Sikha Bagui, 2nd edition, ISBN: 978-1-5982-2063-6
Available at DePaul Library 24 X 7 books. https://login.ezproxy1.lib.depaul.edu/login?qurl=http%3a%2f%2flibrary.books24x7.com%2flibrary.asp%3f%5eB ; Use Campus Connect Username/Password; do a search on the title.



Grading

There will be 7 - 8 assignments, a cumulative midterm and a cumulative final exam.

Assignments --40%
Midterm--30% tentative date: Feb. 13th
Final Exam -- 30% scheduled date: Mar. 20th

  • All assignment descriptions with complete instructions will be posted only on the course web pages on COL.
  • Each assignment will have a specific due date and time. Check the COL frequently for assignments and announcements.
  • Make sure you read the assignment description carefully, including the directions on how to submit the assignment. All assignment submissions will be done using COL.
  • Late submissions of assignments will not be accepted. The lowest assignment score will be dropped in the computation of your course grade.
  • Make-up examinations of any kind will not be given. If there is an extreme emergency you have to contact me before the examination takes place.
    The following grading scale is used:
    Grade Points Grade Points Grade Points Grade Points

    A

    100-93

    B+

    89-87

    C+

    79-77

    D+

    69-67

    A-

    92-90

    B

    86-83

    C

    76-73

    D

    66-60

    B-

    82-80

    C-

    72-70

    F

    59-0


Prerequisites

Graduate Standing


Tentative Week- by-Week Schedule



Week 1
Course overview, Introduction to Databases, Entity Relationship Data Model

Week 2
Entity Relationship Model - Part 1

Week 3
Entity Relationship Model - Part 2

Week 4
Enhanced Entity Relationship Model

Week 5
Relational Model ER Mapping

Week 6
Midterm;
Review of Mapping; Introduction of Normalization

Week 7
Normalization
Using SQL Developer

Week 8
SQL - DDL

Week 9
SQL - DML

Week 10
Review Design to Implmentation

Week 11
Final Exam - Cumulative

School policies:

Changes to Syllabus

This syllabus is subject to change as necessary during the quarter. If a change occurs, it will be thoroughly addressed during class, posted under Announcements in D2L and sent via email.

Online Course Evaluations

Evaluations are a way for students to provide valuable feedback regarding their instructor and the course. Detailed feedback will enable the instructor to continuously tailor teaching methods and course content to meet the learning goals of the course and the academic needs of the students. They are a requirement of the course and are key to continue to provide you with the highest quality of teaching. The evaluations are anonymous; the instructor and administration do not track who entered what responses. A program is used to check if the student completed the evaluations, but the evaluation is completely separate from the student’s identity. Since 100% participation is our goal, students are sent periodic reminders over three weeks. Students do not receive reminders once they complete the evaluation. Students complete the evaluation online in CampusConnect.

Academic Integrity and Plagiarism

This course will be subject to the university's academic integrity policy. More information can be found at http://academicintegrity.depaul.edu/ If you have any questions be sure to consult with your professor.

All students are expected to abide by the University's Academic Integrity Policy which prohibits cheating and other misconduct in student coursework. Publicly sharing or posting online any prior or current materials from this course (including exam questions or answers), is considered to be providing unauthorized assistance prohibited by the policy. Both students who share/post and students who access or use such materials are considered to be cheating under the Policy and will be subject to sanctions for violations of Academic Integrity.

Academic Policies

All students are required to manage their class schedules each term in accordance with the deadlines for enrolling and withdrawing as indicated in the University Academic Calendar. Information on enrollment, withdrawal, grading and incompletes can be found at http://www.cdm.depaul.edu/Current%20Students/Pages/PoliciesandProcedures.aspx.

Students with Disabilities

Students who feel they may need an accommodation based on the impact of a disability should contact the instructor privately to discuss their specific needs. All discussions will remain confidential.
To ensure that you receive the most appropriate accommodation based on your needs, contact the instructor as early as possible in the quarter (preferably within the first week of class), and make sure that you have contacted the Center for Students with Disabilities (CSD) at:
Lewis Center 1420, 25 East Jackson Blvd.
Phone number: (312)362-8002
Fax: (312)362-6544
TTY: (773)325.7296