Purdue School of Engineering and Technology

Purdue School of Engineering and Technology

Systems and Database Analysis

CIT 37400 / 3 Cr. (2 Class, 2 Lab)

Intensive exploration of application and database analysis in a synergistic environment. Students engage in collaborative, project-based activities to learn about project management, requirement analysis, modeling, and prototyping employing problem solving and team building skills. Object-oriented and data modeling tools are used to apply class concepts.

  • Varies

Course Outcomes (What are these?)

  • Utilize information gathering techniques to determine the requirements of the problem to be solved (CIT b)
  • Apply data, process, and object modeling techniques (CIT i)
  • Integrate the processes of analysis and modeling within a semester project (CIT k)
  • Develop well-formed logical and conceptual database designs (CIT b)
  • Prototype and document an acceptable solution to a problem (CIT f, k)
  • Apply project and team management skills (CIT d, n)

CIT Student Outcomes (What are these?)

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

(d) An ability to function effectively on teams to accomplish a common goal.

(f) An ability to communicate effectively with a range of audiences.

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

(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.

(n) An ability to assist in the creation of an effective project plan

  • Agile Project Management
  • Information Gathering
  • Team and Interpersonal Skills
  • Communication Skills
  • Object & Process Modeling
  • Project Repository
  • Application Prototyping
Principles of Undergraduate Learning (PULs)

1a. Communicate effectively in a variety of formats, particularly written, oral, and visual formats.

2. Critical Thinking

3. Integration and Application of Knowledge

4. Intellectual Depth, Breadth, and Adaptiveness

5. Understanding Society and Culture

What You Will Learn

Agile Project Management

  • Explain what project management is and why it is important
  • Explain the importance of organizing the project effort
  • Create a project charter
  • Manage Scrum cycles & the backlog

Information Gathering 

  • Sample existing documentation, forms, and files
  • Create good user stories

Team and Interpersonal Skills

  • Explain the four stages of team formation
  • Describe the characteristics of effective teams
  • Discuss and apply conflict management techniques
  • Conduct behaviorally-anchored peer reveiws

Communication Skills

  • Explain the importance of knowing the audience prior to communicating to those individuals
  • Plan and conduct an effective meeting
  • Plan and conduct an effective presentation
  • Prepare a report to communicate information about a systems development project

Object and Process Modeling

  • Develop a logical data model using objects
  • Transform object model into relational data model
  • Create activity diagrams
  • Create a test plan 

Project Repository

  • Defend the need for a project repository
  • Effectively use a project repository 

Application Prototyping

  • Use application generator tools to create user views and interfaces