Course: BANA 614. Database Management for Business (3)
Prerequisite: Graduate standing. The primary goal of this course is to understand principles and practices of database management and design. Students learn the principles of database design, implementation, as well as data querying and processing. Database administration (including security, concurrency control, performance monitoring and tuning, resource sharing, and recovery) is also covered. Students learn and practice the fundamentals of the Structured Query Language (SQL), entity-relationship diagrams, dependencies and normalization. The emerging issues of data governance and related risk management are also studied. Projects require students to design and develop a database application for a business situation by utilizing design tools and a major database management systems (DBMS) package.