Apr 16, 2024  
2017-2018 Undergraduate Academic Catalog 
    
Catalog Navigation
  Catalog Home
  Academic Calendar
  University Overview
  Enrollment Management Department
  Academic Regulations and Policies
  Student Financial Services
  Academic Departments, Undergraduate Degree Programs, Minors and Certificates
  Degree Programs, Minors and Certificates
  Reserve Officer Training Corps (ROTC)
  Course Descriptions
  Administration, Board of Regents, Faculty and Advisory Committees
  Campus Map
  Student Resources
  My Portfolio
HELP
2017-2018 Undergraduate Academic Catalog [ARCHIVED CATALOG]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)

CS 386 - Introduction to Database Systems

2 lecture hours 2 lab hours 3 credits
Course Description
This course introduces the theory and practice of database design and application, with emphasis on the relational model. Topics include the SQL data definition and manipulation language, database design using entity-relationship modeling and normalization techniques, application programing interfaces, authentication and access control, transaction processing and concurrency control, and performance optimization. Lab assignments reinforce the lecture material. (prereq: CS 2852 , MA 2310 )
Course Learning Outcomes
Upon successful completion of this course, the student will be able to:
  • Design database models using entity-relationship models, the relational model, and normalization
  • Use standard database languages (e.g. SQL) for querying, manipulating, and basic management of databases
  • Design relational database applications
  • Document database designs
  • Describe the purposes and typical mechanisms used to maintain data integrity relating to protecting existence, maintaining quality, and ensuring confidentiality
  • Be aware of modern trends in the area of database systems
Prerequisites by Topic
  • Knowledge of data structures
Course Topics
  • Introduction and prerequisite review (1 class)
  • Entity-relationship model and relational model (2 classes)
  • Relational Model (1 class)
  • SQL (2 classes)
  • Functional dependencies, normalization, relational design, and query optimization (2 classes)
  • Relational algebra and calculus, data definition and manipulation languages (SQL), aggregates, and updates (4 classes)
  • Record storage, index structures, transactions, and concurrency (3 classes)
  • Stored procedures, triggers, recovery, security, and database administration (2 classes)
  • Advanced database topics (2 classes)
  • Exam (1 class)
Laboratory Topics
  • Database introduction (1 session)
  • Data modeling (1 session)
  • SQL (1 session)
  • Application integration (2 sessions)
  • Design project design and implementation (4 sessions)
  • Design project demonstration (1 session)
Coordinator
Jay Urbain


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)