EECS 116 Introduction to Data Management (2013-2014)

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: I&C SCI 23 or CSE 23 or I&C SCI H23 or I&C SCI 46 or CSE 46 or IN4MATX 45 or I&C SCI 33 or CSE 43 or EECS 114 . School of Information and Computer Sciences majors and Computer Engineering majors have first consideration for enrollment. Same as COMPSCI 122A. (Design units: 1)

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

Recommended Textbook:


Phillip C.-Y. Sheu
Relationship to Student Outcomes
This course relates to Student Outcomes: CAC a, EAC a, EAC b, 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. (EAC b)

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

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:


Laboratory Projects:


Professional Component

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

Design Content Description

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

May 9, 2013
Senate Approved:
July 25, 2013
Approved Effective:
2013 Fall Qtr