EECS 116 Introduction to Data Management (2017-2018)

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 33 or CSE 43 both with a grade of C or better) 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
No student outcomes specified.
Course Learning Outcomes. Students will:

1. Describe the essences of data engineering and its applications to the analysis and design of engineering solutions.

2. Describe steps involved in the design of database systems.

3. Describe the use of data engineering to interpret and utilize data.

4. Describe the role of data engineering for business and other applications.

5. Describe the application of relational algebra and relational calculus.

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

February 22, 2017
Senate Approved:
June 27, 2016
Approved Effective:
2016 Fall Qtr