INF 385M - Database Management
Restricted to graduate-level degree seekers at the School of Information.
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.
Three lecture hours a week for one semester.
Enrollment is restricted to iSchool degree seekers as of Summer 2017.
This particular version of INF 385M will introduce you to data modeling. The focus will be on relational databases and on logical database design. Topics will include data modeling and entity-relationship (ER) representation, requirements analysis and conceptual data modeling, introduction to SQL, transformation of the conceptual model to SQL, database normalization, XML and Web technologies. We will make connections with concepts related to information organization and metadata. MySQL and other open source tools will be used in practical assignments and in a course project.
At the end of this course you will be able to:
* apply data modeling to practical problems,
* create entity-relationship models,
* design database schemas for "clean" and efficient data representation,
* use SQL implement database schemas and to query data,
* understand the relationship between XML and databases,
* discuss significant issues and ask the right questions when working with database administrators.