Chapter1 MySQL Project Duration : July 2014 To

Chapter1 –IntroductionProject Profile Definition Purpose Objective Scope Front end and Backend Technology and Literature Review Domain Description Functions and main modules of new system Introduction Project ProfileProject Title : Know Your ChildPlatform : Windows OSFront-End System : JAVA(My Eclipse 7.1)Back-End System : MySQLProject Duration : July 2014 To April 2015Project Guide : Prof.

Shraddha BhalodiyaSubmitted By : JaspalSing Jat(150350107007): Vala Milan (160353116014): Monika Desai(160353116004)Poonam Makavana(160353116008)Submitted To : Noble Group Of Institutions, JunagadhDefinitionThis project will give Information to Parents and teacher for Tracking child’s educational and non-education activity. Sometimes it is quite difficult to justify the Students Strengths as well as their Weaknesses. Difficult to maintain Students past history.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

The most important feature of our Website is based on Students activities tracking for Schools as well as their Parents (Students can be a Primary or can be a Higher Secondary Dependent).PurposeOur purpose is to provide a better future for student by tracking their regular activities and aware their parents. Objective Reduced Manpower- Reduce the manpower.

The operation perform manually is reduced. Reducing time in activities- Reduce the time to get the information relating to any Students.Improvement- Parents can get improvement of their child activity. ScopeThis project will give Information of their child to parents and parents as well as teachers can easily tracking child’s activity and easily maintain past history of student. Front end and Backend Front End: Java has many features that attracted us to choose it as a front end. Java provides more security then other languages. Apart from that there are many features of java which are useful for any project. Few features which are relevant to our system are:? Java is open source.

? Java provides more security.? Java is Platform Independent.? Java is Object-Oriented & Robust.

? Java is Architecture neutral & portable.For designing of Zoo-Intelligence we have choose HTML, CSS and Java Script.JSP? JavaServerPages (JSP) is a technology that helps software developers create dynamically generated web pages based on HTML, XML, or other document types.? Released in 1999 by Sun Microsystems, JSP is similar to PHP, but it uses the Java programming language.? to deploy and run Java Server Pages, a compatible web server with a servlet container, such as Apache Tomcat or Jetty, is required.? JSP Stands for “Java Server Page.” This standard was developed by Sun Microsystems as an alternative to Microsoft’s active server page (ASP) technology.? JSP pages are similar to ASP pages in that they are compiled on the server, rather than in a user’s Web browser.

? After all, they don’t call them “server pages” for nothing. However, JSP is Java-based, whereas ASP is Visual Basic-based.? JSP pages are useful for building dynamic Web sites and accessing database information on a Web server. Though JSP pages may have Java interspersed with HTML, all the Java code is parsed on the serverServlets:? Servlets are based on the Java Sun platform technology of choice for extending and improving web servers and they provide a component- based, platform independent method for creating web applications, without the limitations of the performance of CGI programs.? An HTTP servlet is a special type of servlet that handles an HTTP request and supplies an HTTP response, commonly in the form of an HTML page. The most common use of Web Logic HTTP Servlets is to create interactive applications that uses standard Web browsers for the client-side presentation while WebLogic Server handles the business logic as a server-side process.? Servlets are most often used to:Process or store data that was submitted from an HTML form.

Provide dynamic content such as the results of a database queryManage state information that does not exist in the stateless HTTP protocol, such as filling the articles into the shopping cart of the appropriate customerJavaScript:? JavaScript was originally developed by Brendan Eich, while working for Netscape Communications Corporation.? Although it was developed under the name Mocha, the language was officially called Live Script when it first shipped in beta releases of Netscape Navigator 2.0 in September 1995, but it was renamed JavaScript when it was deployed in the Netscape browser version 2.0B3.? JavaScript is a lightweight, interpreted programming language with object-oriented capabilities that allows you to build interactivity into otherwise static HTML pages.? Using JavaScript one can validate user input before sending the page off to the server.

This saves server traffic, which means less load on your server.? One can create interfaces that react when the user hovers over them with a mouse or activates them via the keyboard.? One can use JavaScript to include such items as drag-and-drop components and sliders to give a Rich Interface to your site visitors.Html:? HTML is not a programming language, it is a markup language. A markup language is a set of markup tags.

