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
Lecture Notes from instructor
Laptop (check the GGC - IT Student Laptop Program and Requirement)
Supplementary materials will be provided by the instructor, if needed.
The following software may be required in your laptop.
Microsoft Visio 2010
Microsoft Access 2010
Microsoft SQL Server 2008 R2 Express
Optional textbooks
Database Processing: Fundamentals, Design, and Implementation (11th Edition), David Kroenke, Prentice Hall. ISBN-13: 9780132302678
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
Conduct a team-based integrated project including all three components - Database, Network, and Security
Use the servers in the IT Lab (Each team should install/configure the NOS, Web server, and DBMS (MS SQL Server or Oracle)
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