 |


Prescription:IC220 Databases (flat-file) |
Aim of Module | To introduce students to the concepts and functions of flat-file databases
|
Credits | 5
|
Suggested Time | 50 student learning hours
|
Prescription Expiry Date | Nov 2003
|
LEARNING OUTCOMES
The Student Will
| | | | C | 1 | Demonstrate an understanding of the basic terminology of databases, and know what data types are available. |
|
A | 2 | Complete a practical exercise to demonstrate understanding of the basic principles. |
CONTENT
| | | > | Define the following terms and concepts relative to the package being used: |
| File (Table) |
| Record (row, entity) |
| Field (column, attribute) |
| Field characteristics (name, format content) |
| File (table) structure |
| Form |
| Report |
| Table view/form view |
| Sort |
| Query |
| Filter |
|
> | Describe the purpose of data types eg Alphanumeric, Numeric, Date, Logical |
|
> | Plan and design a database for a simple problem
| top
| | | > | Complete a practical exercise(s) using a database package which involves: |
| Creating a file (table) structure requiring various data types |
| Creating a simple data-entry form |
| Adding records |
| Changing records |
| Deleting records |
| Using table and form views |
| Changing the sort order |
| Performing a simple query |
| Performing simple calculations |
| Generating and printing a report using the standard report generator with title and column headings |
| Generating and printing a report using the standard report generator with title and column headings based on a query |
| Check data and compare with original sources |
| Modify a standard report
| top
|
|
|