Course Finder - Search Colleges and Courses

Posted Date: Total Responses: 0 Posted By: Tony John Member Level: Diamond Points/Cash: 10

Please register yourself as a member in IndiaStudyChannel.com and submit information about your college and add photos to get additional support in this project. We can give you the latest version of this project if you have registered as a member in IndiaStudyChannel.com and posted information about your college like photos, classmates etc.

The live website (http://www.IndiaStudyChannel.com) is modified little bit from the sourcecode provided here. Some of the changes in the live website includes additional security, search engine optimization and changes for performance improvement. Lot of queries used in this project are converted to stored procedures in the live site for better performance. For simplicity, we have provided the source code of the basic version.

You may download a more recent version of this project from MCA Projects section in IndiaStudyChannel.com.

How to install the CourseFinder project

Download the IndiaStudyChannel zip file and extract in a convenient folder. Right click on the folder “IndiaStudyChannel” and select properties.
Select the tab web sharing. Choose the option “Share this folder”. This will make it a virtual folder.

Extract the zip file indiastudychannelDatabase.zip. This will extract a file called indiastudychannelDatabase.bak. This is the backup of an
SQL Server database. Restore this backup to your SQL Server. ( To learn more about SQL Server backup and restore,
visit our SQL Server tutorials section.)

Project Features

CourseFinder project offers the following features:

• Register (New users)
• Login (Existing users)
• Edit profile
• Change password
• Colleges - search for colleges
- Courses - Find courses in the selected college.
- Classmates - Find students studied in the college. Search by academic year or student name.
- Photos - View photos from the selected college.
• Courses - search for courses and find colleges offering the course.
• Universities - search for universities and find colleges affiliated to the university.

Database Tables

Even though the live website uses some stored procedures for performance reasons, we have used dynamic queries in the source code provided to make it simple for beginners. Below are the tables used in the database:

Members - information of all registered members.

Colleges - master table where details of colleges are stored.

Universities - master table where all university name & details are stored.

Courses - master table where all course names are stored.

CollegeCourses - In this table, we store the college Id and the Ids of the courses offered in the specific college. If one college has 5 courses, then this table will have 5 rows for that college. All 5 rows will have same college id and different course ids.

CollegePhotos - In this table, we store the college Id and the Ids of the photos attached to the specific college. If one college has 10 photos, then this table will have 10 rows for that college. All 10 rows will have same college id and different photo details. We are storing the photos in the hard disk as a image file and only the file path is stored in this database table.

Classmates - Each member can select the college he has studied in the past and enter information like year completed, course studied etc. We store such
information in this table along with the member's user id and college id.

Countries - master list of all countries so that users can select the country while registering.

You may download complete source code and database backup by using the links provided in the top of this page.

Feedback

Please submit your feedback about this project using the link below. You can post
questions and comments. We will try our best to update this page or provide answers directly to you.