[go: up one dir, main page]
Scribd
Upload
4 views3 pages

Week2_Exercises

The document contains exercises for a Database Management Systems course focused on banking and movie database schemas. It requires students to identify attributes, tuples, and schemas, as well as to create SQL sentences and schema diagrams. The exercises aim to enhance understanding of database structure and design principles.

Uploaded by

Sümeyye Öztürk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

Week2_Exercises

The document contains exercises for a Database Management Systems course focused on banking and movie database schemas. It requires students to identify attributes, tuples, and schemas, as well as to create SQL sentences and schema diagrams. The exercises aim to enhance understanding of database structure and design principles.

Uploaded by

Sümeyye Öztürk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

BMI2223 DATABASE MANAGEMENT SYSTEMS

EXERCISES for WEEK#2

Exercise 1: In Figure 1 are instances of two relations that might constitute part of a banking
database. Indicate the following:

a) The attributes of each relation.


b) The tuples of each relation.
c) The components of one tuple from each relation.
d) The relation schema for each relation.
e) The database schema.
f) A suitable domain for each attribute.
g) Draw a schema diagram for this database.
Exercise 2: You are given Example database schema about “movies” and the explanation for
each table. Indicate the followings.
a) Show keys in the schema
b) Give basic SQL sentences for creation of this schema.
c) Draw a schema diagram for this database.
Figure 2: Example database schema about movies

Good Luck!
Asst. Prof. Dr. Arzum Karataş

You might also like