1 / 7

Databases Defined

Databases Defined. Databases . Defined: a collection of organised data to enable access, retrieval and processing Databases manage data by filtering to select a small set of data, eg. sorting Strengths of Databases: Powerful, efficient access to information Weaknesses of Databases:

jewell
Download Presentation

Databases Defined

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. DatabasesDefined

  2. Databases • Defined: a collection of organised data to enable access, retrieval and processing • Databases manage data by filtering to select a small set of data, eg. sorting • Strengths of Databases: • Powerful, efficient access to information • Weaknesses of Databases: • Steep learning curve involved in learning the program

  3. Databases - Structure • Field, combination of characters and is smallest unit of data a user accesses • Field name, uniquely identifies each field • Record, a group of related fields, eg. students name, address, age, etc.

  4. Databases - Structure • Form, allows the input screen to be formatted

  5. Databases - Structure • Report, result of a query in usable information

  6. Databases Structure • Macros, used to automate regular procedures and tasks • Primary key, a field uniquely identifying each record in a file, eg. Student ID no, Tax file no, etc • Flat file database, only contains one table

  7. Databases Structure • Data types: • Text, names, addresses, post codes, telephone numbers, (set to text because not performing calculations • Number or numeric fields, eg. Currency & date & time • Boolean, eg. Yes/No • Object, a document or media file • Data Formats • Having decided on field type chose format, eg. Fixed decimal places,

More Related