Thursday, February 26, 2009
Querying A Database
What sort of information has the query selected?
The information that has been collected by the query is all my "contacts" that had the postcode 2145, was collected.
What sort of information has this second query selected?
The second query colled all postcode that were within my table with 2146, and highlited them to make it easier to see
The information collected within a query helps to enable the person who is updating/ maintaining the database, to be able to use a small amount of information to be able to locate all the persons within this criteria.
The information that has been collected by the query is all my "contacts" that had the postcode 2145, was collected.
What sort of information has this second query selected?
The second query colled all postcode that were within my table with 2146, and highlited them to make it easier to see
The information collected within a query helps to enable the person who is updating/ maintaining the database, to be able to use a small amount of information to be able to locate all the persons within this criteria.
Thursday, February 5, 2009
Database Definitions
Provide a basic definition for each of the following terms;
Field: somewhere (away from a studio or office or library or laboratory) where practical work is done or data is collected
Record: anything (such as a document or a phonograph record or a photograph) providing permanent evidence of or information about past events
File: a set of related records (either written or electronic) kept together
Query: Inquiries that are performed about transactions, databases, or other records
Database: A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model.
Report: a written document describing the findings of some individual or group
DMBS:database management system: a software system that facilitates the creation and maintenance and use of an electronic database.
Database dictionary:A database that contains definitions of all data items defined during analysis.
Data type: a classification or category of various types of data, that states the possible values that can be taken, how they are stored, and what range of operations are allowed on them
Field: somewhere (away from a studio or office or library or laboratory) where practical work is done or data is collected
Record: anything (such as a document or a phonograph record or a photograph) providing permanent evidence of or information about past events
File: a set of related records (either written or electronic) kept together
Query: Inquiries that are performed about transactions, databases, or other records
Database: A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model.
Report: a written document describing the findings of some individual or group
DMBS:database management system: a software system that facilitates the creation and maintenance and use of an electronic database.
Database dictionary:A database that contains definitions of all data items defined during analysis.
Data type: a classification or category of various types of data, that states the possible values that can be taken, how they are stored, and what range of operations are allowed on them
Sunday, February 1, 2009
Database Activity: The Yellow Pages
What is a database?
A database is a structured collection of records or data. A computer database relies upon software to organize the storage of data. en.wikipedia.org/wiki/Database
Examples of Databases
An example of a data base is:
Yellow Pages Challenges
1. I know there is a computer shop in the main street of Katoomba (Katoomba St.), but I don’t know its name. See if you can find the number for me.
Blue mountains business machines
99 KatoombaSt
Katoomba
NSW,
2780
Australia
ph: 02 4782 2333
1. Sally lives in Merrylands on Fowler Rd. and she wants to know the closest florist to where she lives. Help her out (see if you can get her a map).
M& A fresh cut flowers
91a Fowler Rd
Merrylands NSW
2160
ph: (02) 9892 1564
3. You want the phone numbers of some motels in Noosa QLD. But of course your phone book only has NSW numbers?
6 Hastings St Noosa Heads QLD 4567ph: (07) 5447 3077
Welcome
Heyy all and welcome to the beginging of my 2009 bloggs!!!!! This is the first of many IT posts!!!!
stay tuned
Jess
stay tuned
Jess
Subscribe to:
Comments (Atom)
