CET 415: Database Design with Lab

Professor: Ricky J. Sethi

Course Description

This course provides hands-on experience with Structured Query Language (SQL), and relational algebra and calculus, required for implementing and accessing a relational database. Database creation, access and maintenance are covered through applications that embed SQL queries in a high-level language like Visual C/C++ or Java or a web application program like PHP

Texts and Materials

Required:

Database Processing: Fundamentals, Design, and Implementation by David Kroenke
© 2005 Prentice Hall, 10^th Edition

Recommended:

• MySQL Reference Manual
• MySQL & PHP Cheat Sheets
• SQL Tutorial Site

Suggested:

• Database Design with UML and SQL by Tom Jewett

References:

• Quick MySQL via PHP Summary
• Quick MySQL Usage Guide
• SQL Reference & Tutorial
• ERD Intro
• Great SQL Tutorials

· 

Lecture Notes

• Chapter_01

• Chapter_02

• Chapter_03

• Chapter_04

• Chapter_05

• Chapter_06

• Chapter_07

• Chapter_08

• Chapter_09

• Chapter_10

• Chapter_11

• Chapter_12

• Chapter_13

• Chapter_14

• Chapter_15

• Course_intro

• Midterm_review

• Threaded_discussion_ch1

• Threaded_discussion_ch10

• Threaded_discussion_ch11

• Threaded_discussion_ch12

• Threaded_discussion_ch13

• Threaded_discussion_ch14

• Threaded_discussion_ch15

• Threaded_discussion_ch2

• Threaded_discussion_ch3

• Threaded_discussion_ch4

• Threaded_discussion_ch5

• Threaded_discussion_ch6

• Threaded_discussion_ch7

• Threaded_discussion_ch8

• Threaded_discussion_ch9

• Threaded_discussion_intro

• Week_00_reading

• Week_01_intro

• Week_01_reading

• Week_02_intro

• Week_02_reading

• Week_03_intro

• Week_03_reading

• Week_04_intro

• Week_04_reading

• Week_05_intro

• Week_05_reading

• Week_06_intro

• Week_06_reading

• Week_07_intro

• Week_07_reading

• Week_08_intro

• Week_08_reading

• Week_09_intro

• Week_09_reading

• Week_10_intro

• Week_10_reading

• Week_11_intro

• Week_11_reading

• Week_12_intro

• Week_12_reading

• Week_13_intro

• Week_13_reading

• Week_14_intro

• Week_14_reading

• Week_15_intro

• Week_15_reading

Lab Notes

• AbriaMerlin-installation-guide-windows

• AbriaMerlin

• Ecom

• NorthWind_modified

• NorthWind_original

• Lab_01

• Lab_01_ans

• Lab_02

• Lab_02_ans

• Lab_03

• Lab_03_ans

• Lab_04

• Lab_04_ans

• Lab_04_ans

• Lab_04_ans_old

• Lab_05

• Lab_05_ans

• Lab_06

• Lab_06_ans

• Lab_07

• Lab_08

• Lab_08_ex1_ans

• Lab_08_ex2_ans

• Lab_08_ex2_ans

• Lab_08_ex3_ans

• Lab_08_ex3_ans

• Lab_08_ex4-5_ans

• Lab_09

• Lab_09_ans

• Lab_10

• Lab_10_ans

• Lab_10_ex1_ans

• Lab_10_ex1_ver1_ans

• Lab_10_ex1_ver2_ans

• Lab_11

• Lab_11_ans

• Source_lab11_delivery

• Source_lab11_department

• Source_lab11_employee

• Source_lab11_item

• Source_lab11_sale

• Source_lab11_supplier

• Storage