Database, Internet, and Systems Integration Technologies

Assignments

Case studies must be submitted in advance of the lecture. Each student must submit 30/35 class activities (case studies and / or in-class exercises) to complete the course. Each class activity is worth 0.33% (for a total of 10%) of the final grade.

Homework is done in groups of two students. Each homework is worth 4% (for a total of 40%) of the final grade.

LEC #	LECTURE TOPICS	CASE STUDIES	HOMEWORKS
1	System process: Introduction
2	System process: Fundamentals	Lecture 2 case study (PDF) Lecture 2 case study - solution (PDF)
3	System process: Time and resource estimation, part 1
4	System process: Time and resource estimation, part 2		Homework 1 software process (PDF) Homework 1 software process - solution (PDF)
5	System process: CMMI, ISO	Lecture 5 case study (PDF) Lecture 5 case study - solution (PDF)
6	System process: UML, part 1
7	System process: UML, part 2		Homework 2 requirements, software estimation (PDF) Homework 2 requirements, software estimation - solution (PDF - 1.3MB)
8	Database: Data modeling, part 1
9	Database: Data modeling, part 2
10	Database: Data normalization		Homework 3 UML model (PDF) Homework 3 UML model - solution (VPP)
11	Database: SQL basics: SELECT, INSERT
12	Database: SQL lab
13	Database: SQL joins, subqueries, views
14	Database: SQL homework 5		Homework 4 data model (PDF) Homework 4 data model - solution (VPP)
15	Database: SQL transactions, connections
16	Web: Introduction, HTTP
17	Web: XHTML, CSS
18	Web: Connecting Web and database
19	Web: Web and database: Forms		Homework 5 database implementation (PDF) Homework 5 database implementation - solution (SQL)
20	Web: Web and database
21	Web: XML
22	Web: Web services
23	Web: Web services: WSDL, registries		Homework 6 Web basics (PDF) Homework 6 Web basics - solution (ZIP) (This ZIP file contains: 3 folders, 14 .aspx files, 1 .sitemap file and 1 .master file.)
Midterm Exam
24	Web: Service oriented architecture, EDI	Lecture 24 case study (PDF) Lecture 24 case study- solution (PDF)
25	Security: Framework, concepts	Lecture 25 case study (PDF) Lecture 25 case study - solution (PDF)
26	Security: Protocols, part 1
27	Security: Protocols, part 2	Lecture 27 case study (PDF) Lecture 27 case study - solution (PDF)	Homework 7 Web site (PDF) Homework 7 Web site - solution (ZIP) (This ZIP file contains: 2 folders, 14 .aspx files, 1 .sitemap file and 1 .master file.)
28	Security: Cryptography
29	Security: SSL, Internet	Lecture 29 case study (PDF) Lecture 29 case study - solution (PDF)
30	Networks: System architecture, part 1		Homework 8 XML (PDF) Homework 8 XML - solution (PDF) Homework 8 XML - solution (ZIP) (This ZIP file contains: 1 folder, 2 .aspx files and 1 .asmx file.)
31	Networks: System architecture, part 2
32	Networks: Basic telecom technology	Lecture 32 case study (PDF) Lecture 32 case study- solution (PDF)
33	Networks: Wired LANs, WANs	Lecture 33 case study (PDF) Lecture 33 case study- solution (PDF)	Homework 9 security (PDF) Homework 9 security - solution (PDF)
34	Networks: Connecting wired LANs, WANs	Lecture 34 case study (PDF) Lecture 34 case study- solution (PDF)
35	Networks: Fiber optics	Lecture 35 case study (PDF) Lecture 35 case study- solution (PDF)
36	Networks: Wireless	Lecture 36 case study (PDF) Lecture 36 case study- solution (PDF)	Homework 10 communications (PDF) based on RFI article (PDF) Homework 10 communications - solution (PDF)
37	Networks: Enterprise, VPN, MPLS. Course summary.
Final Exam