HTML uses markup tags to describe web pages.? HTML5 is a core technology markup language of the Internet used for structuring and presenting content for the World Wide Web.? As of October 2014 this is the final and complete fifth revision of the HTML standard of the World Wide Web Consortium The previous version, HTML 4, was standardized in 1997.? Its core aims have been to improve the language with support for the latest multimedia while keeping it easily readable by humans and consistently understood by computers and devices (web browsers, parsers, etc.

).CSS:? Cascading Style Sheets (CSS) is a style sheet language used for describing the look and formatting of a document written in a markup language.? Most often used to change the style of web pages and user interfaces written in HTML and XHTML, the language can be applied to any kind of XML document, including plain XML,SVG and XUL.? Along with HTML and JavaScript, CSS is a cornerstone technology used by most websites to create visually engaging webpages, user interfaces for web applications, and user interfaces for many mobile applications.? CSS is designed primarily to enable the separation of document content from document presentation, including elements such as the layout, colors, and fonts.? This separation can improve content accessibility, provide more flexibility and control in the specification of presentation characteristics, and reduce complexity and repetition in the structural content, such as semantically insignificant tables that were widely used to format pages before consistent CSS rendering was available in all major browsers.

Back End:MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons MySQL is released under an open-source license. So you have nothing to pay to use it.

MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.MySQL uses a standard form of the well-known SQL data language.

MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.MySQL works very quickly and works well even with large data sets.MySQL is very friendly to PHP, the most appreciated language for web development.

MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

MySQL Database Different Versions:MySQL 3.0MySQL 4.0MySQL 5.0MySQL 6.0 Technology and Literature ReviewFor any project or software technologies used to develop are need to be observed carefully. Before adopting any technology we can review past system or projects.

By carrying out those kinds of activities at last we finalize some technologies which are best option for developing this project. The literature survey is carried out as to fulfill the first objective of the research that is to gather as much information relevant with growth of education of child.Java was originally developed by James Gosling at Sun Microsystems (which has since been acquired by Oracle Corporation) and released in 1995 as a core component of Sun Microsystems’ Java platform. The language derives much of its syntax from C and C++, but it has fewer low-level facilities than either of them.PrinciplesThere were five primary goals in the creation of the Java languageIt must be “simple, object-oriented, and familiar”.

It must be “robust and secure”.It must be “architecture-neutral and portable”.It must execute with “high performance”.It must be “interpreted, threaded, and dynamic” Domain Description CORE JAVAJava is a simple, secure, portable, object oriented programming language originally developed by Sun Microsystems. Java runs on platforms, such as Windows, Mac OS, and the various versions of UNIX. Java has its own runtime, JRE and API. Java uses JIT (Just in time) compiler.Java EE (Java Enterprise Edition)It is an enterprise platform used to develop various webs and enterprise applications.

It is on the top of Java SE platform. It includes topics like Servlet, JSP, Web Services, EJB, JPA etc.JSPJava Server Pages (JSP) is a technology that helps to create dynamic web pages based on HTML, XML, or other document types.

JSP helps us to write HTML pages containing Tags, inside which we can include powerful Java programs. It includes various elements i.e. scripting elements, directive elements and standard action elements to code variousPrograms.ServletServlet is special type of java file which runs on server side in which client sends request Mode, server accept request data, manipulate it and throws response and at last client Display appropriate results.

JDBCJDBC stands for Java Database Connectivity, provides API or protocol to interact with Different databases for connection between client side and database side. It means JDBC Is responsible for conversation of one format to another format as per requirements. JDBC provides the same capabilities as ODBC, allowing Java programs to contain Database-independent code.HibernateHibernate is an open source, lightweight, ORM (Object Relational Mapping) tool.

Hibernate manages the mapping from Java classes to database tables (and from Java data Types to SQL data types) also provides data query and retrieval facilities. Hibernate is Used to handle large source of database when there is about more than 20 tables or more. Functions and main modules of new system Functions:-Information Management: Admin:Admin creates various sub-admin and give them the rights to manage variousTeachers and Student.

It handles all the modules.Teacher:-Registration:It manages the registration for all teacher.Login:It manage the login for all teacher.Feedback:It manage the feedback for all teacher.Contact us:It manage contact detail of the admin for Teacher and parents.Admin Module: Add Teacher: It is used to add or remove the Teacher and Student by admin.

