Database Management Systems: Group Activity
Database Management Systems I
Laboratory Exercise 1 – week 1
Year 1
Semester 2, 2013
Exercise 1: Group Activity
Get into groups of 5, find details and do a 10 minutes presentation on the facts below.
1. Siripala Amarasinghe is a retail vendor of a small grocery shop.
a) Explain how he maintains his sales information.
b) Assume, now Siripala has expanded his business and is going to start a supermarket. Is it possible to handle purchase and sales information with his prevailing settings?
c) What do you suggest to make his dynamic transactions in a more efficient and reliable way.
2. List places where databases are used.
3. Name existing database types and the reason for use different database types
4. Find 3 major DB vendors in the world.
5. What are the databases developed by Microsoft?
Exercise 2: To answer the following queries refer to the tables in the DBMS I database.
Activity 01
Retrieve the following details from the Customer table.
1. Display all customer details.
2. Display customer numbers of all the customers.
3. List down the first name and last name of all the customers.
4. Display customer number, city and their states of all the customers.
Activity 02
Retrieve the following details from the manufact table.
1. Retrieve all manufacturer details.
2. Display manufacture code and lead time of all the manufacturers.
Activity 03
Retrieve the following details from the order table.
1. Retrieve all order details.
2. Display order number and order date of all the orders.
3. List down the customer numbers of all the orders.
4. Write a query to format the output of the previous query by removing the duplicates.
****End of the lab sheet 01****
Laboratory Exercise 1 – week 1
Year 1
Semester 2, 2013
Exercise 1: Group Activity
Get into groups of 5, find details and do a 10 minutes presentation on the facts below.
1. Siripala Amarasinghe is a retail vendor of a small grocery shop.
a) Explain how he maintains his sales information.
b) Assume, now Siripala has expanded his business and is going to start a supermarket. Is it possible to handle purchase and sales information with his prevailing settings?
c) What do you suggest to make his dynamic transactions in a more efficient and reliable way.
2. List places where databases are used.
3. Name existing database types and the reason for use different database types
4. Find 3 major DB vendors in the world.
5. What are the databases developed by Microsoft?
Exercise 2: To answer the following queries refer to the tables in the DBMS I database.
Activity 01
Retrieve the following details from the Customer table.
1. Display all customer details.
2. Display customer numbers of all the customers.
3. List down the first name and last name of all the customers.
4. Display customer number, city and their states of all the customers.
Activity 02
Retrieve the following details from the manufact table.
1. Retrieve all manufacturer details.
2. Display manufacture code and lead time of all the manufacturers.
Activity 03
Retrieve the following details from the order table.
1. Retrieve all order details.
2. Display order number and order date of all the orders.
3. List down the customer numbers of all the orders.
4. Write a query to format the output of the previous query by removing the duplicates.
****End of the lab sheet 01****