INFO 1620 - Introduction to Database Design

4.5 Credits

This course introduces business database design and management functions. The focus is on the use of current database management systems (DBMS) to support the data management function of an organization. Topics include data modeling, database design, SQL, data management and database administration. Hands-on experience in database design, creation, and use is provided.

Lecture Hours: 4.5
Lab Hours: 0.0
Internship Hours: 0.0
Clinical or Practicum Hours: 0.0

Course Objectives

Distinguish between ‘data’ and ‘information’.
Define the terms ‘database’, ‘database management system’ and distinguish between such systems and their predecessors.
Define the characteristics and benefits of the relational database model.
Use SQL to define and modify database objects, and retrieve data.
Describe the database development process, and explain how it fits into the broader context of systems analysis, design, and implementation.
Use data modeling techniques and tools to develop data models.
Design appropriately normalized relations in a relational DBMS.
Design and implement a relational database system of modest size using a contemporary DBMS.
Identify the data integrity and security issues associated with database systems and explain how these are addressed in contemporary database management systems.
Discuss the issues and techniques used with databases in a distributed environment, including the Internet.
Explain the purpose, architecture, and associated terminology of data warehousing.

View Class Schedule