Dec 03, 2024  
2018-2019 Saint Joseph’s College Online Catalog 
    
  Catalog Home
  College Home Website
  Admissions
  General Information
  Graduate Programs
  Graduate Policies
  Graduate Courses
  Undergraduate Programs
  Undergraduate Policies
  Undergraduate Courses
  Continuing Education Courses
  Summer Programs
  Summer Tuition and Fees
  Policies and Procedures
  Consumer Grievance Policy
  Student Resources
  Textbook and Materials
  Graduation
  Brightspace Login
  Distance Learning
  Contact Information
  On-Campus Programs at a Glance
  Tuition and Fees
  My Portfolio
HELP
2018-2019 Saint Joseph’s College Online Catalog [Archived Catalog]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
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


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