Share Course Ware
Engineering > Civil & Environmental Eng > Database, Internet, and Systems Integration Techno
 Database, Internet, and Systems Integration Techno  posted by  member7_php   on 2/27/2009  Add Courseware to favorites Add To Favorites  
Abstract/Syllabus
Courseware/Lectures
Test/Tutorials
Further Reading
Webliography
Downloads
More Options
 
Abstract/Syllabus:

Kocur, George, 1.264J Database, Internet, and Systems Integration Technologies, Fall 2006. (Massachusetts Institute of Technology: MIT OpenCourseWare), http://ocw.mit.edu (Accessed 08 Jul, 2010). License: Creative Commons BY-NC-SA

Database, Internet, and Systems Integration Technologies

Fall 2006

Spiral diagram for software development.
The spiral model of software development is discussed in the first several lectures. (Figure by MIT OCW.)

Course Highlights

This course features a full set of lecture notes and assignments, as well as a detailed readings page.

Course Description

This course is an intensive review of information technology. It covers topics in software development methods, data modeling and databases, application development, Web standards and development, system integration, security, and data communications. Most of the homework sets lead the class through a project in which a database and Web application are designed and constructed, using good software process and addressing security, network and other issues. The project, which is done in two-person teams, provides hands-on experience to complement the lectures and readings. Recitations discuss readings and provide more detailed information on the software tools used.

The course goal is to cover the key concepts in the major areas of information technology, to enable students to successfully understand, work with and manage IT efforts as part of supply chain, transportation or civil engineering projects.

Syllabus

What are the course objectives?

This course is an intensive review of information technology. It covers topics in software development methods, data modeling and databases, application development, Web standards and development, system integration, security, and data communications. Most of the homework sets lead the class through a project in which a database and Web application are designed and constructed, using good software process and addressing security, network and other issues. The project, which is done in two-person teams, provides hands-on experience to complement the lectures and readings. Recitations discuss readings and provide more detailed information on the software tools used. The course goal is to cover the key concepts in the major areas of information technology, to enable students to successfully understand, work with and manage IT efforts as part of supply chain, transportation or civil engineering projects.

Is there a prerequisite?

No. No programming experience is required. You should be familiar with the use of Microsoft® Windows® and Word®.

What is the extension policy for problem sets?

Problem sets are due Tuesday or Thursday, as noted in the calendar, at 11:59pm. They are submitted electronically on the course website. In some homework sets, you may need to upload a database or Web pages to a course server; there will be instructions in the homework on how to do that. You will receive one penalty-free extension until the following Saturday or Thursday, whichever is shorter. There are no extensions beyond that unless repeated or extended family or medical emergencies occur. We will generally require a note from the dean or medical department; see the instructor if this occurs.

Late homework sets submitted before the following Saturday or Tuesday, beyond the one penalty-free extension, are penalized 30 points. Homework sets submitted after that receive no credit, since solutions are posted then.

What is the makeup exam policy?

We don't give makeup exams. Please make sure you are here for the midterm exam and final exam. You will be excused from the exams for medical or family emergency reasons only.

What is the academic honesty policy?

You will collaborate with your partner to do the homework sets. You may ask other groups for explanations or help but cannot look at or copy any of their work.

You may work alone or with a partner or in a group for classroom exercises done in lecture. If you do the active learning outside (before) lecture, you must do it alone.

Exams are individual work.

What are the course requirements?

  • 10 problem sets, each worth 4 points (40% of grade).
  • 15 active learning exercises, each worth 1/2 of a point (8%). (You get 0.5% for free.) There are 17 lectures with active learning exercises during the term; you may miss handing in two. The grade is based only on whether you did them. You must upload your exercises or case study notes to the course website by 5pm after lecture.
  • One in-class quiz (open book, open notes), worth 22 points (22%).
  • Final exam during finals period (open book, open notes), worth 25 points (25%).
  • Weekly recitations, graded on attendance and participation (5%).

Calendar

SES # TOPICS KEY DATES
1 Software Process: Introduction  
2 Software Process: Fundamentals  
3 Software Process: Resource Estimation  
4 Software Process: CMMI®, ISO Assignment 1 due
5 Software Process: UML  
6 Database: Data Modeling Assignment 2 due
7 Database: Data Normalization  
8 Database: SQL Basics, SELECT, INSERT Assignment 3 due
9 Database: SQL Joins, Subqueries, Views  
10 Database: SQL Transactions, Connections Assignment 4 due
11 Web Development: Web Introduction, HTTP®  
12 Web Development: HTML®, CSS, Forms Assignment 5 due
  Midterm Exam  
13 Web Development: Web and Database  
14 Web Development: XML® Assignment 6 due
15 Web Development: Web Services and Frameworks, EDI  
16 Security: Protocols, Passwords Assignment 7 due
17 Security: Encryption  
18 Security: Banking, Monitors, Ecommerce  
19 Networks: System Architecture  
20 Networks: Switched Network, Datacomm Assignment 8 due
21 Networks: Local Area Networks, Fiber Optics, Wireless Networks  
22 Networks: Wireless Technology Assignment 9 due
23 Networks: Enterprise Nets, MAN, WAN  
24 Networks: IP Nets, Future, Summary Assignment 10 due
  Final Exam  



www.sharecourseware.org   Tell A Friend