Query!

with the help of sheenal today i was able to start the query thing. :)

this is the first one: a) Postcode of 2145 or 2146.

MINI PROJECT! Social Issues Related To Database

Our group: Sheenal, jhalak, and me !

we are going to be doing Credit rating. i will be doing the first two, provide a definition annd how are databases invloved in this topic

jhalak- 3 and 4 Describe the type of data stored about individuals in relation to this topic and
Describe some of the ways in which this data can be misused.

Sheenal- 5 and 6
What are the ethical responsibilities of those maintaining the database? and
What are the legal responsibilities of those maintaining the database?

Creating a Basic Database

i have finally finished making my database, after 3 tries!!!

first time i didnt know where i saved it, the second time i didnt save it to my s-drive and lucky third time i got it!!!

database definition

This is a simple activity whereby you can demonstrate your grasp of terms commonly used when referring to databases. Sites such as http://www.webopedia.com/ will be very useful in completing this activity.

Provide a basic definition for each of the following terms;

FIELD: a space allocated for a particular item of information.
RECORD: information about something in a data management system, this information is sorted into fields.
FILE: a collection of information that has a name, called filename. Can come in different forms: data files, text files, program files and directory files.
QUERY: make a request for information from a database.
DATABASE: A collection of information organized into fields that a computer program can quickly select desired pieces of data.
REPORT: A formatted and organized presentation of data.
DBMS: database management system,
A collection of programs that enables you to store, modify, and extract information from a database.
DATA DICTIONARY: A description of each field in a database.
DATA TYPE: the different type of data entered into a data base

Illustrate, with the aid of a table or diagram, what is a file, record and field. Use the example of a database of music containing album titles, song titles, artists, genre etc.

List as many commonly used databases as you think of – you should be able to come up with at least five. school records, doctor's patients records, library catalogue, contact list on a mobile, street directory.

Database Activity: The Yellow Pages

What is a database? A collection of data, stored on a computer medium, that can be used for reporting, segmenting targets, or exporting lists
Lets try using the define feature in google……enter “define: database” into the search criteria. After discussing various definitions in class, record the one which is most meaningful to you.

Examples of Databases: phone book, contact list on a phone.
Given your above definition what would be some examples of commonly encountered databases

Open your browser at the following address.
www.yellowpages.com.au

Use the website to answer the following problems.

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. To find the computer shop I used the sort button on the left hand side of the page. Typed in the information I have and then lists of shops come up.
2. 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). To find the closest flower shop on the yellow pages you have to click the ‘sort by distance from me’ and the one closest to Fowler Rd or on Fowler road will appear on the top of the list.
3. You want the phone numbers of some motels in Noosa QLD. But of course your phone book only has NSW numbers? Use yellow pages on the internet and then type in a Queensland place.
4. Just for fun try the white pages and see if you can find a map of you or your friends house.
Is the yellow/white pages a database? Give reasons for your answer. Yes, because it stores data, and has fields so people can find info easier.
¨ What can you see as some of the advantages of using this electronic database compared to the conventional paper based version of the yellow pages? Its faster
¨ Do you see any dangers or disadvantages in this online version of the yellow pages? People could track your information and then found your address.