MGS 613LEC - Database Mgmt Systems

This course is designed to provide students with a basic understanding of database management systems (DBMS) and the skills needed to design and implement a relational database. Students will be introduced to data modeling concepts, modeling tools, the process of transforming conceptual models into relational database designs, and finally the steps needed to implement those designs. Emphasis is placed on Entity-Relationship diagramming, data normalization, database administration, and data definition, data manipulation and query development using Structured Query Language (SQL). Other topics covered include: object-oriented databases, database security and integrity, web/database integration, application development in a Client/Server environment, distributed databases, data warehousing, data mining and knowledge management via the Internet to support electronic commerce. Readings, lectures, interactive case assignments and a database design project reinforce the role of DBMS in supporting organizational systems, transaction processing and decision support applications.

Credits: 3

Term Typically Offered: Fall