Course Search | Main

CS393 COURSE DETAILS


5 Version(s) of this Course

CS393 (Version: 2022 1) COURSE DETAILS (ARCHIVED)


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.
LESSONS: 30 @ 75 min (2.000 Att/wk) LABS: 0 @ 0 min
SPECIAL REQUIREMENTS:
None

CS393 COURSE REQUISITES


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

CS393 (Version: 2022 2) COURSE DETAILS


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.
LESSONS: 30 @ 75 min (2.000 Att/wk) LABS: 0 @ 0 min
SPECIAL REQUIREMENTS:
None

CS393 COURSE REQUISITES


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

CS393 (Version 2022-2) COURSE OFFERINGS


AYT #SECT/SIZE CPBLTY ENRLD WAIT SEATS CLOSED CRSE DIRECTOR DETAILS
2023 - 1 2 18 36 29 0 7 N LTC SLOAN Hours

2023 - 8 1 18 18 2 0 16 N Hours

2024 - 1 2 18 36 36 0 0 N Hours

2025 - 1 2 18 36 32 0 4 N LTC SLOAN Hours


CS393 (Version: 2020 1) COURSE DETAILS (ARCHIVED)


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.
LESSONS: 30 @ 75 min (2.000 Att/wk) LABS: 5 @ 55 min
SPECIAL REQUIREMENTS:
Three design projects; compensatory time given.

CS393 COURSE REQUISITES


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

CS393 (Version: 2015 1) COURSE DETAILS (ARCHIVED)


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.
LESSONS: 35 @ 55 min (2.500 Att/wk) LABS: 5 @ 55 min
SPECIAL REQUIREMENTS:
Three design projects; compensatory time given.

CS393 COURSE REQUISITES


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

CS393 (Version: 1990 2) COURSE DETAILS (ARCHIVED)


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)
LESSONS: 35 @ 55 min (2.500 Att/wk) LABS: 5 @ 55 min
SPECIAL REQUIREMENTS:
Three design projects; compensatory time given.

CS393 COURSE REQUISITES


TYPE COURSE EFF YEAR EFF TERM TRACK RED BOOK FLG
PRE REQUISITE  
  CS360 1993 1 1 Y
  CS360A 1997 1 2 Y