INF 385M - Database Management

Spring 2013
Unique ID: 28402
Syllabus:   Syllabus
Prof:  Gwizdka, Jacek
Room: UTA 1.210A
Days:  Mon
Time: 3:00 - 6:00 pm
 

Prerequisites:
Restricted to graduate-level degree seekers at the School of Information.

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.

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.

Course Objectives
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.

View all classes with this course number

glqxz9283 sfy39587stf02 mnesdcuix8
sfy39587stf03
sfy39587stp14