Description: Data are now recognized as a major organizational resource to be managed like other assets such as land, labor and capital. The ability to structure, access, manage and leverage this important resource is becoming more and more critical to all organizations, large or small, public or private. Central to supporting this ability,and at the core of every information system, is the database. Developments in database technology have produced systems that are more powerful and easier to use, develop, and maintain. This is especially true for relational databases - the predominant database structure used for business applications - and the primary focus of this course. This one semester course will address the theory, application and management of relational database technology. The course will cover topics on the relational data model, understanding entities and relationships, designing logical data models and database design using normalization theory. We will also learn relational algebra as the theory behind data queries and implement actual data queries using SQL to manage and retrieve data within an Oracle database. This course is appropriate for masters students who wish to acquire a technical understanding of relational database systems; their design, development, management and application, while developing knowledge of and skill in using the Oracle Database Management System, a popular database platform currently utilized by many organizations.
Learning Outcomes: 1. Gain good understanding of relational data model in terms of data structure, data integrity, and data manipulation. 2. Create and understand conceptual database models utilizing entity-relationship modeling 3. Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology 4. Understand the theory behind the relational data model as it applies to interactions with current database management systems 5. Read and interpret a given data model to query the database and transform the data into information using Structured Query Language 6. Implement a data model in a current relational database management system 7. Create reports, based on transactional data, including elements such as data groupings and summary values.