Generate progress report: It is used to generate daily activity report of student by admin Send Report:It is used to send report card of student to their parents via Sms Service by admin.Teacher Module: Add Student:It is manage all student add or remove by teacher. Generate Activities:It is generate student mark sheet and manage class information. Chapter2 Project ManagementProject Development model Project Plan Roles and Responsibilities Project Scheduling Project Management Project Development model:1014703855500 Fig 2.1 Spiral ModelSpiral model in software testing is the testing strategy which works on incremental and prototype technique.

Generally spiral model strategy is followed for the large and complicated projects where risks are high and development and testing goes on incremental basis. Spiral model is also known as spiral lifecycle model. This model is quite old but still very useful for the large projects development and testing.Best approach for testing and development for complex and large project.

Cost effective.Better risk analysis and management.Better requirement analysis.Fast and easy development.Better time management Easy to change requirements and documentation if any change happens in the Middle of developmentProject Plan Table 2.2: Project PlanActivity Duration DaysProject Definition 29-Jun-2018 To 06-July-2018 7Analysis of Existing system 10-July-2018 To 13-July-2018 3Design Engineering canvas 17- July -2018 To 24-July -2018 7Database Design 01-Aug-2018 To 10-Aug-2018 10UML Diagrams 12- Aug -2018 To 20-Aug-2018 8Data Dictionary 23-Aug-2018 To 2-Sept-2018 8ImplementationDesigningRegistration and LoginFeedback 5-Sept-2018 To 12-Sept-201813-Sept-2018 To 22-Sept-201823-Sept-2018 To 25-Sept-2018792Testing 26-Sept-2018 To 30-Sept-20185Documentation 01-Oct-2018 To 10-Oct-2018 10Roles and ResponsibilitiesAnalyst: It manages whether the requirements of clients are fulfilled.

DBA: Manages database for the proposed system.Designer: Designs the whole layout of the proposed system.Developer: Develop the whole logic for the project.

Tester: Tests whether the system has loopholes or not.Project SchedulingFig 2.4: Project ScheduleChapter3 System Requirements StudyUser Characteristics Hardware and Software Requirements Constraints (Limitations) 3.0 System Requirements Study3.1 User CharacteristicsAdminComputer OperatorNetwork OperatorAuthorized Person3.

2 Hardware and Software Requirements3.2.1 Hardware Requirements:Operating System : WindowsRAM : 4 GBCPU Processor : 2100 MHzArchitecture : 32-bit or 64-bitGraphics : Intel HD Graphics Card, Radeon Graphics Card3.2.2 Software Requirements:Tools(Frontend) : My Eclipse Enterprise Workbench 7.1, JDK 1.6.0Tools(Backend) : MySQLWeb Server : Apache Tomcat Server 7.

1Web Browser: Mozilla Firefox, Google ChromeWeb Development : Java EE(Enterprise Edition)Technology : Java Servlet 2.4,JSP 2.0,JSTL 1.0,JDBC 3.0,EJB 2.1, JMS 1.1, Java Mail API 1.33.

3 Constraints (Limitations)Lack of internet access Lack of knowledge about system Lack of electricitySecurity attacks on systemChapter – 4 System Analysis4.1 Study of Current/Existing System4.2 Problem and Weaknesses of Current System4.3 Requirements of New System4.3.1 User Requirements4.3.2 System Requirements4.

4 Feasibility Study4.4.1 Does the system contributes to the overall objectives of the organization?4.

4.2 Can the system be integrated with other systems which Are Already In place?4.0 System Analysis4.1 Study of Current/Existing SystemCurrently in this faster generation parents haven’t enough time for being avail for their child, still they want to know their child’s growth in concern to study and each and every activities. There may be they could know the result of any exam or test but they couldn’t find the growth in concern to each and every activities.

The existing system are avail only for generating or sending message of any test/exam marks to the parent but they can’t aware of total growth of their child in any particular field either it may be study relevant or any other ,so for that change is required.4.2 Problem and Weaknesses of Current SystemLess efficientTime ConsumingRedundancyInconsistencyInaccurate4.3 Requirements of New System 4.3.1 User RequirementsComputers Smart phonesElectricityInternet access 4.3.

2 System RequirementsComputer (with minimum 4 GB RAM or more) 4.4 Feasibility Study 4.4.1Does the system contribute to the overall objectives of the organization?Yes, the system contribute to the overall objective of the organization. As Objectives of any organizations should be clear, measurable and realistic so the system contribute to these type of objectives.

