Apr 01, 2023  
2014-2015 Saint Joseph’s College Online 
2014-2015 Saint Joseph’s College Online [Archived Catalog]

Add to Portfolio (opens a new window)

IT 240 - Database I

This course discusses the basic design, implementation, and management of database systems. Students will learn data models, modeling tools and techniques, approaches to structural and object design, models for databases (relational, hierarchical, networked and object-oriented designs), CASE tools, data dictionaries, repositories and warehouses, Windows/GUI coding and/or implementation, code and application generation, client-server planning, testing and installation, system conversion, end-user training, integration, post-implementation review, and sorting and querying.

Prerequisites & Notes
IT 100

Assignment Overview
Synchronous term-based course with ten weekly assignments and a final project

Course Learning Objectives
Upon completion of this course, you should be able to do the following:

  • Explain the concepts of Database Management Systems.
  • Develop logical database models and convert logical database models into physical databases.
  • Explain the concepts and tools needed to perform data analysis and create data models.
  • Construct Entity-Relationship diagrams (ERDs).
  • Design, normalize and administer databases.
  • Demonstrate the ability to create databases and database objects.
  • Demonstrate the ability to perform insert, update, delete and data retrieval functions in a relational database.

Credits: 3

Add to Portfolio (opens a new window)