Announcements Syllabus Homework Project Slides Useful Links

- ALL-- Final Exam will be on Friday 5/10/13 at 12:30-2:30pm in our regular classroom.
- ALL-- Project part #5 and 6 are due Wed 5/1/13. registration login (you will need to be on VPN for 5&6 upload)
- ALL-- Midterm #2 will be on Friday 4/27/13.
- ALL-- Homework #8 due Monday 4/22/13.
- Link to turnin program registration login (you will need to be on VPN for 5&6 upload)
- ALL-- Homework #7 due Monday 4/15/13.
- Midterm 1 SQL answers
- ALL-- Homework #6 due Monday 4/8/13.
- ALL-- Project part #4 is due Fri 4/12/13.
- ALL-- Project part #3 due Fri 2/29/13. This project turn in will also count as homework #5.
- ALL-- Midterm #1 will be on Friday 3/22/13
- ALL-- Homework #4 solutions have been posted
- ALL-- Homework #4 due Fri 3/8/13. Please email this to facilitate our grading
- ALL-- Homework #3 due Fri 3/1/13
- ALL-- Project part #2 due Wed 2/27/13
- ALL-- Homework #2 due Wed 2/13/13
- 564-- Register for your database account here Due by Thurs 1/31/13.
- ALL-- E/R Diagrams are due Monday 2/4/13 464 564 extended to Wed 2/6/13
- ALL-- Homework #1 due Wed 1/30/13
- CS 464-- Groups are due by Monday 1/28/13

Back to beginning

Office: 349E

Office Hours: M 9:30-10:30, W 2:00-3:00, F 2:00-3:00; other times by appointment

Email: tapia@cs.unm.edu

Office Phone: 505-277-0858

Office: 301A

Office Hours: Tuesday 1:30-3:30; Friday 10:00-11:00am; other times by appointment

Email: wjust@cs.unm.edu

Week of | Topic | Reading |
---|---|---|

1/14 | Introduction; E/R Model | Chs 1, 4 |

1/21 | E/R Model; Relational Model | Chs 4, 2 |

1/28 | Functional Dependencies, Normalization | Ch 3 |

2/04 | Relational Algebra | Chs 2, 5 |

2/11 | SQL & Transactions | Chs 6, 2, 8 |

2/18 | SQL in a Webserver | Chs 9 |

2/25 | Constraints and Triggers | Chs 7, 8 |

3/4 | Data Storage | Ch 13 |

3/11 | Spring Break - No Class | n/a |

3/18 | Data Representation | Ch 13 |

3/25 | Index Structures | Ch 14 |

4/1 | Query Execution | Ch 15 |

4/8 | Query Compiler | Ch 16 |

4/15 | Coping with Failures | Ch 17 |

4/22 | Concurrency Control | Ch 18 |

4/29-5/3 | Project Presentations | n/a |

Your grade will be based on four components:

- exams 45% There will be two midterm exams and one final exam, worth 15% each
- homework 15% There will be 10 weekly assignments, typically due every Wednesday.
- project 35% There will be a significant programming project. More details are available here.
- participation 5% We will define participation during this course. Options will include: industry speakers, attendance, etc.

A for 90% or above of the total points,

B for 80 to 89%,

C for 70 to 79%,

D for 60 to 69%,

and F for less than 60%.

For the assignments in this class, discussion of concepts with others is encouraged, but

Back to beginning

- Homework assignment one: (1) Textbook page 138, Exercise 4.1.1. (2) Textbook page 138, Exercise 4.1.2 (a-d). (3) Textbook page 28, Exercise 2.2.1 (a-e, g). (3) Textbook page 171, Exercise 4.6.1.
Due: 1:00pm on Wednesday, Jan 30th

- Homework assignment two: (1) Textbook page 71, Exercise 3.1.1. (2) Textbook page 83, Exercise 3.2.2. (3) Textbook page 92, Exercise 3.3.1. (4) Textbook page 105, Exercise 3.5.1.
Due: 1:00pm on Wednesday, Feb 13th.

- Homework assignment three: (1) Textbook page 222, Exercise 5.2.1. (2) Textbook page 114, Exercise 3.6.3.
Due: 1:00pm on Friday, March 1st.

- Homework assignment four: Download your assignment here. Also, here is the sample data. Load this with phpMyAdmin in order to test your queries.
Due: 1:00pm on Friday, March 8th.

Solutions

- Homework assignment five: CREATE TABLE, INSERT, ... from Project Part 3.

- Homework assignment six: (1) Textbook page 318, Exercise 7.1.1 (a) (c).
(2) Textbook page 324, Exercise 7.2.2.
(3) Textbook page 338, Exercise 7.5.3 (a) (b).
Due: 1:00pm on Monday, April 8th.

- Homework assignment seven: (1) Textbook page 567, Exercise 13.2.1 (a) (c) (d) (e); (2) Textbook page 587, Exercise 13.4.1; (3) Textbook page 631, Exercise 14.1.1; (4) Textbook page 632, Exercise 14.1.5 (a).
Due: 1:00pm on Monday, April 15th.

- Homework assignment eight: (1) Textbook page 646, Exercise 14.2.1 (a)(b)(c); (2) Textbook page 647, Exercise 14.2.5; (3) Textbook page 659, Exercise 14.3.1 (NOTE: use the answer for part a to answer part b, b to answer c, etc.); (4) Textbook page 660, Exercise 14.3.6(a) (b).
Due: 1:00pm on Monday, April 22nd.

(solutions)

Details are available for 564 students here.

- Introduction (Lecture 1)
- E/R Diagram (Lecture 2)
- E/R Diagram to Relational Design (Lecture 3)
- FD's (Lecture 4)
- BCNF, 3NF (Lecture 5)
- 4NF (Lecture 6)
- Relational Algebra (Lecture 7)
- SELECT FROM WHERE (Lecture 8)

- More SQL (Lecture 9)
- SQL in Webserver (Lecture 10)
- Constraints (Lecture 11)
- Transactions (Lecture 12)
- Data Storage (Lecture 13)
- Representing Data Elements (Lecture 14)
- Dense and Sparse Index (Lecture 15)
- Hash Index (Lecture 16)
- B-Tree Index (Lecture 17)

- Query Processing - One Pass (Lecture 18)
- Query Processing - Two Pass (Lecture 19)
- NoSQL (Lecture 20)

- SQL injection prevention cheat sheet
- Instructions on how to connect to the CS department VPN
- Instructions on how to connect to bender from outside the CS network
- MySQL 5.1 Manual-- Data Types
- Web site
for the textbook
- William Kent's
guide to normal forms
- MySQL web page and
tutorial
- PHP Book (library)
- Writing JDBC Applications with MySQL
- JDBCDemo.txt

Announcements Syllabus Homework Project Slides Useful Links