Search | Directories | Reference Tools
UW Home > Discover UW > Student Guide > Course Catalog 

Instructor Class Description

Time Schedule:

Shopen Patel
INFX 543
Seattle Campus

Relational Database Management Systems

Introduction to relational database design and development theory, concepts, and skills, including traditional transactional database theory, architecture, and implementation in a user-centered systems context using SQL. Introduces database modeling, security, and privacy issues. Prerequisite: INFX 502 or permission of instructor.

Class description

This 10 week online course will blend various activities to gradually grow comprehension on

1. What a Relational database system (RDMS) is and what it is used for

2. How to design and implement a relational database from scratch using a standard development methodology and a free commercially off the shelf RDMS product

3. What Structured Query Language (SQL) is and how it is used to create, manipulate and operate a relational database

Student learning goals

What a Relational database system (RDMS) is and what it is used for

How to design and implement a relational database from scratch using a standard development methodology and a free commercially off the shelf RDMS product

What Structured Query Language (SQL) is and how it is used to create, manipulate and operate a relational database

General method of instruction

This session of INFX 543 is offered as an online class with no scheduled residence or lab sessions. The 10 week course will be delivered through CANVAS and offer weekly reading assignments, weekly SQL tutorials and a weekly project design/build sprint with instructor recorded lectures to tie it all together. There is no textbook requirement for this class.

Recommended preparation

INFX 502 or equivalent, access to a personal computer (laptop or desktop, windows, mac or linux OS) and installation of MySQL Workbench.

This course will use MySQL Workbench, an integrated tools environment for Database Design & Modeling, SQL Development and Database Administration.

For Microsoft Windows platform: install the MySQL Installer for Windows and install all components. http://dev.mysql.com/downloads/installer/

For MAC OS X and all other platforms: install MySQL Community Server and MySQL Workbench (GUI Tool) http://dev.mysql.com/downloads/mysql/ http://dev.mysql.com/downloads/workbench/5.2.html#downloads

Class assignments and grading

Weekly Reading Assignments + Weekly SQL Tutorials + Weekly Project Deliverable + Weekly Lecture + Weekly Quiz + Weekly Laughing

10 weekly quizzes [50%], 10 weekly project deliverable's [40%], active participation in discussion boards [10%]


The information above is intended to be helpful in choosing courses. Because the instructor may further develop his/her plans for this course, its characteristics are subject to change without notice. In most cases, the official course syllabus will be distributed on the first day of class.
CANVAS - INFX 543 Winter 2013
Last Update by Shopen Patel
Date: 12/14/2012