Course Description:
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. Larger picture topics such as ethics and implementation will be addressed as well. Students will use Visio modeling software and an Oracle database (see Note). A group modeling project will allow students to develop their ability to work as a team, a common practice in the industry. Students will complete an individual project involving the design and implementation of a database.
Note: Students in this course are required to install and use Microsoft Visio on their personal computer. The Oracle DBMS is designed for PCs. It is possible to run it on a Mac using a virtual machine (it is highly recommended that Mac users have experience with the multi-OS virtual environment before signing up for this course; no support for setting this up and installing Oracle is available). Alternately, students may access Oracle DBMS online through a college virtual desktop system.
Prerequisites: A basic understanding of databases. Knowledge of systems analysis and design is helpful but not required.
Click Your Browser's Back Button to Return to Previous Screen
