CSE 30246 - Database Concepts

Class Meeting Time

Monday, Wednesday, Friday
3:00 to 3:50
Room 120 Debartolo.

Course Instructor

Ramzi Bualuan
384 Fitzpatrick Hall
631-7388
email: rbualuan@cse.nd.edu
Office Hours: Thursdays, 2 to 4 pm; or by appointment.

Teaching Assistant:

Graduate TA: Nadine Shillingford

• email: nshillin@nd.edu
• Office Hours: Mondays and Wednesdays, 1:30 pm - 2:30 pm
• Office Location/Phone: 214 Cushing / 1-8120

Undergraduate TA: Alex Tomala

• email: atomala@nd.edu
• Office Hours: Mondays and Tuesdays, 8-10 pm, Engineering Computer Lab

Class Handouts

• Syllabus
• Project Description
• Oracle prelim
• sqlplus basics
• Tom Meurer's bio
• practice test solutions
• Prob 5 SQL solution from old test 1
• Test 2 solutions

Assignments

• Homework 1
• Homework 2
• Homework 3 - hw3, prob 1 solution
• Homework 4 - hw4, prob 2 solution
• Homework 5 - hw5 solution
• Homework 6 - hw6 solution
• Homework 7
• Homework 8
• Homework 9

Assignment Feedback

• Homework 1 (Prepared by Nadine Shillingford) - notes, summary of some databases listed as answers
• Homework 2 (Prepared by Nadine Shillingford) - notes
  

Misc

• Sale DB data
• sale report example
• Date formatting:
  • SQL Date formatting
  • PHP Date formatting