CSC 451 Database Design for Information Systems (Formerly CSC 451)
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.
http://library.books24x7.com.ezproxy.depaul.edu/bookshelf.asp?site=XOBDU ; 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. 10th
Final Exam -- 30% scheduled date: Mar. 17th
- All assignment descriptions with complete instructions will be posted only on the course web pages on D2L.
- Each assignment will have a specific due date and time. Check the D2L 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 D2L.
- Late submissions of assignments will not be accepted. If you wish to have your work considered for partial credit, you must submit the work you completed by the assignment deadline. 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 |
A |
A- |
B+ |
B |
B- |
| Percent |
100 - 93 |
92 - 90 |
89 - 87 |
86 - 83 |
82 - 80 |
| Grade |
C+ |
C |
C- |
D+ |
D |
F |
| Percent |
79 -- 77 |
76 - 73 |
72 - 70 |
69 - 67 |
66 - 60 |
59 - 0 |
Prerequisites
Graduate Standing
Course Management Website
Desire2Learn https://d2l.depaul.edu
Software
Microsoft VISIO 2013 (or earlier version). VISIO 2013 is available in all University and CDM PC labs. If you want to install on your PC, it is available through
MSDNAA. Please carefully read and follow all instructions to obtain the software.
Technical Skills
If you do not have access to a DePaul lab or a lab with Microsoft VISIO 2013 installed on a PC, then it is expected you have the necessary skills to download the appropriate software and install this software on your PC or Mac.
Tentative Week- by-Week Schedule
This schedule is subject to change:
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:
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