EECS 116 Introduction to Data Management (2016-2017)

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:
None
References:

None.

Coordinator:
Phillip C.-Y. Sheu
Relationship to Student Outcomes
No student outcomes specified.
Course Learning Outcomes. Students will:
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:
August 5, 2016
Senate Approved:
June 27, 2016
Approved Effective:
2016 Fall Qtr