Database Design and Management
[17:610:557]
Pre-requisites: 17:610:550 Description: Relational, object oriented and other database systems as tools for management decision making, for inclusion on the web and for other purposes. Custom designing versus off-the-shelf applications. Synopsis: Course Objectives:
- Read about and discuss the evolution of database management systems from legacy systems to the Web;
- Become knowledgeable about different types of databases (e.g., DSS, Linguistic, Marketing, Knowledge Management, etc.);
- Learn about data structures;
- Learn about relational databases;
- Learn how to design a Database Management System (DBMS);
- Practice using Structured Query language (SQL);
- Implement a database using Microsoft Access software;
- Develop data entry forms and report templates;
- Become familiar with Objected Oriented Database Management Systems;
- Learn about applications for database management systems in information organizations.
Course Organization:
Along with theory, this course will have a large experiential component with students designing and implementing a database
system for their own use. Most sessions will include a lecture, demonstration, and/or discussion. All students are expected to actively participate by asking questions, offering information, and helping each other. There will be a lab segment during each class session as well.
The instructor reserves the right to make slight changes in this syllabus as interests of the class and/or current events dictate. Please inform the instructor on the first day of class if you need any special accommodations for learning.
|
