Fundamentals of Database Management and Data Analysis

Catalog description

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.