Information Processing 10, 20, 30

(a)	Plan for the development of a relational database: determine the purpose of the database; consider the most effective organization of the database; anticipate the necessary data to include in the database; and, identify the end-user of the database.
(b)	Create a database by establishing fields (e.g., text, numbers), creating tables, setting primary keys, and defining relationships between tables.
(c)	Locate, evaluate and select data to include in the database.
(d)	Apply normalization by establishing relationships between tables in a database to eliminate redundancy and inconsistent dependency.
(e)	Share data across applications: import data from a variety of sources and in a variety of formats; extract and use data from other applications in differing file formats; and, export data from a database to use in other applications (e.g., spreadsheets, word processing documents).
(f)	Automate loading and display of objects in a database.
(g)	Apply macros to automate processes in a database.
(h)	Create and use a variety of queries (e.g., complex queries, range queries, parameter queries, queries using fields and wildcards).
(i)	Produce and modify reports (simple, grouped, summary and sub reports) following a stated layout and format.
(j)	Adjust parameters and organization of data to correct errors or solve problems in the database.
(k)	Reflect on the usefulness, accessibility and efficacy of the database.