Course Title: IT2 – Fundamentals of Programming with Database Applications
Course Credit: 3 units
Prerequisite: IT1 - Fundamentals of Computer Software and Applications
This is an introductory course on programming and will teach the student basic programming skills. Topics include: fundamentals of programming methodology, software lifecycle, requirements and specifications, software design, design methodologies, verification and testing. The course also introduces the student to database management systems. It focuses on fundamental entity relationships and data flow diagrams, access database fundamentals, and reliable storage.
At the end of the course, the students are expected to: 1. become well-versed with program logic design using flowcharting 2. solve simple accounting problems using C++
3. design, code and document, and implement a simple C++ accounting application 4. understand the concept and principles of making a database application 5. design, code and document, and implement a simple MS Access accounting application Course Requirements:
|Prelim: |Midterm: |Endterm: | |Exercises: |Exercises: |Exercises: | |Use structured English statements to make an algorithm for a given problem |Create a basic sequential C++ program to solve a given problem |Create a simple database table | |Draw a flowchart for a given problem (manual) |Create a basic C++ program that makes decisions using decision structures |Create a relationship for two or more tables | |Draw a flowchart for a given problem (RAPTOR) |Create a basic C++ program that repeats a process using loop structures |Create an input form for the created tables | | |Create a basic C++ program that shows modularization by using functions |Use simple queries to retrieve data from database tables | |Term Project by pair: |Create a basic C++ program that shows modularization by using pre-defined | | |Show the algorithm for a given problem using a flowchart |functions |Term Project by pair: | | | |Show the algorithm for a given problem using a MS Access | | |Term Project by pair: | | | |Create a C++ program to solves for a given problem using the basic C++ | | | |structures while incorporating the reusability of the codes...