IEOR 115: Industrial and Commercial Data Systems

Professor: Ken Goldberg
GSI: Mo Zhou
Reader: Jack Sweeney, Sydney Huang
For Office Hours see Contact

Lecture: MW 11am-12pm, 3106 Etcheverry Hall.
Lab 12-1pm, 1-2pm, 1174B Etcheverry Hall

Course Desciption

This course is geared for IEOR juniors and seniors. Other majors are welcome to enroll however please see the Note on Registration (below).

Lectures describe how databases are designed and implemented, with an emphasis on industrial and commercial applications. We focus on the relational database model and learn the mathematics of relational algebra an Structured Query Language (SQL). In addition to homework and exams, students gain hands on experience with database software Microsoft Access in the laboratory sessions. Students work in teams to design and implement working prototype databases for local organizations.


Note on Registration for IEOR 115

Due to the size of our laboratory, the class is limited to 50 students. Priority is given to graduating IEOR seniors (who are guaranteed admission and are given course entry codes in advance).

Other students are welcome to come to the first 2 classes: since it's difficult to determine the numbers at registration time, we will give a simple entrance exam to all interested students. Don't worry about studying for this, it's not a test of knowledge but of eligibility and enthusiasm. Remaining class entry codes will be given out in the second class. I realize this is inconvenient but it's the only fair solution.

For general enrollment information please contact Anayancy Paz, the IEOR Student Affairs Officer, at:anayancypaz[at]ieor[dot]berkeley[dot]edu


Setup Guide to Install Microsoft Access

Windows

  1. Download the Office 2010 or 2013 for Windows from UC Berkeley Software-Central.
    We suggest that you keep both the downloaded file(s) and the key safe for later use.

  2. Install the office package and select Access during install.

Mac OS and others

  1. Please download and install VMware Fusion .
    Alternatively you may also download the appropriate version of Virtual Box

  2. Download Windows 8.1 and install it in the VMware fusion software. Tutorial

  3. Download the Office 2013 for Windows from UC Berkeley Software-Central.
    Note even if you downloaded Office for Mac 2011, you should be able to downloadthis one. We suggest that you keep both the downloaded file and the key safe for later use.

  4. Install the office package and select Access during install in the virtual machine.