Designing Systems for Data Management
GSM IS 883
The first objective is to introduce the student the concept of design in information systems. Although the design concepts covered largely focus on data management, it will include high level systems design concepts as well. The second objective of this course is to introduce the student to the practical applications of databases and database management systems. The students will learn the fundamentals of data management starting with the basics of data design. The students will learn querying and managing the data in a database, defining the structures for storing data, and implementing business rules in relational databases using the Structured Query Language (SQL). The two objectives will tie in together as the students will be expected to integrate systems design with data design to design a prototype information system. This exercise will walk the students through the process of eliciting requirements, defining the scope, designing a restricted set of functions, designing the database, implementing the database, and explaining how restricted set of functions will use the data. The programming requirements will be very minimal. Besides the basics of data management, this course will also cover relevant ?in? topics in data management such as database security, data quality management, and data auditing (if time permits).
FALL 2014 Schedule
|A1||Swanborg||SMG 326||M 8:00 am-11:00 am||Reserved for