Fall 2018

INF 385M Database Management

Unique ID: 27725


DESCRIPTION

Principles and practices of database management and database design. Discussion and implementation of a database. Application life cycle, data dictionaries, relational database design, SQL queries, reports and other interfaces to database data, and documentation. Students work on individual and group projects.

COURSE NOTES

This section of INF 385M will introduce you to data modeling and SQL. The focus will be on relational database concepts and on practical use of SQL. Topics will include data modeling, entity-relationship (ER) diagrams, introduction to SQL, transformation of E-R models to SQL, database normalization. MySQL and other open source tools will be used in practical assignments and in a course project. This class takes the "flipped classroom" approach that minimizes in-class lecture time and maximizes the time students spend in the class (computer lab) on applying their knowledge to solving practical problems. All assigned readings are required to be completed before class. An important course activity, in which student teams will engage, will be a hands-on term project. Syllabus URL: http://hornet.ischool.utexas.edu/index.html

PREREQUISITES

Graduate Standing.

RESTRICTIONS

Restricted to students enrolled in the School of Information.