Lecture Notes: ICS 321 Course Organization

---

What you will learn in this course

How to

• think about data management problems

• use a DBMS to manage data

• query data using SQL

• model data

• program database-backed applications

Why are these skills important ?

• Database-related jobs pay well!
  • Database Administrator Salaries

• All IT-related jobs will most likely require some data management skills

• Database technology is behind almost all internet technology/applications.

---

Rhythm of the Course

• Read the assigned readings BEFORE each class

• Take the quiz before every class on Laulima.

• Attend and participate in class:
  • Summary lecture with Q & A (20mins).
  • In-class exercise (55mins). Sometimes group-based. Sometimes on the computer.
• Start early and do the homework assignments:
  • Java programming assignment
  • SQL Queries
  • Data modeling using Entity-Relationship models
  • Simple database-backed web application

• Start early and work on the project.

• Take the Exams: mid-term & final. (Not cumulative).

• Take charge of the learning process
  • Try out the commands on the DBMS
  • Practice on the exercises in the textbook
• Focus on understanding the material to the point where you can apply it in different contexts.

---

Prerequisite Equipment, Skills & Knowledge

• Set Theory (ICS141)

• Propositional logic (ICS141, ICS111)

• Be able to write a Java program (ICS111, ICS211)

  • Use an editor or IDE to edit java code
  • Compile and run java programs

• Basic Unix Shell commands

• Have access to a computer

• Internet access

---

Software Setup

• Java JDK 8

• MySQL/MariaDB DBMS. Details in the Experience Installing DBMS

---

Assignment 1: Querying Large Files

Input

A CSV data file

1,3691,O,194029.55,1996-01-02,5-LOW,Clerk#000000951,0,  
2,7801,O,60951.63,1996-12-01,1-URGENT,Clerk#000000880,0,    
3,12332,F,247296.05,1993-10-14,5-LOW,Clerk#000000955,0,  
4,13678,O,53829.87,1995-10-11,5-LOW,Clerk#000000124,0,

AND a list of queries

Load order.csv   
SearchEq 3  F  
SearchGtr   4  200000   

Output
SearchEq 3 F
returns
3,12332,F,247296.05,1993-10-14,5-LOW,Clerk#000000955,0, while
SearchGtr 4 200000
returns
3,12332,F,247296.05,1993-10-14,5-LOW,Clerk#000000955,0,

Constraint

Data is too big to fit into memory.