• Keine Ergebnisse gefunden

Relational Databases 2 Exercise Sheet I: System Architecture (until Tuesday 17.04.2012)

N/A
N/A
Info
Herunterladen
Protected

Academic year: 2021

Aktie "Relational Databases 2 Exercise Sheet I: System Architecture (until Tuesday 17.04.2012)"

Copied!
1
0
0

Wird geladen.... (Jetzt Volltext ansehen)

Jetzt herunterladen ( 1 Seite )

Volltext

(1)

Relational Databases 2

Exercise Sheet I: System Architecture (until Tuesday 17.04.2012)

Exercises have to be turned in until Tuesday of each respective week and may be completed in teams of two students each. You may hand in your solutions on paper before the lecture or into the mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2nd floor). Please do not forget your “Matrikel- nummer” on your solutions. Please note, all exercises are optional.

Exercise 1

a. Briefly define the following terms:

 Database, DBMS, Schema, System Catalog, View, Transaction

b. Briefly discuss the main characteristics of DBMS and how they differ from plain file systems.

Exercise 2

a. Explain the difference between Internal-, Conceptual- and External schemas used in relational database architectures.

b. Explain the difference between Logical- and Physical Data Independence c. Explain briefly the tasks handled by:

 Storage Manager, Query Processor, and Transaction Manager

Referenzen

Jetzt herunterladen ( PDF - 1 Seite - 88.85 KB )

ÄHNLICHE DOKUMENTE

Relational Databases 1 Exercise Sheet 5: Relational Model (until Thursday 22.11.2012)

Exercises have to be turned in until Thursday of each respective week and must be completed in teams of two students each.. You may hand in your solutions either on paper before

Relational Databases 1 Exercise Sheet 6: Relational Algebra (until Thursday 29.11.2012)

actor(person → Person, movie → Movie, role) director(person → Person, movie → Movie) hasGenre(movie → Movie, genre → Genre) connection(from → Movie, to → Movie, type)..

Relational Databases 1 Exercise Sheet 7: Relational Calculus (until Thursday 06.12.2012)

Based on this relation schema, please provide statements returning following results in relational algebra, tuple relational calculus and domain relational calculus:.

Relational Databases 2 Exercise Sheet 2: Physical Data Storage (until Tuesday 24.04.2012)

Explain the main characteristics of offline, nearline and online storage and give an example.. What type of data should be stored in

Relational Databases 2 Exercise Sheet 3: Indexing and Access Paths (until Tuesday 08.05.2011)

You may hand in your solutions on paper before the lecture or into the mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2nd floor).. Please do not

Relational Databases 2 Exercise Sheet 4: Trees & Advanced Indexes (until Tuesday 15.05.2012)

Tree Traversal: Access all nodes of the tree in Pre-Order, In-Order and Post-Order.. Exercise 2:

Relational Databases 2 Exercise Sheet 5: Query Processing (until Tuesday 22.05.2012)

CREW(movie, person not null , type not null , creditpos) REMARK(movie, person not null , remark not null ) GENRE(movie, genre not null )b. COUNTRY(movie, country not

Relational Databases 2 Exercise Sheet 6: Query Optimization (until Tuesday 05.06.2012)

“Matrikelnummer” on your solutions. Please note: all exercises are optional. Draw a canonical operator tree for following queries and denote the number of rows of the