Preface

  • This Online Certified Course Website is Provide to you to learn and get the certificate.
  • This Website Can be Also Provide Information about different types of courses.
  • The User can learn online and get the certificate.
  • This is a static and dynamic website designed
  • The User can registration first and then login and start the course.

Acknowledgement

We are very grateful and thankful to professors of my college. Who give me a good guidance and gives suggestion about each and every topic which we study and research? They give me guidance about my current Online Certified Course project.

We also thankful to my friends. Who give me support to helpful to complete this project? And solve my all difficulties.

We are taking this opportunity to express out gratefulness to the principle and All staff.

We also express our heartily thankfulness to all out friendly classmate and those entire person who have directly helped us in the preparation of this project.

Thank you to all person involve in this Online Certified Course project.

Project Profile

Project Name : Online Certified Courses
Front – end – tool : PHP Version 5.2.6
Back – end – tool : Mysql
Operating System : Windows-7.
Team Size : 2 Students
Project Duration : 3 Months

Software Requirement:-

  • Operating Systems : Microsoft Windows XP (or more)
  • Front End Tool : PHP
  • Back End Tool : Mysql
  • Browser : Chrome, IE, Firefox

Drawback of Existing System

  • As Current System is Window base. So it’s Very Difficult.
  • Time consuming Problem.
  • Only One Person is work at a time.
  • Difficult to Work for learning courses Time Duration.

Need for new System

  • To online certified Process Work Is Fastly?
  • Reduce The Time Period for learning courses.
  • Paper work to be Removing.
  • Information stored in database, which provides data security.

Data Flow Diagram

Context Level Diagram

0’Level DFD for User

O’Level DFD for Admin

DATA Dictionary

REGISTRATION TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(5) Auto/Inc Use For id
2 Cust_name Varchar(25) Not Null Use For Name
3 Cust_address Varchar(50) Not Null Use For Address
4 Cust_city Varchar(50) Not Null Use For City
5 Cust_state Varchar(12) Not Null Use For State
6 Cust_country Varchar(10) Not Null Use For Country
7 Cust_email Varchar(50) Not Null Use For Email
8 Cust_password Varchar(15) Not Null Use For Password
9 Cust_dob Date Not Null Use For Birth Date
10 Cust_gender Varchar(6) Not Null Use For Gender
11 Cust_Pincode Int(6) Not Null Use For Pincode
12 Cust_mobile Decimal(10,0) Not Null Use For Mobile

ADMIN LOGIN TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 Username Varchar(25) Not Null Use For Username
3 Password Varchar(25) Not Null Use For Password

NEWS TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 News Text Not Null Use For News

FEEDBACK TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(11) Auto/Inc Use For id
2 Name Varchar(20) Not Null Use For Name
3 Email Varchar(30) Not Null Use For Email Id
4 Mobile Decimal(10,0) Not Null Use For Mobile No
5 Message Varchar(500) Not Null Use For Message

COURSE TABLE

SR.NO Field Name Data Type Constraints Description
1 C_id Int(5) Auto/Inc Use For id
2 Course_Name Varchar(50) Not Null Use For Name
3 Course_category Varchar(50) Not Null Use For Category
4 Course_cont Text Not Null Use For Content
5 Img_Name Varchar(50) Not Null Use For Image Name
6 Image Blob Not Null Use For Image
7 Pdf_name Varchar(100) Not Null Use For Pdf

Form Layout

Home Page
About Us Page
Contact Us Page
Registration Page
Login Page
Business Course Page
Admin Login Page


Admin Home Page


Add Course Page


Update News Page


Admin Change Password


Feedback Suggession Page
Feedback Report
Registration Page