Search
Purdue School of Engineering and Technology

Purdue School of Engineering and Technology

Introduction to Data Management

CIT 21400 / 3 Cr. (3 Class)

Introduction to basic database development concepts. Extensive exploration of data manipulation using a relational DBMS and SQL. Students develop database applications using the most current database technologies.

Software
  • Microsoft Access
  • mySQL
Outcomes

Course Outcomes (What are these?)

  • Understand basic data management concepts (CIT a, i, j)
  • Understand the structure and methods of the relational data model (CIT i, j)
  • Create and manipulate relational databases using QBE and SQL (CIT a, c)
  • Model logical data requirements using entity-oriented techniques (CIT b, c)
  • Transform a logical data model into a relational database structure (CIT b, i, j)
  • Apply normalization techniques to a database (CIT i, j)
  • Understand the functions of a DBMS and database administration (CIT a, i, j) 

CIT Student Outcomes (What are these?)

(a) An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.

(b) An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution.

(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.

(i) An ability to use current techniques, skills, and tools necessary for computing practice.

(j) An ability to use and apply current technical concepts and practices in the core information technologies.

Topics
  • Database Management Concepts
  • Database Design
  • Query by Example
  • Structured Query Language (SQL)
Principles of Undergraduate Learning (PULs)

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

What You Will Learn

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

Database Design                       

  • Analyze user’s information needs using an entity-relationship approach
  • Represent user’s information needs in an entity-relationship diagram
  • Define first normal form (1NF), second normal form (2NF), third normal form (3NF) and fourth normal form (4NF) and determine what form a table is in
  • Transform a table into 1NF, 2NF, 3NF and 4NF when necessary
  • Transform an entity-relationship diagram into a relational database

Query by Example 

  • Use Query-By-Example (QBE) to retrieve data from Access tables
  • Relate tables using QBE
  • Use conditions, calculated fields, and built-in functions 
  • Define multiple criteria 
  • Use the logical operators 
  • Run action queries (make table, update, delete, and append) 

Structured Query Language (SQL)

  • Create tables 
  • Insert data into a table 
  • Run system catalog commands 
  • Understand the format of the SQL SELECT command
  • Write single table queries 
  • Write multiple table queries
  • Use simple conditions in queries 
  • Use compound conditions in queries
  • Use computed columns in queries 
  • Use the SUM, COUNT, MAX, MIN and AVG aggregate functions in queries 
  • Use a subquery 
  • Perform union, intersection and difference set operations in queries 
  • Create views 
  • Apply some of the administrative commands (Grant, Revoke, and Index)