Tut1 Introduction To Database
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Tut1 Introduction To Database as PDF for free.
More details
- Words: 261
- Pages: 2
TEMASEK POLYTECHNIC TEMASEK Informatics & IT SCHOOL Database Information Systems (CIM1Z01) AY2008/2009 Oct Semester Tutorial 1 – Introduction to Database Objectives - On completion of this tutorial session, the students will be able to :1. 2. 3.
Do a manual search of a database using a set of criteria Familiarize themselves with database tables See the relationships in the database
Answer each of the following questions using the Guinness World Records data shown in the Tut1.xls. No computer work is required. Questions 1.
Display the person who holds the most Guinness World Records.
2. List the "record title" and "when" in chronological order (i.e. from the earliest date to the most recent date.), which record has not been broken for more than 20 years.
3. Display number of guiness records held and the name of country which hold more than 3 Guinness World Records
4. Display the weight difference between heaviest birth and lightest birth .
5. Display name of main category and the number of the records by each main category.
6. Display name of main category and sub category and the number of the records by each main and sub category.
DBIS (CIM1Z01) – Tutorial 1 Introduction to Database
1
7. Display the sub category name and the title of record which include "Smallest" or "Biggest"in its record title.
8. Display the main and sub category name of the record that held by Singapore.
9. Display the country and name of person who make record attempt to "Natural World" ~end~
DBIS (CIM1Z01) – Tutorial 1 Introduction to Database
2
Do a manual search of a database using a set of criteria Familiarize themselves with database tables See the relationships in the database
Answer each of the following questions using the Guinness World Records data shown in the Tut1.xls. No computer work is required. Questions 1.
Display the person who holds the most Guinness World Records.
2. List the "record title" and "when" in chronological order (i.e. from the earliest date to the most recent date.), which record has not been broken for more than 20 years.
3. Display number of guiness records held and the name of country which hold more than 3 Guinness World Records
4. Display the weight difference between heaviest birth and lightest birth .
5. Display name of main category and the number of the records by each main category.
6. Display name of main category and sub category and the number of the records by each main and sub category.
DBIS (CIM1Z01) – Tutorial 1 Introduction to Database
1
7. Display the sub category name and the title of record which include "Smallest" or "Biggest"in its record title.
8. Display the main and sub category name of the record that held by Singapore.
9. Display the country and name of person who make record attempt to "Natural World" ~end~
DBIS (CIM1Z01) – Tutorial 1 Introduction to Database
2
Related Documents
Tut1 Introduction To Database
June 2020 15
Tut1
November 2019 7
Introduction To Hyperion Database
December 2019 20
Introduction To Database
May 2020 11
Tut1
August 2019 10