CMIS 255 - Microcomputer Database Applications

4 Credit: (4 lecture, 0 lab, 0 clinical) 4 Contact Hours: [CMIS 115 ]

1. Explore impact of Database Management System.
2. Outline background and theory behind database design.
3. Describe database structures and terminology.

Goal 2:  Develop databases using relational design.

1. Design database queries.

1. Simple, compound, calculated fields, grouping and sorting.
2. Table joins, update, delete, make-table.
3. Function of the QBE method, determination of statistics.

1. Construct queries using appropriate relational algebra.
2. Employ the use of integrity rules.

1. Entity, referential, legal-values.

1. Define the data base structure.

Goal 3:  Create databases using defined design methodology.

1. Optimize database design using normalization.
2. Identify design in first through fourth normal form.
3. Define functional dependency.
4. Apply appropriate primary key definitions.
5. Construct entity-relationship diagrams.
6. Create appropriate data indexes.

Goal 4:  Create database reports.

1. Design reports based on tables or queries.
2. Apply multi-table methods for report design.
3. Customize reports to include calculated controls.
4. Construct reports which incorporate graphics.

Goal 5:  Develop database forms.

1. Create forms using single and multi-table/query designs.
2. Apply custom controls to a form design.
3. Use graphics to enhance form appearance.
4. Design forms with embedded subforms.

Goal 6: Develop procedures for database vulnerability.

1. Identify security issues within the database design.
2. Illustrate data recovery procedures.