Course Description
Database Systems have become a permanent feature of organizations and are extensively used in business, administrative and scientific applications. These technologies enable organizations to store, retrieve and generally manage their data more effectively. Contemporary database management technologies do not only use well established models and standards but also incorporate developments to address current business requirements such as semantic enhancement of large data sources, storage and retrieval of new data types - e.g. multimedia and BLOBs, and web-database connectivity.
This course will build on the introduction to databases concepts and theories covered in MIS309, by reviewing and reinforcing both the theoretical underpinning and practical application of the Relational Approach to database management. Students will be exposed to all the stages of a typical database life cycle. i.e. the design, implementation, interrogation (querying) and administration of a relational database systems. Each stage will be illustrated and reinforced through practical seminar and/or laboratory-based exercises as required. The course is largely focused at the database applications level although some systems level issues such as transaction management and concurrency control are examined. Students are also introduced to 'recent' developments in the field, such as Data Warehousing, Data Mining and other forms of data representation (e.g. XML and OO databases).
Required text
Connolly, T. M., and Begg, C. E., Database Systems: a practical approach to design, implementation and management, Addison-Wesley, 2010, 5th edition
Course content
- Introduction to Database Systems and the Relational Approach.
- Entity Relationship Modelling.
- E-R modelling exercise.
- Enhanced Entity-Relationship Modelling.
- SQL (Multiple table queries & joins).
- SQL (Sub queries & Declarative constraints).
- SQL (Triggers).
- Normalization (Revision) & Advanced Normalization.
- Boyce-Codd Normal Form.
- Transaction Management1.
- Transaction Management2.
- Distributed Database Systems.1
- Distributed Database Systems.2
- Data Warehousing Concepts & Design.
- Data Mining.
Learning outcomes
- Demonstrate an understanding of the concepts, theories and principles of the Relational database model.
- Describe the development process of a typical Relational Database Systems.
- Identify the key features and application of a range of contemporary database technologies.
- Analyze, design, implement and interrogate relational database systems using one of the most popular DBMS, Oracle.
- Produce meaningful management reports from relational data sources by using their SQL skills.
- Describe and evaluate data warehousing and data mining options for purposes of business intelligence.
Course ID: MIS 403
| Credit hours | Theory | Practical | Laboratory | Lecture | Studio | Contact hours | Pre-requisite | 3 | 3 | 1 | 4 | MIS 309 |
|---|
