| COURSE | TITLE | EFF YEAR | EFF TERM | DEPARTMENT | CREDIT HOURS | ||||
| CS393 | DATABASE SYSTEMS | 2022 | 1 | Electrical Engineering and Computer Science | 3.0 (BS=0.0, ET=3.0, MA=0.0) | ||||
| SCOPE | |||||||||
| This course addresses the analysis, design and implementation of relational and non-relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, web data extraction, Big Data, MapReduce framework and key-value stores. | |||||||||
|
|||||||||
| SPECIAL REQUIREMENTS: | |||||||||
| None | |||||||||
| TYPE | COURSE | EFF YEAR | EFF TERM | TRACK | RED BOOK FLG |
| DISQUALIFIER | |||||
| IT393 | 2020 | 1 | 1 | Y | |
| PRE REQUISITE | |||||
| CY300 | 2018 | 1 | 4 | Y | |
| CY305 | 2017 | 1 | 4 | Y | |
| CY300 | 2018 | 1 | 5 | Y | |
| CY355 | 2017 | 1 | 5 | Y | |
| COURSE | TITLE | EFF YEAR | EFF TERM | DEPARTMENT | CREDIT HOURS | ||||
| CS393 | DATABASE SYSTEMS | 2022 | 2 | Electrical Engineering and Computer Science | 3.0 (BS=0.0, ET=3.0, MA=0.0) | ||||
| SCOPE | |||||||||
| This course addresses the analysis, design implementation, and management of relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation, data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems. Students are exposed to user and privilege management, database backup and recovery, and security vulnerabilities such as SQL injection. | |||||||||
|
|||||||||
| SPECIAL REQUIREMENTS: | |||||||||
| None | |||||||||
| TYPE | COURSE | EFF YEAR | EFF TERM | TRACK | RED BOOK FLG |
| DISQUALIFIER | |||||
| IT393 | 2020 | 1 | 1 | Y | |
| PRE REQUISITE | |||||
| CY300 | 2018 | 1 | 4 | Y | |
| CY305 | 2017 | 1 | 4 | Y | |
| CY300 | 2018 | 1 | 5 | Y | |
| CY355 | 2017 | 1 | 5 | Y | |
| CY300 | 2019 | 2 | 6 | Y | |
| CY305X | 2025 | 1 | 6 | Y | |
| AYT | #SECT/SIZE | CPBLTY | ENRLD | WAIT | SEATS | CLOSED | DETAILS | ||
| 2025 - 1 | 3 | 18 | 54 | 51 | 0 | 3 | N | Hours | |
| 2025 - 8 | 1 | 18 | 18 | 0 | 0 | 18 | N | Hours | |
| 2025 - 9 | 1 | 18 | 18 | 0 | 0 | 18 | N | Hours | |
| 2026 - 1 | 3 | 18 | 54 | 54 | 1 | 0 | N | Hours | |
| 2027 - 1 | 2 | 18 | 36 | 28 | 0 | 8 | N | Hours | |
| 2027 - 8 | 1 | 18 | 18 | 0 | 0 | 18 | N | Hours | |
| 2028 - 1 | 2 | 18 | 36 | 0 | 0 | 36 | N | Hours | |
| 2028 - 8 | 1 | 18 | 18 | 0 | 0 | 18 | N | Hours | |
| COURSE | TITLE | EFF YEAR | EFF TERM | DEPARTMENT | CREDIT HOURS | ||||
| CS393 | DATABASE SYSTEMS | 2020 | 1 | Electrical Engineering and Computer Science | 3.0 (BS=0.0, ET=3.0, MA=0.0) | ||||
| SCOPE | |||||||||
| This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, data recovery techniques, and maintaining state for mobile devices. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software. | |||||||||
|
|||||||||
| SPECIAL REQUIREMENTS: | |||||||||
| Three design projects; compensatory time given. | |||||||||
| TYPE | COURSE | EFF YEAR | EFF TERM | TRACK | RED BOOK FLG |
| DISQUALIFIER | |||||
| CS350 | 2011 | 1 | 1 | Y | |
| PRE REQUISITE | |||||
| CS301 | 2010 | 1 | 1 | Y | |
| IT305 | 2008 | 1 | 2 | Y | |
| IT355 | 2017 | 1 | 3 | Y | |
| CY300 | 2018 | 1 | 4 | Y | |
| CY305 | 2017 | 1 | 4 | Y | |
| CY300 | 2018 | 1 | 5 | Y | |
| CY355 | 2017 | 1 | 5 | Y | |
| COURSE | TITLE | EFF YEAR | EFF TERM | DEPARTMENT | CREDIT HOURS | ||||
| CS393 | DATABASE SYSTEMS | 2015 | 1 | Electrical Engineering and Computer Science | 3.0 (BS=0.0, ET=3.0, MA=0.0) | ||||
| SCOPE | |||||||||
| This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, data recovery techniques, and maintaining state for mobile devices. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software. | |||||||||
|
|||||||||
| SPECIAL REQUIREMENTS: | |||||||||
| Three design projects; compensatory time given. | |||||||||
| TYPE | COURSE | EFF YEAR | EFF TERM | TRACK | RED BOOK FLG |
| DISQUALIFIER | |||||
| IT393 | 2020 | 1 | 1 | Y | |
| PRE REQUISITE | |||||
| CY300 | 2018 | 1 | 4 | Y | |
| CY305 | 2017 | 1 | 4 | Y | |
| CY300 | 2018 | 1 | 5 | Y | |
| CY355 | 2017 | 1 | 5 | Y | |
| COURSE | TITLE | EFF YEAR | EFF TERM | DEPARTMENT | CREDIT HOURS | ||||
| CS393 | DATABASE SYSTEMS | 1990 | 2 | Electrical Engineering and Computer Science | 3.0 (BS=0.0, ET=3.0, MA=0.0) | ||||
| SCOPE | |||||||||
| This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, and data recovery techniques. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software. (Note: became CS350 Database Design and Implementation eff 2004-2) | |||||||||
|
|||||||||
| SPECIAL REQUIREMENTS: | |||||||||
| Three design projects; compensatory time given. | |||||||||
| TYPE | COURSE | EFF YEAR | EFF TERM | TRACK | RED BOOK FLG |
| PRE REQUISITE | |||||
| CS360 | 1993 | 1 | 1 | Y | |
| CS360A | 1997 | 1 | 2 | Y | |