INF2070 Database 2

Intermediate · 1 credit · BIT - Business, Admin, Finance and IT

Description: Students expand their skills in the proper use of a database management system by developing relational databases and demonstrating their use in personal and business applications.
Prerequisite: None
Parameters: Access to appropriate computer equipment, a database management system that supports relational databases and support materials. Students should have prior understanding of using a flat-file database.
Supporting courses: INF1050: Database 1

Outcomes The student will:

1 create and structure relational databases
- 1.1 define data needs and types for multiple tables within a database
- 1.2 plan and design the structure of the database and the necessary relationships
- 1.3 define and print table relationships
- 1.4 add, set, change and remove primary keys
- 1.5 define and modify multifield primary keys
2 create and format database elements
- 2.1 create several tables within a database
- 2.2 identify fields and modify their properties; e.g., location, name, type, size, format
- 2.3 link tables and fields
- 2.4 apply data normalization rules
- 2.5 create forms using several methods, e.g., layout and design view, including:
  - 2.5.1 multi-item forms
  - 2.5.2 split forms
  - 2.5.3 subforms
  - 2.5.4 PivotTable forms
- 2.6 demonstrate appropriate format specifications and layout to create appropriate reports
- 2.7 add and modify controls and properties to reports and forms
- 2.8 import data from other files or sources
3 enter, modify and organize data
- 3.1 access data and define problems; e.g., manage information, make decisions
- 3.2 input and process data including:
  - 3.2.1 create template files
  - 3.2.2 enter data into files
  - 3.2.3 update and edit data in files
- 3.3 link one or more databases
- 3.4 sort and filter data within several database elements; e.g., tables, queries, forms, reports
- 3.5 create and modify calculated fields and aggregate functions
4 create and modify queries
- 4.1 create a query from single and multiple tables
- 4.2 save a filter as a query
- 4.3 modify a query by:
  - 4.3.1 adding and removing tables
  - 4.3.2 creating a calculated query field
  - 4.3.3 adding an alias to a query field
  - 4.3.4 creating aggregated queries
  - 4.3.5 adding criteria to find:
    4.3.5.1 selected records that meet several conditions
    4.3.5.2 selected records that do not match a specific condition
5 manage, present and share data
- 5.1 identify object dependencies
- 5.2 view objects and object data in other views
- 5.3 create and modify charts
- 5.4 save database objects as another file type
- 5.5 print database objects
- 5.6 export data to another source from database elements
- 5.7 present a database in another format; e.g., Web page, data access page
- 5.8 compact and repair a database
- 5.9 analyze data to draw conclusions and make recommendations
6 apply consistent and appropriate work station routines
- 6.1 demonstrate good health and safety; e.g., posture, positioning of hardware and furniture
- 6.2 employ practices that provide security for hardware, software, supplies and personal work
7 demonstrate basic competencies
- 7.1 demonstrate fundamental skills to:
  - 7.1.1 communicate
  - 7.1.2 manage information
  - 7.1.3 use numbers
  - 7.1.4 think and solve problems
- 7.2 demonstrate personal management skills to:
  - 7.2.1 demonstrate positive attitudes and behaviours
  - 7.2.2 be responsible
  - 7.2.3 be adaptable
  - 7.2.4 learn continuously
  - 7.2.5 work safely
- 7.3 demonstrate teamwork skills to:
  - 7.3.1 work with others
  - 7.3.2 participate in projects and tasks
8 identify possible life roles related to the skills and content of this cluster
- 8.1 recognize and then analyze the opportunities and barriers in the immediate environment
- 8.2 identify potential resources to minimize barriers and maximize opportunities