This course provides students an opportunity to design, implement and use database management systems in managing the data needs of a community. It introduces, in a comparative framework, the structure, requirements, functions and evolution of database management systems.
After covering the conceptual data model and the entity-relationship diagram, the course focuses on relational data model.
Students learn abstract data languages such as relational algebra including their commercial implementations like SQL. Database design is introduced and discussed in detail. Concepts of data integrity, security, privacy, and concurrency control are introduced.
Students implement a major database application project using Oracle. Each group of students selects a project which they will work on through the semester. It involves the design of the database for a 'real life' community of their choice.
