You can share the texts with your homework partner, so each of you needs to get three texts. Obtain either [SQ] or [MU] but not both, for the SQL language.
1. [RD] McConnell, Steve. Rapid Development: Taming Wild Software Schedules. Redmond, WA: Microsoft Press, 1996. ISBN: 9781556159008.
2. [UM] Fowler, Martin. UML Distilled: A Brief Guide to the Standard Object Modeling Language. 3rd ed. Reading, MA: Addison-Wesley, 2003. ISBN: 9780321193681.
3. [SQ] Bowman, Judith S., Sandra L. Emerson, and Marcy Darnovsky. The Practical SQL Handbook: Using SQL Variants. 4th ed. Reading, MA: Addison-Wesley, 2001. ISBN: 9780201703092.
4. [MU] Syverson, Bryan. Murach's SQL for SQL Server. Fresno, CA: Murach, 2002. ISBN: 9781890774165.
5. [DR] McFarland, David S. Dreamweaver 8: The Missing Manual. Sebastopol, CA: O'Reilly, 2005. ISBN: 9780596100568.
6. [SE] Anderson, Ross. Security Engineering: A Guide to Building Dependable Distributed Systems. New York, NY: John Wiley & Sons, 2001. ISBN: 9780471389224.
7. [TE] Green, James H. The Irwin Handbook of Telecommunications. 5th ed. New York, NY: McGraw-Hill, 2005. ISBN: 9780071452229.
Check the errata for these books; they should all mention Web sites that hold corrections.
Course readings.
| SES # | TOPICS | Readings |
| 1 | Software Process: Introduction | |
| 2 | Software Process: Fundamentals | RD. Chapters 1-5 |
| 3 | Software Process: Resource Estimation | RD. Chapters 6-8 |
| 4 | Software Process: CMMI®, ISO | RD. Chapter 9 |
| 5 | Software Process: UML | UM. Chapters 1-2 (skim), 4, 8-12, and 14-15 |
| 6 | Database: Data Modeling | SQ. Chapter 2 or MU. Chapter 9 |
| 7 | Database: Data Normalization | SQ. Chapter 2 or MU. Chapter 9 |
| 8 | Database: SQL Basics, SELECT, INSERT | SQ. Chapters 1, and 3-5 or MU. Chapters 1-3 |
| 9 | Database: SQL Joins, Subqueries, Views | SQ. Chapters 6-9 or MU. 4, 5, and 7 |
| 10 | Database: SQL Transactions, Connections | SQ. Chapter 10 or MU. Chapters 6, 12, and 16 |
| 11 | Web Development: Web Introduction, HTTP® | DR. Chapters 1 and 3-5 |
| 12 | Web development: HTML®, CSS, Forms | DR. Chapters 6 and 10 |
| | Midterm Exam | |
| 13 | Web Development: Web and Database | DR. Chapters 20-23 |
| 14 | Web Development: XML® | DR. Chapter 24 |
| 15 | Web Development: Web Services and Frameworks, EDI | |
| 16 | Security: Protocols, Passwords | SE. Chapters 1-4 |
| 17 | Security: Encryption | SE. Chapter 5 |
| 18 | Security: Banking, Monitors, Ecommerce | SE. Chapters 9, 10, 18, and 19 |
| 19 | Networks: System Architecture | TE. Chapters 1-3 |
| 20 | Networks: Switched Network, Datacomm | TE. Chapters 4 and 6-8 |
| 21 | Networks: Local Area Networks, Fiber Optics, Wireless Networks | TE. Chapters 10 and 17-18 |
| 22 | Networks: Wireless Technology | TE. Chapters 19-21 |
| 23 | Networks: Enterprise Nets, MAN, WAN | TE. Chapters 31-33 and 35 |
| 24 | Networks: IP Nets, Future, Summary | TE. Chapters 36 and 39-40 |
| | Final Exam | |
Dreamweaver Reading
The Dreamweaver book spends a lot of pages on the visual aspects of Web sites, but our focus is on the use of the Web for data and integration. The book covers many detailed topics that you don't need to read about in depth. Skim many sections so that you know the material is there and so that you can go back to it as a reference if you need it when you build your site. Specific suggestions for reading, by chapter:
1. Read, do tutorial. (I would do the tutorial first, before reading the chapter.)
2. Skip. Skim to see topics covered; you probably won't need these.
3. Read pp. 75-88, skim the rest quickly.
4. Read.
5. Read pp. 123-134, skim the rest quickly.
6. Read, do tutorial (Again, I'd do the tutorial first.)
7. Read the first 20 pages or so about layout tables in general; future examples will use them.
8. Skip. This chapter is about detailed page layout, which you don't need to know.
9. Skip. If you have problems with Web pages in your homework, skim this chapter for some aids Dreamweaver provides to find and correct errors.
10. Read.
11-12. Skip. These cover advanced visual features, which you don't need to know.
13-15. Skip. Skim to see topics covered; the TAs will help you move your site to the server.
16-19. Skip. These cover advanced visual features, which you don't need to know.
20-24. Read; these are the key chapters for Web-database interactions.
For chapters 20-24 on Web-database interactions: You don't need to read these for class; you can read the necessary chapters as you do the homework sets 7-9. Each homework will indicate the chapters needed.
Telecom Handbook Reading
1. History. Skim for definitions (LEC, IXC, LATA, others). No need to know history.
2. Public network. Read.
3. Data communications. Read.
4. Datacomm principles. Skip or skim datacomm fundamentals section. Read datacom equipment section.
5. Pulse code modulation. Skim Digital Carrier Technology, Digital Signal Hierarchy and PCM Application Issues sections. Skip the rest unless interested in technical details.
6. Datacomm protocols. Read.
7. Outside plant. Skip electrical protection section.
8. Access technologies. Read.
9. Cabling systems. Skip.
10. Local area networks. Read.
11. Network equipment. Skip.
12-16. Switching systems. This is about traditional voice calls; skip.
17. Optical networking. Read, but skip the highly technical parts.
18. Microwave. Read; skip modulation, diversity sections.
19. Satellite. Read.
20. Mobile systems. Read.
21. Wireless data. Read.
22. Video. Skip.
23-30. Customer premises equipment. Skip all these chapters. Useful later if you need to work with a call center or other voice services.
31. Enterprise networks. Read.
32. MANs. Read.
33. WANs. Skim; all these options are of historical interest only.
34. Frame relay. Skip.
35. ATM. Read the first 3 pages only.
36. IP networks. Read.
37-38. Skip.
39-40. Read.
