Database Definitions

1. DEFINITIONS

1.       Field: Categories/Classifications in a database.

2.      Record: Anything providing permanent evidence of or information about past events.

3.      File: Record in a public office or in a court of law.

4.      Query: Putting together questions.

5.      Database: A database is a collection of data for one or more multiple uses. One way of classifying databases involves the type of content.

6.      Report: A written document describing the findings of some individual or group.

7.      DBMS: Database management system: a software system that facilitates the creation and maintenance and use of an electronic database

8.      Data Dictionary: A centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format. It helps build a database.

9.    Data Type: A classification identifying one of various types of data, as floating-point, figure, or Boolean, stating the possible values for that type, the operations that can be done on that type, and the way the values of that type are stored.

2.  File, Record and Field

3. Common databases:

• RTA database- Its got all the drivers details such as their name, phone number, address etc.
• Hospital database- The hospital database has all it's patients personal details (i.e. name, address, medical history etc.)
• School databse- The school's database has got information about the students that go to the school...they have details such as name, d.o.b, phone number, their grades throughout their school life etc.
• Library databse- Its got details about all the people registered with the library so that they can track them down if the need be. The details may include name, library card number, books/cd borrowed, phone number etc.
• Council database- The council database has information on everyone living in that area. Information may include the person's name, address, phone number etc.

Using databases

What is a database?

A database is an organized body of related information. It’s a collection of data for one or more multiple uses.

Example of Databases:

The common databases used around us include:

·         RTA- it has all the information about all the drivers registered with RTA.

·         School database- It’s got all the information about the students at the school (i.e. name, address, phone numbers etc.)

·         Hospital’s database- The hospital database has its patient’s records and personal details such as their name, phone number, address, their medical history etc.

·         Library’s database: If you’ve registered at a library it will have all your details which may include the usual. (i.e. your name, address, phone number, email address etc.)

What’s different about wolfram alpha and its limitation?

The different thing about wolfram alpha is that it doesn’t give links to other websites like Google or other search engines. The limitation with wolfram alpha is that it does not have information about everything like some of the other search engines. It only gives information stuff related to calculations such as physics, trigonometry etc.                                   

New Blog!

Hi, this is my second year of IST and my new blog for year 10.

This is my first post!

I hope to learn to new things this year in IST =]