ISEM 534 Database Design and Management

This course emphasizes the practical aspects of the design and administration of modern Database Management Systems (DBMSs) that host enterprise data. Specific topics include the role of data in modern enterprises and the data life cycle that spans conceptual database design, database query languages such as SQL, database integrity rules, database administration, and data warehouses. This course utilizes commercially available relational DBMSs for hands-on experiments and explore how to create an entity-relationship data model, translate that model into relational schema, build and use a relational database that implements the schema, create SQL queries to retrieve and manipulate needed data, provide access to remote databases from web browsers, and experiment with DBA (Database Administration) capabilities. The student also investigates recent developments in database technologies (e.g. NoSQL). This course prepares the student for database design and administration positions and will also provide the necessary background for more specialized courses in database systems.