152-172 Systems Implementation SQL for DB2

Discusses the importance of and need for Database Management Systems(DBMS). Students design and implement relational databases and learn SQL.

• Unit 1 ERD and Normalization
• Chapter 4 Presentation
• Chapter 5 Presentation
• Chapter 6 Presentation
• ERD Handout
• Chapter 7 Presentation
• Chapter 8 Presentation
• Normalization Handout

• Unit 2 SQL
• Chapter 1 Presentation
• Chapter 2 Presentation
• Chapter 9 Presentation
• Chapter 3 Presentation
• Chapter 10 Presentation
• Chapter 11 Presentation
• Chapter 12 Presentation

• Unit 3 Project
• Chapter 19 Presentation
• Chapter 20 Presentation
• What is a Well-Prepared Portfolio

• Syllabus

• Schedule

• Assignments
• Single Table Selects
• Multiple Table Selects
• Table Views

• Portfolios Assessment

• Project Criteria