4.4.2 Can the system be integrated with other systems which are already in Place?Yes, the system can be integrated with other system which are already in place which contains some extra features than this system.Chapter – 5 System Design5.

1 Class Diagram5.2 ER Diagram5.3 Data Flow Diagram5.4 Use Case Diagram5.5 Activity Diagram5.6 Sequence Diagram5.

0 System Design114935309245005.1 Class Diagram5.2 ER DiagramFig 5.2.1: ER Diagram5.3 Data Flow Diagram5.3.1 DFD Level 0Fig 5.

3.1: DFD Level 05.3.2 DFD Level 1 Fig: 5.3.

2 DFD level 15.4 Use Case DiagramFig: 5.4 Use Case Diagram5.5 Activity DiagramFig: 5.

5 Activity Diagram5.6 Sequence Diagram Fig: 5.6 Sequence DiagramChapter-6 Software Development6.

1 Security Features6.2 Coding Standards6.0 Software Development 6.1 Security Features Accuracy: only admin add class and add faculty.Eligibility and Authentication: admin and faculty not access without id and password.Integrity: faculty cannot modify his/her detail.Privacy: admin and faculty not access without id and password.

Uniqueness: faculty manage only his/her class.Convenience and interface usability: faculty should be able to send student report to their parents.Reliability: If any failure occurs then the system should be robust, and no loss of dataShould happen. Verifiability: System should be testable6.2 Coding Standards Global variable names start with capital letters Local variable names start with small letters Constant names are capital letters File names start with capital letters and follow the camel caseChapter7 ImplementationData Dictionary Validation Screenshots Application Requirements Advantage7.0 Implementation 7.1 Data Dictionary 1) Admin:- Table 7.

1.1.1: TABLE DETAILTable Name AdminPurpose Registered AdminPrimary Key: idForeign Key: Sid,tidTable 7.

1.1.2: COLUMN DETAILNo Field Name Constraint Data Type Size Description1 id PK Int 50 Primary Key2 user_name NOT NULL Varchar2 50 Username of Admin3 password NOT NULL Varchar2 50 Password of Admin4 sid FK Int 20 Foreign Key of Student id5 tid FK Int 20 Foreign Key of Teacher idQUERY: CREATE TABLE Admin (id int (50)NOT NULL PRIMARY KEY, user_name varchar2(50) NOT NULL, password varchar2(50) NOT NULL,sid int(20),tid int(20), FOREIGN KEY (sid) REFERENCES Student(sid), FOREIGN KEY (tid) REFERENCES Teacher(tid));58018825837500SNAPSHOT: 2) Teacher:- Table 7.1.2.

1: TABLE DETAILTable Name teacher_dbPurpose Register Every TeacherPrimary Key: tidForeign Key: sid Table COLUMN DETAILNo Field Name Constraint Data Type Size Description1 tid PK Int 30 Primary Key2 fname NOT NULL Varchar2 50 Username of Teacher3 lname NOT NULL Varchar2 50 Password of Teacher4 bd NOT NULL Varchar2 50 Birthdate of Teacher5 email NOT NULL Varchar2 40 Email of Teacher6 pass NOT NULL Varchar2 50 Password of Teacher7 mob NOT NULL Varchar2 60 Mobile number of Teacher8 add NOT NULL Varchar2 30 Address of Teacher9 rdate NOT NULL Date 30 Register of Teacher10 sid FK int 40 Foreign Key of Student idQUERY: CREATE TABLE teacher_db (tid int (30)NOT NULL PRIMARY KEY, fname varchar2(50) NOT NULL, lname varchar2(50) NOT NULL, bd varchar2(50) NOT NULL,email varchar2(40) NOT NULL ,pass varchar2(50) NOT NULL,mob Varchar2(60) NOT NULL , add Varchar2(30) NOT NULL, rdate varchar2(30) NOT NULL, sid int(20), FOREIGN KEY (sid) REFERENCES Student_db(sid));60960029210000SNAPSHOT: 3) Student:- Table 7.1.

