IS 451 Database Design for Information Systems
Summary
Requirement analysis, conceptual design, logical design and implementation of relational databases. Emphasis will be on E-R modeling and E-R mapping, along with basic normalization and SQL for database implementation.
Texts
Grading
Assignments 50%
Midterm exam* 25%
Final exam (comprehensive)* 25%
*: No make-up exam. Online/Flex students set up proctor exam appointments through MyCDM or the D2L course website. The general information on proctored exams is available at https://www.cdm.depaul.edu/onlinelearning/Pages/Exams.aspx.
Prerequisites
IS 411 or IT 411 or CSC 401
Weeky schedule
WK1: Course administration, introduction to databases, relational databases
WK2: Entity-Relation (E-R) modeling, basic terminology, notations, cardinality, participation
WK3: E-R modeling, domain modeling, weak entities, unary & n-ary relationships
WK4: E-R model, E-R mapping, common design patterns
WK5: E-R mapping, generalization & specialization, primary & foreign keys, mapping of binary to n-ary relationships
WK6: Midterm exam
WK7: [Lab session] SQL Data Definition Language (DDL) & introduction to Oracle SQL Developer
WK8: [Lab session] SQL Data Manipulation Language (DML) – SELECT, INSERT, UPDATE
WK9: [Lab session] Formal process of normalization, SQL DML, joins, GROUP BY, ORDER BY
WK10: Normalization, summary example (start-to-finish), course review
WK11: 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