Database Design II
Goal: This course is designed to provide the student with further knowledge of computer databases
General Objectives: On completion of this course, the diplomat should be able to:
1. Know object oriented data mode and object oriented languages.
2. Understand the design of object-oriented databases.
3. Understand file structure and physical storage
4. Understand the concept of indexing and hashing.
5. Understand query processing
6. Understand the concept of transactions and concurrency control
7. Understand recovery systems
8. Understand DBMS applications
1 1.1 Understand object oriented data models and the concept of object oriented languages.
Discusses the different types of data models.
Explain the concept of object oriented languages
List object oriented data models.
Mention different types of object oriented languages e.g. O.O.pascal, visual C++ etc.
2 2.1 Design forms, reports and triggers.
Explain and demonstrate how to design forms reports and triggers in object oriented databases.
3 2.1 (continued) Design forms, reports and triggers.
Explain and demonstrate how to design forms reports and triggers in object oriented databases.
4 3.1 Understand physical storage media and tertiary storage devices
3.2 Understand access and organization of records, and data –dictionary.
3.3 Understand storage structure of object oriented databases
Revise the physical storage media.
Discuss the various types of tertiary storage devices eg CD-rom, tape
Explain access mode and record organization and data-dictionary storage concept.
Explain the storage structure of objectoriented databases.
5 4.1 Understand the basic concepts of indexing and hashing.
4.2 Understand ordered indices
4.3 Understand B+ and B– tree index files
4.4 Understand the concept of static and dynamic hasting
4.5 Understand multiple-key access.
Explain the concepts of indexing and hashing.
Discuss ordered indices
Explain B+,B- tree and the concept of static and dynamic hasting.
Explain multiple-key access concept.
6 5.1 Understand the concept of catalogue information.
5.2 Understand the selection operation
5.3 Understand sorting and join operations
5.4 Understand the evaluation of expressions
5.5 Understand the transformation of relational expressions.
Explain the concept of catalogue information.
Discuss the selection, sorting and join operations
Evaluate expressions and transform relational expressions.
7 6.1 Understand transaction, transaction state, atomicity and durability
6.2 Understand concurrent executions, serializability, recoverability and isolation.
6.3 Understand transaction in SQL and texts for serializability.
6.4 Understand the concept of lock based protocols, time-stamp-based and validationbased protocols.
Explain transaction state, atomicity and durability.
Discuss concurrent executions, serialization recoverability and isolation.
Explain transaction in SQL and how to test for serializability.
Discuss lock-based protocols time-strip based protocols.
8 6.5 Understand multiple granularity, multiversion schemes and deadlock handling.
6.6 Understand the insert and delete operations
6.7 Understand concurrency in index structures.
Explain multiple granularity, multiversion schemes and deadlock handling
Explain the insert and delete operations, and concurrency in index structures.
9 7.1 Understand failure classification and storage structures.
7.2 Understand recovery .
7.3 Understand log based recovery and shadow paging.
Discuss failure classification and storage structure.
Explain recovery and shadow paging.
10 7.4 Understand recovery with concurrent transaction.
7.5 Understand buffer management.
Explain recovery with concurrent transaction.
Discuss buffer management.
11 8.1 Understand decision support system (DSS).
8.2 Understand data analysis and data mining
Discuss DSS and data analysis.
Discuss data mining
12 8.3 Understand warehousing.
Discuss warehousing.
13 8.4 Understand spatial and geographical databases.
Explain spatial and geographical data bases.
14 8.5 Understand multi-media databases.
Discuss multimedia databases.
15 8.6 Understand mobility and personal data bases.
Discuss personal databases.