1 / 6

Databases

Databases. All you wanted to know and more!. What is a database?. Used to store data Consists of Fields Records Files A field consists of Field Name Field Type Field Length. Advantages on a computerised database. Easy to amend data Fast searching & sorting Allows profile building……

justin
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases All you wanted to know and more!

  2. What is a database? • Used to store data • Consists of • Fields • Records • Files • A field consists of • Field Name • Field Type • Field Length

  3. Advantages on a computerised database • Easy to amend data • Fast searching & sorting • Allows profile building…… • Retail Purchases • Criminals • Medical treatments

  4. Video Title Ctry Date Cln Star 1 A Few Good Men U.S. 1992 15 Tom Cruise 2 The Mask U.S. 1994 PG Jim Carrey 3 The Flintstones U.S. 1994 U John Goodman 4 Trainspotting U.K. 1996 18 Ewan McGregor 5 Crocodile Dundee AUS 1986 15 Paul Hogan 6 Elizabeth U.K. 1998 15 Cate Blanchett Flat File Databases • Sometimes called a traditional file database • All data held in one file • A spreadsheet can be used to hold a flat file database

  5. Problems with flat file databases • Redundant Data • Errors on input • Problems with updating data • Problems with modifying data

  6. Multiple Tables • Databases with multiple tables solve all these problems: • data independence • quality of management information • control over redundancy • consistency of data • more information available to users • greater security of data • less time spent inputting data

More Related