CLICK HERE FOR BLOGGER TEMPLATES AND MYSPACE LAYOUTS »

Sunday, January 31, 2010

NEW YEAR ~

Database fun.
PAGE 44 TEXT BOOK
*Flat file data bases - Ideal for simple lists ie.... appointments diary and phone lists.
*Relational databases -Ideal for larger more complex lists. ie..Personal Records and stock inventory
For store sales and product lists for bigger companies such as woolworths it would be far to complex for a simple flat file data base to hold all records of their products. Instead of paper handouts hypermedia would be much more easier to maintain and run.
For Personal records in companies its a bit too complex to use flat file databases as theres only one table therefore there are many columns within the one table and the data is messy and harder to use. Relational databases much easier. DON'T use hypermedia, privacy issues poor security. Data Stolen, hacked, Better into files in an office.

encryption: Data coded, so unauthorized people cant read it.
for more info page 46-49.
____________
Data Dictionary (Metadata)

tell us the:
*data type - ie text, numeric
*field names
*Field Size
Sorta telling us how its built, telling us about the data.
Usually refers to a table. If you have 4 tables you have 4 Data dictionaries one for each.
PAGE 49 for more info on data dictionaries.

Inquires and hypermedia time to refresh when i get home. uftt lol actually just go through EVERYTHING from yr 11 before i die in confusion.. funny enough i have no idea what the answer is when he asks until he says it and im like ohhh i knew that! why am i sooo gaaahh >_> dont forget protocols ie file transfer protocols.

0 comments: