Enrollment and waitlist data for current and upcoming courses refresh every 10 minutes; all other information as of 6:00 AM.
09/05 - 12/21 | ||||||
M | T | W | Th | F | Sa | Su |
5:45 pm |
Subject: Computer & Info Sci (UG) (CISC)
CRN: 42488
Lecture
St Paul: O'Shaughnessy Science Hall 333
This course focuses on relational database design and system concepts. Database design includes database concepts, data models, conceptual (EER) and relational schema designs, query languages (SQL), physical data storage and access methods, and physical schema designs. Database systems includes query processing, transaction concepts and management such as concurrency control and recovery from failure, and database security and authorization. Students will complete a relational database design project. Prerequisites: MATH 128 and a minimum grade of C- in CISC 230
4 Credits
09/05 - 12/21 | ||||||
M | T | W | Th | F | Sa | Su |
5:45 pm |
Subject: Software Eng (Grad) (SEIS)
CRN: 40107
Lecture
St Paul: O'Shaughnessy Science Hall 333
Requirements Met:
Software Data Mgmt Conc
Software Technical Elective
This course focuses on database management system concepts , database design, and implementation. Conceptual data modeling using Entity Relationships (ER) is used to capture the requirements of a database design. Relational model concepts are introduced and mapping from ER to relational model is discussed. Logical database design (Normalization) and indexing strategies are also discussed to aide system performance. Relational Algebra and Structured Query Language (SQL) are used to work with a database. From a system perspective, the course focuses on query optimization and execution strategies, concurrency control, locking, deadlocks and database back up and recovery concepts. Database security and authorization are also discussed. Students will use Oracle and/or SQL Server to design a database and complete an application using SQL as their project. Prerequisite: SEIS 610. SEIS 630 may be taken concurrently with SEIS610.
3 Credits