{"id":1306,"date":"2017-12-18T08:32:09","date_gmt":"2017-12-18T08:32:09","guid":{"rendered":"http:\/\/projecthelpline.in:\/myblog\/?p=1306"},"modified":"2021-11-18T07:30:42","modified_gmt":"2021-11-18T07:30:42","slug":"ignou-mca-miniproject-synopsis-sample","status":"publish","type":"post","link":"https:\/\/projecthelpline.in:\/myblog\/ignou-mca-miniproject-synopsis-sample\/","title":{"rendered":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE"},"content":{"rendered":"<p><strong>\u00a0<\/strong><\/p>\n<h2 style=\"text-align: center;\"><span style=\"color: #ff6600;\"><strong>Indira Gandhi National Open University Project Synopsis Sample On MCA\u00a0 At <\/strong><\/span><\/h2>\n<h2 style=\"text-align: center;\"><span style=\"color: #ff6600;\"><strong>projecthelpline.in<\/strong><\/span><\/h2>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>A<\/strong><\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>SYNOPSIS<\/strong><\/span><\/p>\n<p style=\"text-align: center;\"><strong>\u00a0<span style=\"color: #008000;\">ON<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>ONLINE STUDY CENTER MANAGEMENT SYSTEM<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>UNDER SUPERVISION OF<\/p>\n<h5>\u00a0<strong>\u2026\u2026\u2026\u2026\u2026.<\/strong><\/h5>\n<p><strong>\u00a0<\/strong><\/p>\n<p>SUBMITTED BY<\/p>\n<p>NAME: &#8230;&#8230;&#8230;&#8230;&#8230;..<\/p>\n<p>ENROLMENT NO:\u00a0 \u2026\u2026\u2026\u2026\u2026..<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>Submitted in partial fulfillment for the award of the Degree of<\/p>\n<p><strong>Master <\/strong><strong>of Computer Applications (MCA)<\/strong><\/p>\n<p>Indira Gandhi National Open University<\/p>\n<p>Maidan Garhi<\/p>\n<p>New Delhi \u2013 110068.<\/p>\n<p>2017<br \/>\n<strong>ONLINE STUDY CENTER MANAGEMENT SYSTEM<\/strong><\/p>\n<p><strong>Under Supervision of \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u2026\u2026\u2026\u2026..<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong>&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.<\/p>\n<p><strong>Enrollment\u00a0 No.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong>\u2026\u2026\u2026\u2026\u2026..<\/p>\n<p><em><u><br \/>\n<\/u><\/em><\/p>\n<p>&nbsp;<\/p>\n<table width=\"100%\">\n<tbody>\n<tr>\n<td width=\"83%\">\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>Contents<\/strong><\/span><\/p>\n<\/td>\n<td width=\"16%\"><strong>\u00a0<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">1. Introduction<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">2. Objectives<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">3. Project Category<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">4. Tools\/ Platform Hardware &amp; software requirements<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">5. Data Flow Diagram(DFD and ER diagram)<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">6. Complete Structure<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">7. Modules of\u00a0 the Project<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">8. Data Modeling<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">9. Security and Validation Checks<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">10. Scope of future Application<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">10. Conclusion<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<tr>\n<td width=\"83%\">12.\u00a0 Bibliography<\/td>\n<td width=\"16%\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/em><\/strong><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong><u>TITLE OF THE PROJECT <\/u><\/strong><\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>\u201cOnline Study Center Management System\u201d<\/strong><\/span><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><span style=\"color: #008000;\"><strong><u><br \/>\n<\/u><\/strong><\/span><\/p>\n<ol>\n<li><span style=\"color: #008000;\"><strong><u> INTRODUCTION<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>This is a Project work undertaken in context of partial fulfillment of the MCA. The product <span style=\"color: #ff6600;\"><strong>Online Study Center Management System <\/strong><\/span>offers the information and communication systems, serve as specific media to implement the learning process. The term will still most likely be utilized to refere out-of-classroom and in-classroom educational experiences via technology, even as advances continue in regard to devices and curriculum. There are many benefits to online training. E-learning is beneficial for people who are very busy. E-learning is essentially the computer and network-enabled transfer of skills and knowledge. E-learning applications and processes include Web-based learning, computer-based learning, virtual classroom opportunities. It can be self-paced or instructor-led and includes media in the form of text, image, animation, streaming video and audio.<\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<ol start=\"2\">\n<li><span style=\"color: #008000;\"><strong><u> OBJECTIVE:<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\"><strong><br \/>\n<\/strong><\/span><\/p>\n<p><span style=\"color: #008000;\"><strong><u>INPUT AND OUTPUT OF THE PROJECT<\/u><\/strong><u>\u00a0 <\/u><\/span><\/p>\n<p><span style=\"color: #008000;\"><strong><u>INPUT TO THE PROJECT<\/u><\/strong><\/span><\/p>\n<p><strong>Login Module<\/strong>: This module to authenticate Student(s) &amp; Teacher(s) UserName &amp; Password.<\/p>\n<p><strong>New User:<\/strong> This module is to register new student(s) or Teacher (s).<\/p>\n<p><strong>Admin:<\/strong> Administrator can:<\/p>\n<ul>\n<li>Add Student profiles<\/li>\n<li>Add Teacher Profiles<\/li>\n<li>Add circulars &amp; Notifications<\/li>\n<li>Add fee details, course details, Upload notes, Video tutorials, images etc..<\/li>\n<li>Add Online Quiz &amp; Score board<\/li>\n<li>Add Students &amp; Teachers Attendance<\/li>\n<\/ul>\n<p><span style=\"color: #008000;\"><strong><u>OUTPUT OF THE PROJECT<\/u><\/strong><\/span><\/p>\n<ul>\n<li>Student\u2019s Area<\/li>\n<li>Teacher\u2019s Area<\/li>\n<li>Attendance Report<\/li>\n<li>Examination\u2019s Results<\/li>\n<li>Circular details<\/li>\n<li>Course details<\/li>\n<li>Holiday\u2019s details<\/li>\n<li>Download tutorials (Notes, Videos, MP3, Images)<\/li>\n<li>Feedback from users<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\"><strong><u>ADVANTAGES:<\/u><\/strong><\/span><\/p>\n<ul>\n<li>The system is secured can be accessed by authorized user only, can&#8217;t be accessed by any other person.<\/li>\n<li>Downloading, Online student registration for courses, books, projects, tutorials, Interview Questions, Online Exams etc..<\/li>\n<li>User friendly interface of the software enables user to use this easily and conveniently, proper messages and guidelines have been provided as the user navigates through the forms.<\/li>\n<li>Roll number is generated automatically for the student being registered.<\/li>\n<li>Data retrieval has been done through search forms<\/li>\n<\/ul>\n<p><span style=\"color: #008000;\"><strong><u>DRAWBACKS OF CURRENT MANUAL- SYSTEM<\/u><\/strong><\/span><\/p>\n<ol>\n<li>The existing manual system is not automated consequently a large number of paper works required to handle the projects and it will lead lot of financial, environmental, manpower consumptions.<\/li>\n<li>The retrieval of records of previously registered student will be a tedious job.<\/li>\n<li>Lack of security for the records and the disarrangement of the records leads system malfunction.<\/li>\n<li>If someone wants to check the details of the available records for his satisfaction, the existing system does not provide any necessary detail of this type.<\/li>\n<\/ol>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><br \/>\n<\/strong><span style=\"color: #008000;\"><strong><u>3<\/u><\/strong><strong><u>. PROJECT CATEGORY<\/u><\/strong><\/span><\/p>\n<p><span style=\"color: #008000;\"><strong>My SQL &amp; PHP\u00a0 <\/strong><\/span><\/p>\n<p><span style=\"color: #ff6600;\"><strong>PHP: <\/strong><\/span>PHP is a dynamic and interactive server-side, object-oriented, open source scripting language. PHP is a language used to develop interactive and dynamic content on the web and it is often used together with the Apache web server. While PHP originally stood for\u00a0Personal Home Page, it now stands for\u00a0PHP: Hypertext Preprocessor. PHP code is interpreted by a web server with a PHP processor module which generates the resulting web page: PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. It has also evolved to include a command-line interface capability and can be used in standalone graphical applications. PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) due to restrictions on the usage of the term PHP. PHP can be deployed on most web servers and also as a standalone shell on almost every operating system and platform, free of Varcharge.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>HTML:<\/strong> <\/span>Hyper Text Markup Language and Extensible markup Language are the predominant markup languages for web pages.It provides a means to describe the structure of text-based information in a document and to supplement that text with interactive forms, embedded images, and other objects.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>MySQL:<\/strong><\/span> MySQL is the world&#8217;s most widely used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius&#8217; daughter, My. The SQL phrase stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other &#8216;AMP&#8217; stacks). LAMP is an acronym for &#8220;Linux, Apache, MySQL, Perl\/PHP\/Python.&#8221; Free-software-open source projects that require a full-featured database management system often use MySQL.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\"><strong><u>HARDWARE:<\/u><\/strong><\/span><\/p>\n<p>Processor\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Inter core 2 Duo or above<\/p>\n<p>Memory\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 GB RAM or above<\/p>\n<p>Cache Memory\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 128 KB or above<\/p>\n<p>Hard Disk\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30 GB or above [at least 3 MB free space required]<\/p>\n<p>Printer\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Dot Matrix \/ DeskJet connected to LPT port<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\"><strong><u>SOFTWARE:<\/u><\/strong><\/span><\/p>\n<p>Operating System\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Windows 7<\/p>\n<p>Font-End Tool\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 HTML, PHP<\/p>\n<p>Back-End \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 My Sql<\/p>\n<p>Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Wamp Server<\/p>\n<p><strong><u><br \/>\n<\/u><\/strong><\/p>\n<h4><span style=\"color: #008000;\"><u>PRINCIPLES OF SYSTEM ANALYSIS<\/u><\/span><\/h4>\n<p><strong><u>Principles<\/u><\/strong><strong>:<\/strong><\/p>\n<ol>\n<li>Understand the problem before you begin to create the analysis model.<\/li>\n<li>Develop prototypes that enable a user to understand how human machine interaction will occur.<\/li>\n<\/ol>\n<ol start=\"3\">\n<li>Record the origin of and the reason for every requirement.<\/li>\n<li>Use multiple views of requirements like building data, function and behavioral models.<\/li>\n<\/ol>\n<ol start=\"5\">\n<li>Work to eliminate ambiguity.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"5\">\n<li><span style=\"color: #008000;\"><strong><u> DATA FLOW DIAGRAM (DFD)<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>Data flow diagrams are the most regularly utilized method for reporting the handling of the hopeful framework. As their name recommend they are a pictorial method for speaking to the stream of data into, around, and out of the framework. They are effortlessly justifiable and are less inclined to distortion than printed depiction. A complete arrangement of DFDs gives a reduced top &#8211; down representation of the framework, which makes it less demanding for the client and the investigator to conceive the framework all in all.<\/p>\n<p><span style=\"color: #008000;\"><strong>DFDs are built utilizing four noteworthy parts:<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"color: #ff6600;\"><strong> External elements &#8211;<\/strong><\/span> speaks to the wellsprings of the data that enter the framework or the beneficiaries of the framework that leave the framework.<\/li>\n<\/ul>\n<ul>\n<li><span style=\"color: #ff6600;\"><strong> Data stores &#8211;<\/strong><\/span> speak to the stores of the data inside the framework case: COMPUTER documents, databases or in the manual framework records, and so on data stores can not be connected specifically by data streams either to each other or to outer elements without an interceding procedure to change them.<\/li>\n<\/ul>\n<ul>\n<li><span style=\"color: #ff6600;\"><strong> Processes &#8211;<\/strong><\/span> speak to exercises in which data is controlled by being put away or recovered or changed somehow.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<ol start=\"6\">\n<li><span style=\"color: #008000;\"><strong><u>COMPLETE STRUCTURE<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>For the optimum use of practical time it is necessary that every session is planned. Planning of this project will include the following things:<\/p>\n<ul>\n<li>Topic Understanding.<\/li>\n<li>Modular Break \u2013 Up of the System.<\/li>\n<li>Processor Logic for Each Module.<\/li>\n<li>Database Requirements.<\/li>\n<\/ul>\n<p><strong>Topic Understanding:<\/strong><\/p>\n<p>It is vital that the field of application as introduced in the project may be totally a new field. So as soon as the project was allocated to me, I carefully went through the project to identify the requirements of the project.<\/p>\n<p><strong>Modular Break \u2013Up of the System:<\/strong><\/p>\n<ul>\n<li>Identify The Various Modules In The System.<\/li>\n<li>List Them In The Right Hierarchy.<\/li>\n<li>Identify Their Priority Of Development<\/li>\n<li>Description Of The Modules:<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Modules \u2013 This project consists of different interfaces, which will be accessed through an internet server. Different modules that makeup this system is briefly described below:<\/p>\n<p><strong><br \/>\n<\/strong><\/p>\n<ol start=\"7\">\n<li><u><\/u> <span style=\"color: #008000;\"><strong><u>MODULES OF THE PROJECT<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p><strong>MODULE 1: User Authentication Module<\/strong><\/p>\n<p><strong>MODULE 2: A New Records Being Entered<\/strong><\/p>\n<p><strong>MODULE 3: Deleting or Updating the Records<\/strong><\/p>\n<p><strong>MODULE 4:<\/strong> <strong>Tutorials<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>MODULE 5:<\/strong> <strong>Topics<\/strong><\/p>\n<p><strong>MODULE 6: Forums<\/strong><\/p>\n<p><strong>MODULE 7: Searching<\/strong><\/p>\n<p><strong>MODULE 8: Admin<\/strong><\/p>\n<p><strong>MODULE 9: Validation of Data Entered by the User &amp; Error Handling<\/strong><\/p>\n<p><strong>MODULE 10: Feedback<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><span style=\"color: #008000;\"><strong><u>PROCESS LOGIC FOR EACH MODULE:<\/u><\/strong><\/span><\/p>\n<p><span style=\"color: #ff6600;\"><strong>Validation:<\/strong><\/span> This login and password facility has been provided to authenticate the user. The process is designing the login form.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>Record Entry:<\/strong><\/span> Entering the records via forms designed for user convenience and finally records are stored into the database.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>Editing the records:<\/strong><\/span> The process is to enable user to edit. Data or information changes with time therefore records need to be updated like monthly assessment of each student etc.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>Deleting the Records:<\/strong><\/span> The process to delete records is not available as the data can be retrieved at any time of any age.<\/p>\n<h3><span style=\"color: #008000;\"><strong>\u00a0<\/strong><\/span><\/h3>\n<h3><span style=\"color: #008000;\"><u>8. <\/u><u>DATA MODELING<\/u><\/span><\/h3>\n<h3><span style=\"color: #008000;\"><u>Data Structure\u00a0\u00a0 Requirements according to the modules:<\/u><\/span><\/h3>\n<p>&nbsp;<\/p>\n<ul>\n<li>Identify The Various Tables Required.<\/li>\n<\/ul>\n<ul>\n<li>Fields for These Tables.<\/li>\n<\/ul>\n<ul>\n<li>The Various Key Fields (for example Primary key and foreign key).<\/li>\n<\/ul>\n<ul>\n<li>Identify The Various Constraints like Not Null, Unique etc.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><u>Describing Data Elements:<\/u><\/strong><\/p>\n<p>Each entry in the data dictionary consists of a set of details describing the data used or produced in the system.\u00a0 Each item is identified by a data name, description, alias, and length\u00a0 and\u00a0 has\u00a0 specific\u00a0 values\u00a0 that\u00a0 are\u00a0 permissible\u00a0 for\u00a0 it\u00a0 in\u00a0 the\u00a0 system\u00a0 being studied.<\/p>\n<h3><span style=\"color: #008000;\">LIST OF TABLES:<\/span><\/h3>\n<ol>\n<li><strong>Admin<\/strong><\/li>\n<li><strong>Student Table<\/strong><\/li>\n<\/ol>\n<ol start=\"3\">\n<li><strong>Feedback<\/strong><\/li>\n<\/ol>\n<ol start=\"4\">\n<li><strong>Question<\/strong><\/li>\n<\/ol>\n<ol start=\"5\">\n<li><strong>Registration<\/strong><\/li>\n<\/ol>\n<ol start=\"6\">\n<li><strong>Topic<\/strong><\/li>\n<\/ol>\n<ol start=\"7\">\n<li><strong>Tutorial<\/strong><\/li>\n<\/ol>\n<ol start=\"8\">\n<li><strong>Answer<\/strong><\/li>\n<\/ol>\n<ol start=\"9\">\n<li><strong>Quiz<\/strong><\/li>\n<\/ol>\n<ol start=\"10\">\n<li><strong>Results<\/strong><\/li>\n<\/ol>\n<ol start=\"11\">\n<li><strong>Notes<\/strong><\/li>\n<\/ol>\n<ol start=\"12\">\n<li><strong>Department<\/strong><\/li>\n<\/ol>\n<ol start=\"13\">\n<li><strong>Fee<\/strong><\/li>\n<\/ol>\n<ol start=\"14\">\n<li><strong>Course table<\/strong><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\"><strong>Admin Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"201\">\n<h5>Field<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Type<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Constraint<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"201\">\n<h5>ID<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Number(5)<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Primary Key<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"201\">\n<h5>Email<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>VarVarchar (50)<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"201\">\n<h5>FullName<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>VarVarchar(40)<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"201\">\n<h5>Password<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>VarVarchar (50)<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"201\">\n<h5>Status<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>VarVarchar (1)<\/h5>\n<\/td>\n<td width=\"201\">\n<h5>NotNull<\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nStudent Details Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"238\">\n<h5>Field Name<\/h5>\n<\/td>\n<td width=\"199\"><strong>Data Type<\/strong><\/td>\n<td width=\"153\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Enrollment_No.<\/td>\n<td width=\"199\">Character(20)<\/td>\n<td width=\"153\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Student_Name<\/td>\n<td width=\"199\">Character(20)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Father_Name<\/td>\n<td width=\"199\">Character(20)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Date_of_Birth<\/td>\n<td width=\"199\">Date<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Address<\/td>\n<td width=\"199\">Character(30)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"238\">Telephone_No.<\/td>\n<td width=\"199\">Number<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Attendance Details Table<\/span><\/strong><\/p>\n<table width=\"591\">\n<tbody>\n<tr>\n<td width=\"239\">\n<h5>Field Name<\/h5>\n<\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"153\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Student_Roll_No.<\/td>\n<td width=\"199\">Character(25)<\/td>\n<td width=\"153\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Course_Name<\/td>\n<td width=\"199\">Character(25)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Month<\/td>\n<td width=\"199\">Character(20)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Date_of_Joining<\/td>\n<td width=\"199\">Date<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Total_Classes<\/td>\n<td width=\"199\">Number<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"239\">Class_Attendance<\/td>\n<td width=\"199\">Character(25)<\/td>\n<td width=\"153\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nCourses Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"264\">\n<h5>Field Name<\/h5>\n<\/td>\n<td width=\"165\"><strong>Type<\/strong><\/td>\n<td width=\"150\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Student_Name<\/td>\n<td width=\"165\">Character(30)<\/td>\n<td width=\"150\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Student_Roll_No.<\/td>\n<td width=\"165\">Number<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Course_Name<\/td>\n<td width=\"165\">Character(30)<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Start_Date_of_Course<\/td>\n<td width=\"165\">Date<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Time_Slot_Theory<\/td>\n<td width=\"165\">Character(25)<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Time_Slot_Lab<\/td>\n<td width=\"165\">Character(25)<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Days_of_Theory<\/td>\n<td width=\"165\">Character(20)<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"264\">Days_of_Lab<\/td>\n<td width=\"165\">Character(20)<\/td>\n<td width=\"150\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nFeedback Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"196\">\n<h5>Field Name<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Type<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Constraint<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">\n<h5>ID<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Number(10)<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Primary Key<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">\n<h5>Email<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>VarVarchar (50)<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">\n<h5>Name<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>VarVarchar (50)<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">\n<h5>Feedback<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Varchar (450)<\/h5>\n<\/td>\n<td width=\"197\">\n<h5>Not Null<\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Question Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"197\">Field<\/td>\n<td width=\"197\">Type<\/td>\n<td width=\"197\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">ID<\/td>\n<td width=\"197\">Number(10)<\/td>\n<td width=\"197\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Question no<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Name<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Email<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Question<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Registration Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"198\">Field<\/td>\n<td width=\"198\">Type<\/td>\n<td width=\"198\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">ID<\/td>\n<td width=\"198\">Number(10)<\/td>\n<td width=\"198\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Email id<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Password<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Secret Question<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Secret Answer<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">First Name<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Last Name<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Topic\u00a0 Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"197\">Field<\/td>\n<td width=\"197\">Type<\/td>\n<td width=\"197\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">ID<\/td>\n<td width=\"197\">Number(10)<\/td>\n<td width=\"197\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Topic Name<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Summery<\/td>\n<td width=\"197\">Varchar (510)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"197\">Files<\/td>\n<td width=\"197\">Varchar (50)<\/td>\n<td width=\"197\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Tutorial Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"198\">Field<\/td>\n<td width=\"198\">Type<\/td>\n<td width=\"198\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">ID<\/td>\n<td width=\"198\">Number(10)<\/td>\n<td width=\"198\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Topic Name<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Heading<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Detail<\/td>\n<td width=\"198\">Varchar (30)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"198\">Files<\/td>\n<td width=\"198\">Varchar (50)<\/td>\n<td width=\"198\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nAnswer Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"196\">Field<\/td>\n<td width=\"196\">Type<\/td>\n<td width=\"196\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">ID<\/td>\n<td width=\"196\">Number(10)<\/td>\n<td width=\"196\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Ans_no<\/td>\n<td width=\"196\">Number (10)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">repname<\/td>\n<td width=\"196\">Varchar (50)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Repemail<\/td>\n<td width=\"196\">Varchar (50)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Answer<\/td>\n<td width=\"196\">Varchar (250)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Q.no<\/td>\n<td width=\"196\">Varchar (50)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Askname<\/td>\n<td width=\"196\">Varchar (50)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Askemail<\/td>\n<td width=\"196\">Varchar(50)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"196\">Question<\/td>\n<td width=\"196\">Varchar (100)<\/td>\n<td width=\"196\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\n<span style=\"color: #008000;\">Quiz Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\">Field<\/td>\n<td width=\"199\">Type<\/td>\n<td width=\"199\">Constraint<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Date<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Time<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Score<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Topic<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>Result Table<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\"><strong>Field <\/strong><\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"199\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"199\">ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Student Id<\/td>\n<td width=\"199\">Number (10)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Class<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Section<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Marks<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Max_Marks<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nNotes<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\"><strong>Field <\/strong><\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"199\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"199\">ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Teacher_ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Title<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Subject_Name<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Remarks<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"color: #008000;\"><strong><br \/>\nDepartment<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\"><strong>Field <\/strong><\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"199\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Department_ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Department_Name<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #008000;\"><strong>Fee<\/strong><\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\"><strong>Field <\/strong><\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"199\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"199\">ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Student_ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Class<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Date<\/td>\n<td width=\"199\">Timestamp<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Amount<\/td>\n<td width=\"199\">Currency<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Remarks<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #008000;\">Course Table<\/span><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"199\"><strong>Field <\/strong><\/td>\n<td width=\"199\"><strong>Type<\/strong><\/td>\n<td width=\"199\"><strong>Constraint<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"199\">ID<\/td>\n<td width=\"199\">Number(10)<\/td>\n<td width=\"199\">Primary Key<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Course_Name<\/td>\n<td width=\"199\">Varchar (10)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Duration<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<tr>\n<td width=\"199\">Remarks<\/td>\n<td width=\"199\">Varchar (50)<\/td>\n<td width=\"199\">Not Null<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><u><br \/>\n<\/u><\/strong><\/p>\n<ol start=\"9\">\n<li><strong><span style=\"color: #008000;\">SECURITY AND VALIDATION CHECKS<\/span><\/strong><\/li>\n<\/ol>\n<p>In this project we have used following validation checks.<\/p>\n<ul>\n<li>While entering the data into the form it will check for the nullity of the fields in both of client machine and server.<\/li>\n<li>While entering the data the validation will be checking the existing records, if the records found a message will be fired to the end user as \u201cThe record already exists\u201d.<\/li>\n<li>The students are being granted with access only to the study materials of courses for which student is registered.<\/li>\n<li>Passwords are encrypted using PHP before storing the data into the database. And it will be decrypted and authenticated while login into the system.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ol start=\"10\">\n<li><span style=\"color: #008000;\"><strong><u> SCOPE OF FUTURE APPLICATION<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>The deliverable product is named as <span style=\"color: #ff6600;\"><strong>\u201cOnline Study Center Management System\u201d.<\/strong><\/span><\/p>\n<p>I have designed the given proposed Website in the PHP to automate the educational department.<\/p>\n<p>The complete set of rules &amp; procedures related to educational administrative department day to day activities and generating report is called<span style=\"color: #ff6600;\"> \u201c<strong>Online Study Center Management System\u201d<\/strong><\/span>. My project gives a brief idea regarding automated educational department activities.<\/p>\n<p>I have tried my best to make the complicated process of System as simple as possible using Structured &amp; Modular technique &amp; Menu oriented interface. I have tried to design the software in such a way that user WHO ARE ONLINE may not have any difficulty in using this package &amp; further expansion is possible without much effort. Even though I cannot claim that this work to be entirely exhaustive, the main purpose of my exercise is perform each ADMINISTRATIVE DEPARTMENT activity in computerized way rather than manually which is time consuming.<\/p>\n<p>I am confident that this software package can be readily used by non-programming personal (online users as well as management of the educational department) avoiding human handled chance of error. This project can be successfully uploaded for educational and training operations.<\/p>\n<ol start=\"11\">\n<li><span style=\"color: #008000;\"><strong><u> CONCLUSION:<\/u><\/strong><\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"12\">\n<li><strong><u> BIBLIOGRAPHY<\/u><\/strong><\/li>\n<\/ol>\n<ul>\n<li>PHP<\/li>\n<li>PHP Professional Projects<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Indira Gandhi National Open University Project Synopsis Sample On MCA\u00a0 At projecthelpline.in A SYNOPSIS \u00a0ON ONLINE STUDY CENTER MANAGEMENT SYSTEM &nbsp; UNDER SUPERVISION.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1810],"tags":[107],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in\" \/>\n<meta property=\"og:description\" content=\"\u00a0 Indira Gandhi National Open University Project Synopsis Sample On MCA\u00a0 At projecthelpline.in A SYNOPSIS \u00a0ON ONLINE STUDY CENTER MANAGEMENT SYSTEM &nbsp; UNDER SUPERVISION.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\" \/>\n<meta property=\"og:site_name\" content=\"projecthelpline.in\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/projecthelpline.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-18T08:32:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-18T07:30:42+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535\"},\"headline\":\"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE\",\"datePublished\":\"2017-12-18T08:32:09+00:00\",\"dateModified\":\"2021-11-18T07:30:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\"},\"wordCount\":2378,\"publisher\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\"},\"keywords\":[\"IGNOU MCA SYNOPSIS\"],\"articleSection\":[\"IGNOU MCA PROJECT SYNOPSIS\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\",\"name\":\"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in\",\"isPartOf\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#website\"},\"datePublished\":\"2017-12-18T08:32:09+00:00\",\"dateModified\":\"2021-11-18T07:30:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/projecthelpline.in\/myblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#website\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/\",\"name\":\"projecthelpline.in\",\"description\":\"For Project &amp; Synopsis Contact us At :  9015596280, 9313565406, 9212129290\",\"publisher\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/projecthelpline.in\/myblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\",\"name\":\"projecthelpline.in\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png\",\"contentUrl\":\"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png\",\"width\":50,\"height\":59,\"caption\":\" projecthelpline.in\"},\"image\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/projecthelpline.in\/\",\"https:\/\/twitter.com\/Projecthelplin2\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/projecthelpline.in:\/myblog\/author\/proadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/","og_locale":"en_US","og_type":"article","og_title":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in","og_description":"\u00a0 Indira Gandhi National Open University Project Synopsis Sample On MCA\u00a0 At projecthelpline.in A SYNOPSIS \u00a0ON ONLINE STUDY CENTER MANAGEMENT SYSTEM &nbsp; UNDER SUPERVISION.","og_url":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/","og_site_name":"projecthelpline.in","article_publisher":"https:\/\/www.facebook.com\/projecthelpline.in\/","article_published_time":"2017-12-18T08:32:09+00:00","article_modified_time":"2021-11-18T07:30:42+00:00","author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#article","isPartOf":{"@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/"},"author":{"name":"admin","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535"},"headline":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE","datePublished":"2017-12-18T08:32:09+00:00","dateModified":"2021-11-18T07:30:42+00:00","mainEntityOfPage":{"@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/"},"wordCount":2378,"publisher":{"@id":"https:\/\/projecthelpline.in\/myblog\/#organization"},"keywords":["IGNOU MCA SYNOPSIS"],"articleSection":["IGNOU MCA PROJECT SYNOPSIS"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/","url":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/","name":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE - projecthelpline.in","isPartOf":{"@id":"https:\/\/projecthelpline.in\/myblog\/#website"},"datePublished":"2017-12-18T08:32:09+00:00","dateModified":"2021-11-18T07:30:42+00:00","breadcrumb":{"@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/projecthelpline.in\/myblog\/ignou-mca-miniproject-synopsis-sample\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/projecthelpline.in\/myblog\/"},{"@type":"ListItem","position":2,"name":"IGNOU MCA MINIPROJECT SYNOPSIS SAMPLE"}]},{"@type":"WebSite","@id":"https:\/\/projecthelpline.in\/myblog\/#website","url":"https:\/\/projecthelpline.in\/myblog\/","name":"projecthelpline.in","description":"For Project &amp; Synopsis Contact us At :  9015596280, 9313565406, 9212129290","publisher":{"@id":"https:\/\/projecthelpline.in\/myblog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/projecthelpline.in\/myblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/projecthelpline.in\/myblog\/#organization","name":"projecthelpline.in","url":"https:\/\/projecthelpline.in\/myblog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/","url":"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png","contentUrl":"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png","width":50,"height":59,"caption":" projecthelpline.in"},"image":{"@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/projecthelpline.in\/","https:\/\/twitter.com\/Projecthelplin2"]},{"@type":"Person","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/projecthelpline.in:\/myblog\/author\/proadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/1306"}],"collection":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/comments?post=1306"}],"version-history":[{"count":5,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/1306\/revisions"}],"predecessor-version":[{"id":2815,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/1306\/revisions\/2815"}],"wp:attachment":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/media?parent=1306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/categories?post=1306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/tags?post=1306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}