ClassInfo

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

David Calascibetta

Fall 2017-2018
Class number: 12222
Section number: 710
-
Online Campus
Course homepage: http://d2l.depaul.edu

Summary

Requirement analysis, conceptual design, logical design and physical implementation of relational databases. Emphasis will be on E-R modeling and E-R mapping, along with basic normalization and SQL for database implementation.

The class project includes the design of a complete database structure and its implementation. The Oracle DBMS will be used for the class project and assignments; we will use Oracle's SQL Developer 4 for assignments.



Texts

"Database Design using Entity-Relationship Diagrams," Second Edition, by Sikha Bagui and Richard Earp, Auerbach Publications, 2011. ISBN-10: 1439861765, ISBN-13: 978-1439861769

Reference (not required):
"Fundamentals of Database Systems", 6th edition, by Elmasri & Navathe, Addison-Wesley, 2010. ISBN-10: 0136086209, ISBN-13: 978-0136086208



Grading

Homework      30%
Project       10%
Midterm       30%
Final         30%
 
10% off for each week homework is late.


Prerequisites

Graduate Standing



Learning Outcomes

At the end of this class, students will be able to:
  • Analyze business requirements for a new database
  • Develop a logical model using Entity-Relationship Diagrams
  • Develop a physical model for implementation in Oracle
  • Execute SQL queries against the database


  • Other

    This is a lecture-based class. We will use D2L for course management. The midterm and final exams are proctored. Non-local, online students are required to retain a proctor.


    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