Spring 2025 / COIS-3311, Database Management Systems

Catalog Description:
Required course for CIS, CS, and IT majors and minors. This course is designed to give the student an introduction to database theory, especially the differences in database systems and how to use a relational database. Students are expected to be proficient with the Java programming language and fundamental programming techniques including variables and data types, computations and assignment statements, logic control with loop and selection statements, working with strings and arrays, and modular programming with parameterized functions. Students must have a laptop computer.
Prerequisites: CoIs 2350 [with grade of C or better].

Course Overview:
A study of the theory and principles used in the design, implementation, and administration of database management systems. In this course, students learn the theory behind modern database systems and investigate the current models and languages that support relational database systems including entity-relationship models, object-oriented techniques, and SQL operations. Upon successful completion of this course, students will have a deeper knowledge and understanding of how database systems work and examine holistically the connection between theory and application of relational databases. Students will be required to install, configure, and make use of current open-source software packages needed to work with database systems. Students will NOT be required to purchase software. This is a technology-intensive course and students will be required to bring a usable laptop to all class sessions.

Required Textbook:

Fundamentals of Database Systems 7th Edition by Elmasri & Navathe (ISBN13: 978-0133970777).

Course Details:

Lecture:	Tuesday,Thursday -- 1:00 pm to 2:20 pm, Cooke 211.
Office Location:	Cooke C-206
Office hours:
Monday, Wednesday -- 9:00 am to 1:00 pm.
Tuesday, Thursday -- 11:00 am to 1:00 pm.