AEM 2820 - Introduction to Database Management Systems

Fall. 3 credits. Letter grades only (no audit).

Forbidden Overlap: due to an overlap in content, students will receive credit for only one course in the following group: AEM 2820, HADM 3740, HADM 6740.
Prerequisite: AEM 2010. Enrollment preference given to: Dyson students.

R. Moghimi.

Introduces the principals and functions of relational database management systems (DBMS) and their business application. Students will explore both logical and physical database designs and develop a clear understanding of the concepts and terminology related to DBMS. A small relational database will be designed and students will learn to run SQL queries. Students will learn a set of skills to describe what happened in the past using queries, descriptive statistics, data visualization, and some data mining techniques. Excel add-ins and other DBMS software may also be employed.

Outcome 1: Discuss database management systems and design.

Outcome 2: Explain the terminology related to database management systems.

Outcome 3: Describe the design and implementation of a database management system.

Outcome 4: Execute queries using SQL syntax.

Outcome 5: Build models to solve real-world business problems.

Outcome 6: Demonstrate knowledge of skills for supporting the decision-making process.