HADM 3740 - Fundamentals of Database Management and Data Analysis

Spring. 3 credits. Student option grading.

Prerequisite: HADM 1740 or HADM 2740. Enrollment limited to: undergraduate students. Priority given to: NSHA juniors and seniors. Graduate students must enroll in HADM 6740. Satisfies HADM or free electives for NSHA students. Co-meets with HADM 6740.

A. Whitmore.

Prepares students to create and manage information in a knowledge-based organization. Students learn to design and use database tools to perform analyses and to make decisions in today’s information-rich business environment. The course provides both theoretical and practical perspectives of database design and administration, with a focus on application. To manage this balance, students first gain a foundation of database concepts from lecture and course readings, and subsequently apply these fundamentals through various projects and assignments. Topics include information and information management in organizations; fundamentals of relational database design and implementation; writing and running SQL queries; working in database design teams and as individual research analysts; database design and management using Microsoft Access; database normalization; data-driven decision making; conversion of data into information and knowledge that can be leveraged to achieve business objectives; the role of data and information management in contemporary society; and data management opportunities in the hospitality industry.