CSIS 3722 - Development of Databases
Fall 2026 Syllabus, Section 03, CRN 41059,
Credit hours: 3
Course Meeting Times
Log in to view more
Instructor
Rachel Gramann
Email: regramann@ysu.edu
Course Description
3722. Development of Databases. This course covers concepts about data modelling, relational data model, Structured Query Language (SQL), relational database design and transaction processing. Storing, retrieving, updating and displaying data using Structured Query Language (SQL), functions and triggers. Secure operations performed by database administrators. Prereq.: C or better in CSIS 1590 or (CSIS 1595+CSIS 1595L) or (CSIS 2605+CSIS 2605L) or (CSIS 2610+CSIS 2610L). 3 s.h.
Course Readings
| Group | Title | Author | ISBN |
|---|---|---|---|
| Required | A Guide to SQL, 10th Edition | Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. Last | 9780357419731 |
The course readings are subject to change in the event of extenuating circumstances, research developments, current events, and/or to ensure better learning.
Assignments/Assessments
Log in to view more
Schedule of Topics and Assignments
| Week of | Reading(s) | Proposed Topic | Due/To Prepare for Class |
|---|---|---|---|
| 8/24 | Chapter 1 | Introduction to Databases | Discussion 1; Module 1 Quiz; Module 1 Use It; Module 1 Case Exercise: KimTay Pet Supplies |
| 8/31 | Chapter 2 | Database Design Fundamentals | Module 2 Quiz |
| 9/7 | Chapter 3 | Creating Tables | Discussion 2; Lab 3-1: KimTay Pet Supplies |
| 9/14 | Chapter 3 | Creating Tables | Module 3 Quiz |
| 9/21 | Chapter 4 | Single-Table Queries | Discussion 3; Module 4 Quiz |
| 9/28 | Chapter 4 | Single-Table Queries | Lab 4-1: KimTay Pet Supplies; Module Lab Assessment 1 |
| 10/5 | Chapter 5 | Multiple-Table Queries | Discussion 4; Module 5 Quiz |
| 10/12 | Chapter 5 | Multiple-Table Queries | Lab 5-1: KimTay Pet Supplies |
| 10/19 | Chapter 6 | Updating Data | Discussion 5; Module 6 Quiz |
| 10/26 | Chapter 6 | Updating Data | Lab 6-1: KimTay Pet Supplies; Module Lab Assessment 2 |
| 11/2 | Chapter 7 | Database Administration | Discussion 6; Module 7 Quiz |
| 11/9 | Chapter 7 | Database Administration | Lab 7-1: KimTay Pet Supplies |
| 11/16 | Chapter 8 | Functions, Procedures, and Triggers | Discussion 7; Module 8 Quiz |
| 11/23 | Thanksgiving Break | ||
| 11/30 | Chapter 8 | Functions, Procedures, and Triggers | Lab 8-1: KimTay Pet Supplies |
| 12/7 | Chapter 8 | Functions, Procedures, and Triggers / Course Wrap-Up | Module Lab Assessment 3 |
The course schedule, policies, procedures, and assignments in this course are subject to change in the event of extenuating circumstances, by mutual agreement, and/or to ensure better learning.