Database Systems ((4 Credits))

Catalog description

This course covers the design and development of databases that support the activities of an organization. Data modeling and the implementation of data models will be a major component of the course, with students studying normalization and formal modeling conventions. The model will be implemented using SQL. Metadata is also covered as well as some aspects of database administration. Prerequisites (must complete before registering): A basic understanding of databases such as that covered by Introduction to Data Management Tools ( INFS 2010 ), Introduction to Database Design ( CSCI 1015 ), or equivalent database knowledge. Assumptions about surrounding courses: Knowledge of systems analysis and design is helpful but not required. A background in logic such as that gained in Discrete Mathematics is helpful but not required. Notes: Some sections of this course will use an Oracle DBMS and/or modeling tools such as Microsoft Visio. This course was previously SMT-273984 Database Systems.