Information Processing 10, 20, 30
Design and present a relational database to meet a professional need or solve a business problem.
Indicators for this outcome
| (a) | Determine a problem to be solved by using a relational database and justify the use of the database to solve a particular business problem. |
| (b) | Set up tables for a relational database with appropriate fields, keys and data types. |
| (c) | Apply table and field properties (e.g., validation rules, input masks, lookups) to a relational database. |
| (d) |
Create forms to a specified design and layout:
|
| (e) | Locate, evaluate and select data to be entered or imported into the database. |
| (f) | Use consistent parameters (e.g., tags, terms, categories) when entering or importing data into a database. |
| (g) | Input and organize data (e.g., enter records, divide into tables, define fields). |
| (h) | Normalize data in a database to minimize redundancy. |
| (i) | Test the effectiveness of the database by performing operations (e.g., queries, filters, sorting) for various purposes. |
| (j) | Develop and design the interface of the database to suit client requirements as specified. |
| (k) | Create options for simple execution of complex processes (e.g., use macros to automate processes, apply appropriate protection settings) for the client. |
| (l) | Summarize data in reports using calculated fields. |
| (m) | Adjust parameters and organization of data to correct errors or solve problems in the database, or to make it more user-friendly. |
| (n) | Justify how the database meets the client’s professional need or solves the business problem. |
Loading...
