A Project Report On Online Certified Course

 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