EECS 116 Introduction to Data Management (2012-2013)

EECS 116 Introduction to Data Management

(Not required for any major. Selected Elective for CpE.)
Catalog Data:

EECS 116 Introduction to Data Management (Credit Units: 4) Introduction to the design of databases and the use of database management systems (DBMS) for applications. Topics include entity-relationship modeling for design, relational data model, relational algebra, relational design theory, and Structured Query Language (SQL) programming. Prerequisite: One from CSE23/ICS 23/ICS H23 or IN4MATX 45 or ICS 33/CE43 or EECS 114 with a grade of C or better. Same as COMPSCI 122A. (Design units: 1)

Required Textbook:
. Edition, , 1969, ISBN-13 978-0073523323.

Recommended Textbook:
None
References:

None.

Coordinator:
Phillip C.-Y. Sheu
Relationship to Student Outcomes
This course relates to Student Outcomes: CAC a, CAC c, CAC j, CAC k, EAC a, EAC b, EAC c, EAC e, EAC h, EAC k.
Course Learning Outcomes. Students will:

1. Describe the essences of data engineering and its applications to the analysis and design of engineering solutions. (CAC a, EAC a, EAC e, EAC k)

2. Describe the steps involved in the design of database systems. (CAC a, CAC c, CAC j, CAC k, EAC c, EAC k)

3. Describe the use of data engineering to interpret and utilize data. (EAC b)

4. Describe the role of data engineering for business and other applications. (EAC b, EAC h, EAC k)

5. Describe the application of relational algebra and relational calculus. (CAC a, EAC a)

Prerequisites by Topic

Basics of computer systems; experience programming in at least one of C or C++. Proficient in programming and in the Windows Environment.

Lecture Topics:
  • Introduction to Database Management Systems
  • Conceptual Database Design (using E/R model)
  • Relational Database Model
  • Relational Algebra.
  • Programming in SQL
  • Relational Design Theory (normal forms, decomposition)
  • Object Oriented Databases, Object Relational Databases (time permits)
Class Schedule:

Meets for 3 hours of lecture and 1 hour of discussion each week for 10 weeks.

Computer Usage:

None.

Laboratory Projects:

None.

Professional Component

Contributes toward the Computer Engineering Topics Courses and Major Design experience.

Design Content Description
Approach:

Design content will focus on the following: Database design process. Entity/relationship model: a) Entity sets. b) Relationship sets. * c) Constraints on entity sets. d) Constraints on relationship sets. e) Weak entity sets. f) Super class/subclass relationships. g) Aggregation.

Lectures: 100%
Laboratory Portion: 0%
Grading Criteria:
  • Home work assignments: 30%
  • Midterm exam: 30%
  • Final exam: 40%
  • Total: 100%
Estimated ABET Category Content:

Mathematics and Basic Science: 0.0 credit units

Computing: 0.0 credit units

Engineering Topics: 4.0 credit units

Engineering Science: 3.0 credit units

Engineering Design: 1.0 credit units

Prepared:
October 8, 2012
Senate Approved:
February 14, 2012
Approved Effective:
2012 Fall Qtr