Discuss the various types of tertiary storage devices

Assignment Help Basic Computer Science

Reference no: EM132334639

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.

Reference no: EM132334639

Questions Cloud

Health professionals protect patients : Thinking about laws and regulations, how would the events that led to the discovery and experimentation with HeLa cells have been different if they

Define theoretical grounded approach to design technologies : Value Sensitive Design (VSD) describes theoretically grounded approaches to design technologies. In particular, VSD provides a detailed and principled.

How do you utilize social networks in a job search : How do you utilize social networks in a job search? Discuss the increased use of on-the-spot interviews for entry-level positions; sharing a resume

Concept mean when relating to the lmx theory : This is obviously not about a popularity contest. What does this concept mean when relating to the LMX theory?

Discuss the various types of tertiary storage devices : COM 322-Database Design II -Explain and demonstrate how to design forms reports and triggers in object oriented databases. Revise the physical storage media.

Trait theory of leadership contends : What does this mean and what does the research suggest regarding how many of our leadership skills are innate and how many are learned?

Which ceo-jobs or cook-do you think executed : From Chapter 2, page 59; answer Jobs vs. Cook case. Steve Jobs was a strong, charismatic leader who co-founded Apple and is credited with much of the success.

Emphasized making affordable computers : This CEO, therefore, emphasized making affordable computers that could be bought by low-income households. Which of the following does this example demonstrate?

What does performance improvement in healthcare mean : What does Performance Improvement in Healthcare mean to a leader in healthcare?

User Account

All Pages