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

What you will learn

Description

Introduction to basic database development concepts. Extensive exploration of data manipulation using a relational DBMS and SQL. Students develop database applications using MS Access and SQLPlus.

Textbook

Pratt, A Guide to SQL, 8th edition, Course Technology, 2009, ISBN 9780324597684

Adamski & Kathy T. Finnegan, New Perspectives on Microsoft Office Access 2007, Comprehensive, Course Technology, 2007, ISBN 142390589X

Pratt, & Adamski, Concepts of Database Management, Sixth Edition, Course Technology, 2007, ISBN 9781423901471

Course Outcomes

• Understand basic data management concepts (CIT 1, 9)
• Understand the structure and methods of the relational data model (CIT 1, 9)
• Create and manipulate relational databases using DBMS and SQL (CIT 1, 3)
• Model logical data requirements using object-oriented techniques (CIT 2, 3)
• Transform a logical data model into a relational database structure (CIT 3, 9)
• Apply normalization techniques to a database (CIT 3, 9)
• Understand the functions of a DBMS and database administration (CIT 1, 9)

CIT Program Outcomes (What are these?)

1. Demonstrate mastery of core computing and mathematical concepts.

2. Analyze user needs and identify the computing requirements appropriate to an IT solution.

3. Plan, design, implement, and evaluate IT-based projects and systems to meet desired needs.

9. Use current technical concepts, techniques and practices in the information technologies within the student"s area of expertise.

Principles of Undergraduate Learning (What are Principles of Undergraduate Learning?)

1b. Identify and propose solutions for problems using quantitative tools and reasoning.

1c. Make effective use of information resources and technology.

2. Critical Thinking

3. Integration and Application of Knowledge

4. Intellectual Depth, Breadth, and Adaptiveness

Topics

• Database Management Concepts
• Using Access
• SQL
• Database Design

Assessment

• Exams (2)
• Assignments (3)
• Access Labs, Quizzes, Homework, and Group Work