Fundamentals of Database Design and Management

Undergraduate

Role of databases in organizations. Business requirement analysis and use of tools and techniques for designing and administering a new database. Conceptual data modelling and emphasis on the relational database model. Application of concepts using current commercial systems. Database manipulation using SQL and other query mechanisms. Transaction management, maintenance, reliability and security. Database trends and emerging technologies. Course Format: Lectures, lab, 3 hours per week. Restrictions: Open to BAcc, BBA, BCB, Data Sciences and Analytics majors (DASA/DAFA) and combined Business majors. Prerequisite(s): ITIS 2P91 or ACTG 3P97 Course Notes: This course may be offered in multiple modes of delivery. The method of delivery will be listed on the academic timetable, in the applicable term.