1.3 Databases

The definition of a database is an organized store of records. A database can store all sorts of information that we deal with in our day to day lives. Some examples of that are databases for income levels, shopping patterns, features on a car etc. We have all seen or dealt with databases in our lives, can you name some?

A database record is a set of data that is treated as a unit.
A record is usually divided into fields, that give more specific or narrow down the information

For example. The phonebook is a data base
A record of this database is an individual person
A field of the record (or a field of each person) is given by the telephone number itself, the initials, or even the address.

This database is stored by alphabetical order, as are many databases.

This video is also a database, it is on an ipod and is a database of bars and clubs.

Another example of a database is the inventory lev
els at a retail clothing store. This database contains the inventory levels of the clothing. You can search this database usually by a style code that is given on the garment itself. The database will tell you how many you have of that style in a specific size, and even in a different color. You can see how databases can make life easier because instead of looking endlessly for a item that you don’t have, you can tell right away if you have it or not.

Another example of a database is the site that we are using for our culminating project, called e stat. This is a database of all sorts of wonderful information. It is also known as statistics Canada, and it is a federal government department responsible for collecting, summarizing, analyzing, and sorting data relevant to Canadian demographics, education, health, and etc.

ssc_fixed_database_roles_002.jpg
Another example of a database is the database we use in the library. This database gives us the availability of certain books, how many, how long they’ll be on hold for, the author’s name, which branch location they are in and etc. This is useful when you are looking for a specific book, it helps you to find it easily. So as you can see databases are useful in our everyday lives because it helps us find things really quickly and easily, if the database is good and organized.

So a good question to answer is which of the following are databases?
a) dictionary
b) stock market listings
c) catalogue of car specs
d) credit card records
e) an essay of hamlet
f) a teacher’s mark book
g) Guinness book of world records.
h) List of book on your bookshelf.

A, b , c, d, f, are all good examples of databases. An essay on hamlet isnt a database because it is not an organized store of data. Same with g and h. For some more questions try the rest on page 31.

Comment:
BY: Osman Osman

Good job man, i like the video you have included,…. although it's not working

And again good job….
Peace *__*

by: Bridget
good jobs guys, i really enjoyed the videos and the info was really
helpful=)

by: daniella
as everyone said, the videos were a nice touch to the notes, really helpful and kept it interesting

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.