Databases

=3.7 Databases=


 * //Database organization //**

Table - **Finlay**

Field, data types, key field/primary key, secondary key, foreign key - **Finlay**

Record - **Finlay**

Flat-file database, Relational Database, Normalization (first normal form only) - **Raheel**

Database Management System (DBMS) Eg. SIMS (School Information Management System) - **Isaac**

Specialized databases for example: web databases, online encyclopedias - **Isaac**


 * //Functions & practical techniques //**

Data Validation: data types, range check, check digit, field size, input mask, drop down list - **Daniel**

Queries: for example: searching, sorting, filtering, Boolean operators (AND, NOT, OR) - **Guy**

Data entry forms - **Rusteen**

Report generation - **Rusteen**

Macros – creating and editing simple macros - **Chirag**

Transfer of data between databases and other applications (eg. Import, export, .csv files) - **Chirag**

Mail Merging - **Raheel**

Data Maintainance - changing, editing, deleting records - **Daniel**


 * //Data storage and access //**

Data integrity, data reliability, data redundancy - **James**

Data matching, data mining - **Guy**

Database security - **James**