The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help

    Saint Joseph's College: Online Programs
   
 
  Sep 19, 2017
 
 
    
2017-2018 Saint Joseph’s College Online
[Add to Portfolio]

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]