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