Prerequisites

CIT 11200 or CIT 12000 or MATH-M 118 or MATH 15400 or MATH 15900

Offered

Fall, Spring

Software

Microsoft Access 2007

Oracle

Credit By Exam

Yes

Coordinator

J. Clark

Back to Course Description

Database Management Concepts

Understand the general concepts of data management
Explain basic database terminology
Compare and contrast the file management and database management approaches
Describe the advantages and disadvantages of database processing
Describe the relational model
Explain the difference between primary and foreign keys
Draw a table-relationship diagram for a database
Create a table in the current version of Access
Add, modify, and delete records in an Access table
Use relational algebra to process queries
Use QBE to retrieve data from Access tables
Use conditions, calculated fields, and built-in functions in QBE
Join tables in QBE

Using Access 2007

Create a form using Form Wizard
Create a main form with a subform
Create a report using the Report Wizard
Preview and print a report
Define multiple criteria in a query
Use AND and OR operators in a query
Create a parameter query
Create a custom form
Create a multi-page form
Create a custom report
Modify report controls
Add group and overall totals to a report

SQL

Create a table using SQL
Choose appropriate data types for SQL tables
Understand the meaning and use of nulls
Insert data into a table
Understand the format of SQL SELECT command
List the sequence of execution of the SELECT command clauses
Rename columns on output
Use simple conditions
Retrieve unique rows with DISTINCT
Use compound conditions
Use computed columns
Use LIKE, IN, BETWEEN
Sort data using ORDER BY
Sort with multiple keys and in descending order
Use the SUM, COUNT, MAX, MIN and AVG aggregate functions
Group data using GROUP BY clause
Select specific groups using HAVING
Test for nulls
Join tables
Use a subquery
Use IN and EXISTS with a subquery
Nest a subquery within a subquery
Use a table alias
Perform union, intersection and difference set operations
Use ALL and ANY
Use concatenation in a query
Create a query for a report
Change column headings and formats in a report
Add a title to a report
Group data in a report
Include totals and subtotals in a report
Send a report to a file that can be printed

Database Design

Elicit user information needs using an object-oriented approach
Represent user information needs in an object-relationship diagram
Transform an object-relationship diagram into a relational database
Explain functional dependency
Define first normal form (1NF), second normal form (2NF) and third normal form (3NF)
Determine what normal form a table is in
Transform a table into 3NF