Data types

Query #3

This query has selected all the products with a unit price less than $20 with units in stock. This was done through dragging dragging "Product name", "Unit price", and "Units in Stock" in the field row and ">20" in the criteria row in the unit price column

Query #2

This query has selected has selected all the products with a recorder level of "10" with a unit price. This was done through dragging the titles "Product name", "Unit Price", and "Recorder Level" in the field row and the numeric value "10" in the criteria row of the recorder level column.

Query #1:

This query has selected all the names of Products that cost $10. This was done through entering the numeric value "10" into the criteria row in the unit price coumn.

Another Value:

This query has selected all the names of Products that cost $15. This was done through entering the numeric value "15" into the criteria row in the unit price coumn.

Creating a basic database

This is the basic database I created usigng Microsoft Access 2007

Querying the database:

This is a result of a query which searched the Date of Birth of all people in the database

Types of Databases

- Telephone address book
- I-tunes
- School
- Search engines e.g. google, bing etc.
- Social Networking Sites
- Library database
- School Database

Music Database Example

In this Example Shown above the table itself is a record, the artist name, album, song title, genre are all fields. 

Data Type

In programming, classification of a particular type of information. It is easy for humans to distinguish between different types of data.  We do this through special symbols -- %, :, and $ -- that indicate the data's type. Similarly, a computer uses special internal codes to keep track of the different types of data it processes.
Examples:
- Alpha-numeric text
- numeric

Data Dictionary

In database management systems, a file that defines the basic organisation of a database. A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field. Data dictionaries do not contain any actual data from the database, only bookkeeping information for managing it.

DBMS

Database management systems is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications.

Report

A formatted and organized presentation of data. Most database management systems include a report writer that enables you to design and generate reports.

Database

A collection of information organized in such a way that a computer program can quickly select desired pieces of data. A database is an electronic filing system.

Query

to  request for information from a database. There are three general methods for posing queries: - Choosing parameters from a menu: In this method, the database system presents a list of parameters from which you can choose. This is perhaps the easiest way to pose a query because the menus guide you, but it is also the least flexible.
- Query by example (QBE): In this method, the system presents a blank record and lets you specify the fields and values that define the query.
- Query language: Many database systems require you to make requests for information in the form of a stylized query that must be written in a special query language. This is the most complex method because it forces you to learn a specialized language, but it is also the most powerful.

File

Fields of information that is put together. For example in a database of a school every sudent would have a file consisting fields of information like their phone number etc.

Records

In database management systems, a complete set of information. Records are composed of fields, each of which contains one item of information. A set of records constitutes a file. For example, a personnel file might contain records that have three fields: a name field, an address field, and a phone number field.

Fields

A space allocated for a particular item of information. A tax form, for example, contains a number of fields: one for your name, one for your Social Security number, one for your income, and so on. In database systems, fields are the smallest units of information you can access. In spreadsheets, fields are called cells.
Fields make up records. Records make up fields.

Disadvantages of Databases

- Invasion of Privacy
- Usually relies upon Internet access
- Remote Acess
- disadvantaged
- elderly

Advantages of Databases

- Faster
- Reliable: Easily to update
- Easier to search: more elaborate, any category, multiple categories,  
- Saves Space
- Convenient
- Better Access, Distrubition
- Can be duplicated
-

Yellow Pages Activity

1. 122 Katoomba St, Katoomba NSW 2780
2. 91a Fowler Rd, Merrylands NSW 2160

3. Hotel Laguna

6 Hastings St, Noosa Heads QLD 4567

ph: (07) 5447 3077 

 Noosa Heads Motel

71 Noosa Drv, Noosa Heads QLD 4567

ph: (07) 5440 4550

 

Yellow Pages/White Pages

WolframAlpha database

Wolfram Alpha is an answer-engine in which you type a question it answers any question directly rather than it providing a list of documents and web pages that answer the question like a search engine for example google