Database Questions

1. What is a database? An organized body of related information.

 

2. What is the most important function of a database? To organize                  

3. What are the advantages of using a database? Quicker access to data

·        Reduction in data redundancy

·        Easy information tracking and cross-referencing

·        Conversion of raw data into meaningful information

·        Automated routine information management tasks

·        Automatic update of related information

·        On-line access to data through Internet

 

4. The table below contains data about some books in a library.  What other data might be    included in a library’s database about its books?

·        Number of copies in store

·        Number of copies borrowed

·        When brought in store

 

 

BookID

Author

Title

Publisher

222334

Grisham

The Brethren

Arrow

232145

Rowling

Harry Potter

Bloomsbury

218934

Moon

Discover Australia

Random House

 

 

5. What items of data would be relevant for a database in a supermarket?

·        Barcode

·        Number of products left

·        Number of products bought

·        Type of product

 

6. You would expect a video hire shop to have a computerized database.  What is the advantage of this from the owner’s viewpoint?  How would it benefit the customer? It would be very easy as the owner would just need to check on the computer if he’s got the movie and the number of copies left.

 

7. How would you find out about available flights to Europe for the next school holidays?  You would be able to find out about available flights by going to websites that have flight accommodation like flight centre. To find out flights you would see their database.

Advertisement

Leave a Comment

No comments yet.

Comments RSS TrackBack Identifier URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.