3.1: TABLE DETAILTable Name student_dbPurpose Register Every StudentsPrimary Key: sidForeign Key: -Table COLUMN DETAILNo Field Name Constraint Data Type Size Description1 sid PK Int 30 Primary Key2 fname NOT NULL Varchar2 50 Username of Student3 mname NOT NULL Varchar2 50 Middle Name of Student3 lname NOT NULL Varchar2 50 Lastname of Student4 bdate NOT NULL Varchar2 50 Birthdate of Student5 parent_no NOT NULL Varchar2 50 Mobile number of Parent6 address NOT NULL Varchar2 60 Address of Student7 rdate NOT NULL Varchar2 30 Registration Date of Student8 class NOT NULL Varchar2 30 Class of Student9 section NOT NULL Varchar2 40 Section of Student QUERY: CREATE TABLE student_db (sid int (30)NOT NULL PRIMARY KEY, fname varchar2(50) NOT NULL, mname varchar2(50) NOT NULL ,lname varchar2(50) NOT NULL, bdate varchar2(50) NOT NULL,parent_no varchar2(50) NOT NULL , address Varchar2(30) NOT NULL , rdate varchar2(30) NOT NULL ,class varchar2(30) NOT NULL,section Varchar2(40) NOT NULL);65151029210000SNAPSHOT: Validation 7.2.1 Required Field Validator: It is used when the end user has to fill the field mandatorily.

Or else it shows an error message and prevents redirecting the page7.3 Screenshots 17082239739800 7.3.1 Homepage:321317276007.

3.2 Registration Page7.3.3 Login Page6431098053300 Application Kyc project is all about informing and a warring parents about their child and make them feel free for their child’s bright future. It make consistency or good relationship with their teachers.

7.5 RequirementsUser or parent must need smartphone. The smartphone must have internet access.7.

6 AdvantageUser-friendlySecureEasy to maintainAccurate Can be accessed from any placeDigitalizedFasterChapter – 8 Testing 8.1 Testing Strategy 8.2 Testing Methods8.0 Testing8.1 Testing StrategyThere are different types of software testing strategies, which are selected by the testers depending upon the nature and size of the software. The common view of Testing is to prove that there is no error. To make this prove we can use various testing strategies:1. Unit Testing:It is smallest part of software system which is testable it may include code files, classes and methods.

Unit is a process of validating such small building block of a complex system, much before testing an integrated large module or the system as a whole.2. Integration Testing:Integration is defined as a set of integration among component. Integration Testing addresses the issues associated with the dual problems of verification and program construction. Integration testing can beTop Down integrationBottom Up integration3. System Testing:In this, software and other system elements are tested as a whole.

System Testing verifies that all elements mesh properly and the overall system function performance are achieved8.2 Testing Methods1. White Box Testing:White Box Testing is used as an important primary testing approach. Code is tested using Code scripting, driver, etc. that are employed to directly interface with and drive this code.2.

Black Box Testing:In black box testing, the output of the module and software is taken into consideration i.e. whether the software gives proper output as per the requirements or not. This can be done in input interface processing and output interface.Chapter – 9 Conclusion Our product will be helpful to maintain student history which is maintaining manually in some of area’s till now which will be beneficial to the schools and also beneficial to the parents who always remain tense about their child.Future enhancements:We can add further functionality like generating Auto time-table and other functionality which should be helpful to any school management.

Chapter – 10 References1. Bootstrap the most popular HTML, CSS, and JS library in the world. 15/7/2018 5.

20 pm2. Data Flow Diagram – Everything You Need to Know – Smart Draw 21 September, 2018, 11:30 a.m.3. Java EE version history – Wikipediahttps://en. 14/7/2018 11.35 am4. Java Tutorial | Learn Java – Javatpointhttps://www.javatpoint.

com/java-tutorial 21/9/2018 3:37 PM6. JDBC 4.0 Introduction – Tutorial Point 21/9/2018 4:10 PM7. JDBC 4.0 Introduction – Javatpointhttps://www. 21/9/2018 4:10 PM8. JSP Tutorial – Javatpoint 21/9/2018 3:45 PM9.

JSP Tutorial | Study tonight 21/9/2018 4:00 PM10.

JSP Tutorial – Javatpoint 21/9/2018 3:45 PM11. JSP Tutorial | Study tonighthttp://www.studytonight.

com/jsp/introduction-to-jsp.php 21/9/2017 4:00 PM12. Jsp Hibernate-Javatpoint 1/10/2018 3:45 PMAll Canvas Snaps…1) AEIOU Canvas 4539551106000323850352425002) Empathy Canvasright316418003) Ideation Canvas257175352425004) Product Development Canvas


I'm Owen!

Would you like to get a custom essay? How about receiving a customized one?

Check it out