Information Technology 304

ITEC 304: Database from the Manager's Perspective.

Prerequisites: None

Credit Hours: (3)

An examination of enterprise database management systems and reporting tools from the user/manager perspective.   Emphasis is on data gathering, data organization, data retrieval, data integrity, and security.  Database systems for transaction processing and data warehousing are compared and contrasted.  Reporting, data mining, and decision support systems are introduced.

Note(s): Students that have earned credit for ITEC 340 cannot subsequentlyearn credit for ITEC 304.  Students may not take ITEC 304 and ITEC 340 concurrently.  ITEC 304 may not be used to satisfy a BS requirement or technical elective for students majoring in any of the ITEC concentrations.

Detailed Description of Content of Course

Topics include:
1. Introduction
    a. The need for and value of persistent data
    b. Database Management Systems Defined
    c. Transactional databases vs. data warehouses
    d. Data warehousing vs. data mining
    e. Ethical and Security Considerations

2. Using a Database
    a. Elements of a relational database
    b. Query Languages
        i. Query By Example (QBE)
        ii. Structured Query Language (SQL)
        iii. Query by Dialogue
    c. Adding, changing, and deleting data

3. Fundamentals of Database Design
    a. Separating data from process
    b. Entity Relationship Diagrams
    c. Dealing with data redundancy
    d. Enforcing integrity and business rules
    e. The importance of design, getting design assistance

4. Reporting Tools
    a. The need for reporting tools, popular products
    b. Tabular report production
    c. Customizing a tabular report
    d. Form based reports
    e. Web Portals

5. Basic Forms
    a. Forms generation vs. full application development
    b. Basic form creation and use

6. DSS, Data Warehousing and Data Mining
    a. Business Intelligence:  the business value of data
    b. Decision Support Systems
    c. The data warehouse defined, difference with transactional database
    d. ETL process and its importance
    e. Data Mining defined
    f. Common Tools
    g. Basic mining examples

7. Enterprise vs. Personal Databases
    a. Understanding the difference between enterprise level and personal databases

Detailed Description of Conduct of Course
Course delivery methods will include classroom lectures, discussion, group work, and examples.

Goals and Objectives of the Course

Students who complete the course will be able to:  
1. Discuss the role of database management systems in the enterprise.
2. Identify the basic constructs of a relational database.
3. Formulate and execute queries that answer specific questions using QBE, SQL, and QBD interfaces.
4. Demonstrate the ability to design simple database schemas that avoid data redundancy and employ correct data types.
5. Discuss the implications of poor database design.
6. Identify the ways in which data integrity and business rules are enforced in a database.
7. Generate basic tabular and form based reports based on data in a relational database.
8. Distinguish between transactional databases and data warehouses and between data warehousing, data mining, and decision support systems.
9. Give examples of situations where DSS and data mining tools should be used.
10. Describe how they would approach a data mining opportunity, set up the related tasks, and identify tradeoffs between different data mining techniques.
11. Discuss the differences and implications of those differences between enterprise level and personal databases.

Assessment Measures

At least two tests will be given.  Students will also complete a series of homework assignments.  Quizzes, papers, and presentations may also be used.

Other Course Information


Review and Approval

Oct 22, 2008         Initial Approval    Art Carter, Dept Chair

Revised: June 1, 2012