Lecture Notes & Exercises

Most lectures include an in-class exercise. The lecture notes contain a description of the exercise and sample solutions.

Each student must submit 30/35 class activities (case studies and / or in-class exercises) to complete the course. In-class exercises are due after the class. Each class activity is worth 0.33% (for a total of 10%) of the final grade.

LEC # LECTURE TOPICS Supporting files for EXCERCISES
1

System process: Introduction (PDF)

  
2

System process: Fundamentals (PDF)

  
3

System process: Time and resource estimation, part 1 (PDF)

  
4

System process: Time and resource estimation, part 2 (PDF)

  
5

System process: CMMI, ISO (PDF)

  
6 System process: UML, part 1 (PDF)

UML exercise 1 - input file (VPP)

UML exercise 1 - solution (VPP)
7

System process: UML, part 2 (PDF)

UML exercise 2 - input file (VPP)

UML exercise 2 - solution (VPP)
8 Database: Data modeling, part 1 (PDF)  
9

Database: Data modeling, part 2 (PDF)

 Data modeling exercise 2 - input file (VPP)
10

Database: Data normalization (PDF)

  
11

Database: SQL basics: SELECT, INSERT (PDF)

SQL: Basics, SELECT exercise 1 - input file (SQL)

SQL: Basics, SELECT exercise 1 - solution (SQL)
12

Database: SQL lab (PDF)

SQL: Basics, SELECT exercise 2 - solution (SQL)
13

Database: SQL joins, subqueries, views (PDF)

SQL: Joins, views exercise - solution (SQL)
14

Database: SQL homework 5 (PDF)

 SQL exercise 1 - input aircraft parts data part 1 (ZIP - 2.2MB) (This ZIP file contains: 1 .mdf file.) & part 2 (ZIP - 3.6MB) (This ZIP file contains: 1 .mdf file.)
15

Database: SQL transactions, connections (PDF)

 SQL exercise 2 - input beef data (CSV) & SQL file (SQL)
16 Web: Introduction, HTTP (PDF)  
17

Web: XHTML, CSS (PDF)

XHTML, CSS exercise - input data (ZIP) (This ZIP file contains: 2 .jpg files.)

XHTML, CSS exercise - solution (ZIP) (This ZIP file contains: 2 folders, 2 .jpg files, 3 .html files and 1 .xml file.)
18 Web: Connecting Web and database (PDF)

Connecting Web and database - input data (ZIP) (This ZIP file contains: 1 folder, 1 .sitemap file and 1 .master file.)

Connecting Web and database - solution (ZIP) (This ZIP file contains: 1 folder, 2 .aspx files, 1 .sitemap file and 1 .master file.)
19 Web: Web and database: Forms (PDF)

Web database: Forms and controls exercise 1 - solution (ZIP - 11.5MB) (This ZIP file contains: 2 folders, 5 .aspx files, 1. sitemap file and 1. master file.)
20 Web: Web and database (PDF)

Web database: Forms and controls exercise 2 - solution (ZIP) (This ZIP file contains: 1 folder, 1 .asax file, 9 .aspx files, 1 .sitemap file and 1 .master file.)
21 Web: XML (PDF)

XML exercise - input data (ZIP) (This ZIP file contains: 1 folder, 1 .asmx file and 3 .aspx files.)

XML exercise - solution (XML)
22 Web: Web services (PDF) Web services exercise - input data (ZIP) (This ZIP file contains: 1 folder, 1 .asmx file and 4 .sql files.)
23 Web: Web services: WSDL, registries (PDF)  
24

Web: Service oriented architecture, EDI (PDF)

  
25 Security: Framework, concepts (PDF)  
26

Security: Protocols, part 1 (PDF)

  
27

Security: Protocols, part 2 (PDF)

  
28

Security: Cryptography (PDF)

  
29

Security: SSL, Internet (PDF)

  
30 Networks: System architecture, part 1 (PDF)  
31

Networks: System architecture, part 2 (PDF)

  
32 Networks: Basic telecom technology (PDF)  
33 Networks: Wired LANs, WANs (PDF)  
34 Networks: Connecting wired LANs, WANs (PDF)  
35

Networks: Fiber optics (PDF - 1.5MB)

  
36

Networks: Wireless (PDF - 1.1MB)

  
37

Networks: Enterprise, VPN, MPLS. Course summary (PDF)