CSC 451 Database Design for Information Systems (Formerly CSC 451)
Summary
This course serves as a general introduction to database systems for database designers; we will discuss the full database system life cycle but will focus on data modeling and database design. Specific topics to be covered include:
* Introduction to Database Systems
* The Entity-Relationship Model
* Entity-Relationship Mapping
* The Relational Model
* Functional Dependencies and Normalization
* SQL for Database Implementation
We will cover most chapters of Bagui and Earp's book.
Texts
Database Design using Entity-Relationship Diagrams, Second Edition, by Sikha Bagui and Richard Earp, ISBN 1439861765 or 978-1439861769.
Grading
There will be homework assignments given most weeks; assignments (with associated readings) will be posted on the course web site and will be due one week after the day they are posted, unless otherwise noted. Details of the submission process will be discussed in class; it is your responsibility to verify that your submitted files are readable and submitted in the correct locations. Grades and comments will be returned through the course web site. Late assignments will be accepted up to three days late with a 10% penalty for each day or fraction of a day that the assignment is late; these penalties will be assessed uniformly and in full to all assignments submitted at any point beyond the posted due date and time (including those submitted or re-submitted later the same day). No assignments will be accepted more than three days beyond the posted due date and time. These deadlines will be strictly enforced, but I will drop the lowest-grade homework when computing your final grade for the course. The homework assignments will be worth a total of 40% of the course grade. There will be a midterm exam that will be worth 30% of the course grade. There will be a final exam that will be worth 30% of the course grade. (I will contact Online Learning students by email regarding exam scheduling and procedures.) If you do not take both the midterm and final exams, you will automatically receive a grade of F for the course. Furthermore, everyone must take the midterm and final exams at the scheduled times - as a rule, no make-up exams will be given. If you wish to petition for a make-up exam in an emergency situation, you must contact me in advance and provide written documentation of the emergency.
Prerequisites
There are no prerequisites for this course
Regarding Email Communication
Please begin the subject line of any email to me with "CSC 451", so that I can easily identify your messages. I will reply to email messages within one business day after the day I receive them; therefore questions that are only received by me on an assignment?s due date (or late the night before) are not guaranteed replies before the assignment is due. Please plan accordingly and begin the assignments early enough to ask questions and receive answers. If you are having problems, send me a detailed description of the problems you are having; I will try to guide you in locating and solving your problems yourself, rather than simply solve your problems for you. Please do not use the comment field of the assignment submission system to send me questions.
Week 1:
Introduction to Databases, E-R Model
- General database intro
- Intro, entities, attributes, relationships, business rules
- (Assignment 1: Analysis of E-R diagram and Visio walk-through)
Week 2:
E-R Modeling
- Entities, attributes, representations
- Relationships, cardinality, participation, representations, notations
- E-R modeling, identifying entities, attributes, relationships
- Unary and n-ary relationships
- (Assignment 2: E-R Modeling)
Week 3:
E-R Modeling
- Weak entities, relationship attributes, unary and n-ary relationships
- Large E-R Modeling example
- Generalizations and Specializations
- (Assignment 3: E-R Modeling of real estate company)
Week 4:
Relational Model, E-R Mapping
- Generalizations and specializations
- Relational model definitions, primary and foreign keys, integrity constraints
- Mapping of strong entities, weak entities, binary relationships, unary relationships
- Midterm Exam Review
- Intro to SQLDeveloper
Week 5: Midterm
Week 6: SQL DDL and SQLDeveloper
- (Return and go over midterm)
- Intro, CREATE, domains, INSERT, SQLDeveloper, CHECK, CONSTRAINT,
ALTER, UPDATE, DELETE.
- Queries, WHERE clause and comparisons
- (Assignment 4: E-R Mapping, SQL table creation )
Week 7: SQL DML
- Brief DDL review
- SELECT, FROM, WHERE, comparisons, LIKE, ORDER BY
- Aggregate functions, GROUP BY, HAVING
- Joins (Cartesian product, equi-join, inner join, outer join)
- (Assignment 5: SQL queries, due in 1.5-2 weeks)
Week 8: SQL DML, Normalization
- Joins (inner and outer), views
- Redundancy, functional dependencies
- Begin normal forms, normalization
Week 9: SQL DML, Normalization
- Views and Updates
- Redundancy and functional dependencies
- Functional dependency derivation, finding primary keys
- Normal forms and normalization
- (Assignment 6: Schema normalization)
Week 10: Normalization, Course Review
- Final normalization example
- Review for final exam
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.
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.
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.
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 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