BU 655 Introduction to Database Management
This course covers the concepts and design for Relational Database Management Systems (DBMS) and the Structured Query Language (SQL) needed to define and manipulate data. Students will learn the concept of database and data structure, data warehouse, and data mining. They will also learn how to create conceptual, logical and physical designs of relational databases. We will use a Microsoft Access database to design the entity-relationship diagrams (ERD) and implement a working database. The course covers methods for adding data, updating data, extracting data, producing readable output, and creating and manipulating tables and creating and managing constraints using SQL.