DataBase Management

Catalog description

Provides a comparison of techniques, methodology of systems, limitations, and applications of various data base management systems. MIS 465 Database Management (3), is a required course for information systems majors in the business program. The objective of the course is to present database design and development, specifically relational database management systems (RDBMS), along with project work on developing database systems. The course coverage includes conceptual data modeling, relational data model, structured query language (SQL), data normalization, database integrity, and database administration. Advanced topics such as distributed databases and data warehousing are also discussed briefly. The course prerequisite is IST 140 or CMPSC 101 or CMPSC 121 and MIS 390 . This course is centered on a group project involving the design and development of a relational DBMS. Student groups also work on case and homework problems related to database design. A suitable relational database package, like ORACLE, is used by students in the group project. Database design and development involving the creation of tables, queries, forms, and reports are the center piece of the group project. MIS 465 will be offered once per semester with multiple sections based on student enrollment and demand.