ITEC 4810/4820

ITEC 4810 (Information Technology Project I)

• This course is the first capstone course for IT - Systems & Security (IT-SS) senior students.

• It is a team project based course requiring ITEC 2150, 3100, 3200, 3300, and 3700 as its prerequisites.

• The projects includes three major components of IT-SS Track, which are Databases, Networks, and Security.

• Check the course Blackboard for the full syllabus.

• Here is a short schedule for the database module.

• Required Text and Supplies

1. Lecture Notes from instructor

2. Laptop (check the GGC - IT Student Laptop Program and Requirement)

3. Supplementary materials will be provided by the instructor, if needed.

4. The following software may be required in your laptop.

• • Microsoft Visio 2010

  • Microsoft Access 2010

  • Microsoft SQL Server 2008 R2 Express

• Optional textbooks

1. Database Processing: Fundamentals, Design, and Implementation (11th Edition), David Kroenke, Prentice Hall. ISBN-13: 9780132302678

2. Database Systems: Design, Implementation, and Management (8th Edition), Peter Rob and Carlos Coronel. Course Technology. ISBN 13: 978-1-4239-0201-0

ITEC 4820 (Information Technology Project II)

• This course is the second capstone course for IT - Systems & Security (IT-SS) senior students.

• It is a team project based course requiring ITEC 4810 as its prerequisite.

• The projects includes three major components of IT-SS Track, which are Databases, Networks, and Security.

• Check the course Blackboard for the full syllabus.

• Focus of the course

1. Conduct a team-based integrated project including all three components - Database, Network, and Security

2. Use the servers in the IT Lab (Each team should install/configure the NOS, Web server, and DBMS (MS SQL Server or Oracle)

3. The database part of this course includes:

• • Installation/configuration of Microsoft SQL Server 2008

  • DBMS administration functions

  • Database processing for business intelligence

  • Web database access