May 26, 2020
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
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.
Add to Portfolio