BUS-S307 Database Design & Management
This course focuses on the entire lifecycle of data management—eliciting data requirements, conceptual and logical design, and database implementation and use—along with the software that is used to manage the database, or, a database management system (DBMS). Students will develop an understanding of database concepts and learn how to use database systems to solve business problems. The topics include conceptual design (e.g., ER model), logical design (relational model, normalization, integrity constraints, keys, functional dependency), physical design (denormalization, data partitioning), key elements of SQL including Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL), querying using SQL (functions, views, different types of joins such as inner-join, outer join, and subquery). Using hands-on tools (e.g., Visio, Oracle, MongoDB), students learn how to operationalize and apply key concepts of database design and write SQL/NoSQL queries to develop dashboards that dove-tail with business needs.