course management system project report

CODING, TESTING, IMPLIMENTATION AND MAINTENANCECODING TESTING IMPLIMENTATION MAINTENANCE 7. 4.5.3. ACADEMIC HISTORY:Before normalization the table was as follows:5.1.6.1 ACADEMIC:ROLLNO CLASS 25 COURSE MANAGEMENT SYSTEM NAME OF BOARD/UNIVERSITY PASSED (NOBU) NAME OF SCHOOL/COLLEGE PASSED (NOSC) ANNUAL/SUPPLIMENTARY (STATUS) MAXIMUM MARKS (MAXMARKS) MARKSECURED (MARKSEC) DIVISION YEAR OF PASSING (YOP) 1NF: It is already in 1NF. It lists the relations to be scanned in the evaluation of the expression. After the user has successfully logged into the system he will get the main screen, where he will find different options to which he is authorized to.

Logical structure: 1. When a client requests a JSP page of the web server and it has not been run before, the page is first passed to the JSP engine which compiles the page to a servlet, runs it and returns the resulting contents to the client. 3.2.1.3 Observations The project references and manuals were observed which helped in understanding the system in a better way. : Netscape and Internet Explorer. So, after 2NF the relation will as follows:(I) EXAMINATION DETAIL (II) MARKS DETAIL 5.1.7.2. It identifies a unique student by his/her registration number. You will notice that many sections in this chapter refer to classes and methods as follows: The javax.servlet.jsp.JspPage interface contains 2 methods: Methods Public void jsplnit() Usage This is invoked when the JSP is initialized. His/Her Homework and Uploads The He/She Can Also Check The grades provided by the Instructor for His/Her Homework. Economical Feasibility: Whether there are sufficient benefits in creating the system to make the costs acceptable or not and the costs of not creating so great that the project must be undertaken. jA,(Z7%j-odJ|2)4e|6-+cas-Sml4l @@8p6-Xkk/hZbCcZ5L(d^ae!hGdHd l Viktige detaljer inkluderer tidligere problemer eller klager fra pasienter og ansatte som bruker anlegget. Data Security: The data stored in the registers and books is not secure as any unauthorized person can access the data at anytime without the will and permission of the administration staff. 6.2 Testing Every software developed must be tested for its efficiency and consistency.

2. The recommended file extension for the source file of a JSP page is .jsp. Sjekk om kirurgen din er kvalifisert. [emailprotected] 6.4.1 Database Backup and Recovery: A DBMS must provide facility for recovering from hardware or software failures. Such clients are called as fat clients. These registers are related to each other by the students roll number. D.1.1 Why learn JavaScript With HTML you are restricted to creating static, non interactive web pages. Feasibility Study An important outcome of the preliminary investigation is the determination of whether the system requested is feasible or not. Because it is already in 2NF and all non-key attributes fees and fines are independent to each other.

One or more control files. endstream endobj 8 0 obj<>/ProcSet[/PDF/Text]>>/Type/Page>> endobj 9 0 obj[10 0 R] endobj 10 0 obj<>/A<>/PA<>/Border[0 0 0]>> endobj 11 0 obj<>stream 4.4.2. The two main advantages for client-applications are clear: quicker development through the reuse of pre-built business-logic components and a shorter test phase, because the servercomponents have already been tested. The advantages of JSP are twofold.

Course: College provides different combination of courses for different streams-Arts/Science/Commerce and wings +2/+3/P.G.Each course have course name and course id. 4.5.2. Data Duplicacy: Before entering every record they have to make sure that the same record doesnt exist. 40 COURSE MANAGEMENT SYSTEM C.5 JSP Elements JSP elements are the part of the JSP page which is processed on the server. Namely: Unit testing and Integrated testing 6.2.1 Unit testing 31 COURSE MANAGEMENT SYSTEM The unit testing used to feed the functionality & reliability of individual modules developed separately.

Basing on his requirements he will get the list of the colleges or universities present in that location offering that course. (ii)Foreign key:-Suppose student relation is having student# and it uses dept# for relating with department relation and the dept# is the primary fey of the relation department. 3.2.1.2 Record Reviews A variety of journals, reports and official documents were shown to us to know the status of the existing system.

EMg5G*I*mwJW]+)Ql5 b{Q(Lxb^&%"yGiE O;8IohlKaw\mdVt{Ez>o\sQYM]3O,4+$w!M6u}};9WH#uV3xDre5_Y*'kg6c6TuuJgjd6;SwjYj9{h604:ji5eSY#B?C^GVMKhOd\\v/rQ"iCY \-oV:@m#4#Jb/\$K}IK{5(@l,^24REV:e^;]%d8AI)mbP1V Y*~t1PxQ"MmY`TkY=)mdO39hiJs:i1gB{4tyYPM06V]B ,N VxA8v|WSAE Technical feasibility on the key points. Les Denne Artikkelen Frst!

based application for the online implement, Courseware Management System All rights reserved. Each table space has one or more data files. RDBMS offer a certain independence from storage details for the clients. 5.1 NORMALIZATION 5.1.1 STUDETAIL:Before normalization the STUDETAIL table was as follows:5.1.1.1 STUDETAIL:ROLLNO NAME DOB REGDNO SEX RELIGION CATEGORY NATION MS DOA MTONGUE TCNO FNAME FOCCUPATION STAYING WITH PRESENT ADDRESS PERMANENT ADDRESS COURSE TAKEN 1NF: The relation STUDETAIL is not in first normal form because the attribute COURSE TAKEN is a multivalued attribute. 2NF: The relation is already in 2NF. System implementation contains: System Manual User Manual 6.3.1 System Manual: This has all information about hardware and software requirements, and how the system is to be installed. (2)TUPLE: Rows of each table are referred as a tuple. SQL user a combination of relational-algebra and relational-calculus constructs. Hvis du er det, er det veldig viktig sette seg ned med deg selv. 2.3.2.BASIC STRUCTURE OF PL/SQL BLOCK DECLARATION EXECUTION OF STATEMENTS ERROR HANDLING 8 COURSE MANAGEMENT SYSTEM EXAMPLE: declare xyz number (3); begin select 12*12 into xyz from dual; insert into temp values (xyz); end; Here xyz is an integer declared, dual is a dummy table, and temp is an existing table. C.4: The Life Cycle of a JSP Page A JSP page services requests as a servlet. It has attained its primary position because of its simplicity, which eases the job of the programmer, as compared to earlier data models such as the network model. This makes maintenance expensive. Hence, after normalization the relation will as follows:5.1.6.2 ACADEMIC:ROLLNO CLASS NAME OF BOARD/UNIVERSITY PASSED (NOBU) NAME OF SCHOOL/COLLEGE PASSED (NOSC) ANNUAL/SUPPLIMENTARY (STATUS) MAXIMUM MARKS (MAXMARKS) MARKSECURED (MARKSEC) DIVISION YEAR OF PASSING (YOP) 5.1.7. Many concurrent database users:It supports a large no. En kosmetisk kirurg vil at du skal ha din ideelle vekt for f en vellykket prosedyre, Poenget: Kosmetisk Kirurgi Og Kroppen Din, Solid Kosmetisk Kirurgi Informasjon Nr Du Vurderer Dette Alternativet. Scattered Data: When all the data about a particular student is needed, the employee has to search for all the scattered records which takes a long time to collect. CONTENT 1.

De fleste prosedyrer handler bare om en forbedring i forhold til hvordan du allerede ser ut, og vil ikke skape et nytt ansikt. SYSTEM DESIGNNORMALISATION DATA DICTIONARY INPUT DESIGNS 6. 143 0 obj <> endobj

Thus, PL/SQL is the combination of data manipulating power of procedural languages. Through this separation more clients are able to have access to a wide variety of server applications. i. Instructor Logins to the System. Than He Completes Homework. iii. 9. Therefore majority of the business logic i.e., validations etc. So the table will be as follows:5.1.1.2.STUDETAIL:19 COURSE MANAGEMENT SYSTEM ROLLNO NAME DOB REGDNO SEX RELIGION CATEGORY NATION MS DOA MTONGUE TCNO FNAME FOCCUPATION STAYING WITH PRESENT ADDRESS PERMANENT ADDRESS COMPULSORY 1 COMPULSORY 2 OPTIONAL 1 OPTIONAL 2 OPTIONAL 3 FOURTH OPTIONAL COMPULSORY 1 COMPULSORY 2 COMPULSORY 3 COMPULSORY 4 MAJOR ELECTIVE MINOR ELECTIVE CORE COURSE 1 CORE COURSE 2 CORE COURSE 3 CORE COURSE 4 STATUS 2NF: The relation STUDETAIL is already in 2NF as it is in 1NF and all non-key attributes are dependent on key attribute ROLLNO. However, commercial database systems require a query language that is more users friendly. 0000007002 00000 n We also observed the problems faced by the staff members in all areas of this system. By referring this record one can get the complete data of the student. 39 COURSE MANAGEMENT SYSTEM C.3: Architecture of JSP A JSP is simple text file consisting of HTML content along with JAVA code called as JSP elements. It can define the structure of the data, modify data in the database, and specify security constraints. Because it is already in 1NF and all non-key attributes fees and fines are fully functionally dependent on ROLLNO. 4.1. They are if the student had taken part in NCC, NSS, Sports or any other cultural activities. COURSE MANAGEMENT SYSTEM CONTENT 1. hello, sir error occurs master page does not load what should I do for this humbly request is that to solve that error thank you. The JSP elements in a JSP page can be expressed in two syntaxes standard and XML ---- through any given file can use only one syntax. `l+6]#G-F =^mJ2m9VJ "a=[g`8%\g-1Yf:(&`AC:pCIqvi(C)]s4eL3Ype9%9sz(u%3,MY5gp[)9{Pz(6N(YSk:YahA_]=ie%(W Y3\XG0b72-MX]ppY}%J~B:ATex~@4B^R{|0!l7(^uOnIfAhpv=2pJyP-jUCtHVh[$y&f:JuRxT`+"U0$YDv_]X) )WEO ~4 Y"dW[yiLIsgIkeK f8PA'. JavaScript is also is a powerful means of controlling events in browser and accessing the Document Object Model (DOM) for programming DHTML. Spesielt hvis du kan bevise at du trenger f prosedyren utfrt av medisinske rsaker. G/mw3i PklHww~^/w7u`Hla"foaJl}9xi:Dk# !o 7 COURSE MANAGEMENT SYSTEM Example: Select A1,A2,,An From T1,T2,,Tm Where P Each Ai represents an attribute, and each Ti represents a relation. Hvis kirurgen er styresertifisert, og spr om eventuelle klager. One is how users specify request for data: Which of the various query languages they use? 0000003627 00000 n Expressions. Some of the salient features of this system being: Highly User Friendliness Highly Interactiveness Secured Data Authorized User Entry Changing Own Password Administrator Privileges Data backup & Recovery system Highly Multiquery flexible Efficient error trapping Better Reporting facility This system can also be further developed by even adding Student Admission System to it and generating the roll numbers to the students by computerized method. 2.3.1. He also then gets the 34 COURSE MANAGEMENT SYSTEM main screen with all the privileges. Manageable Security:To protect against unauthorized data base access and use Oracle provide fail and safe security feature to limit and minitror data access. 2.1.4. 3. trailer Hence, after normalization the relation will be as follows:5.1.4.2 DUES:ROLLN O 24 COURSE MANAGEMENT SYSTEM YEAR FEES FINES 5.1.5 SPECIAL PERFORMANCE:Before normalization the table was as follows:5.1.5.1 SPECIAL:ROLLNO NCC NSS SPORTS CULTURAL 1NF: The relation is in 1NF. 3NF: The relation is already in 3NF. 4.4.1.4 COURSE:{C_id, C_name}.

0000001738 00000 n HAS:It is a one-to-one relationship set that associates the entity set STUDENT and the entity set ATTENDANCE. 2.1. Most widely used query language is SQL (Structured Query Language). An Oracle database logical structure is determined by one or more table spaces. Net Project Source Code, Report. With JavaScript, you can change that.

6.3 IMPLIMENTATION After all the coding is over and testing is over from end users and officials the next step is system implementation. 11. The backup and recovery subsystem of the DBMS is responsible for recovery. Each Oracle database is comprised of three types of files. 2 COURSE MANAGEMENT SYSTEM 1.2 CONCLUSION:Online course portal project is developed in java platform. 0000005257 00000 n The proposed system is based on exactness of the current system. They are: Wastage Of Time: The staff was wasting a lot of time in entering the data into the different type of registers of all students. 2.1.3. of concurrent Data base users executing a variety of data base application. 6. Snakk gjennom alle mulige vinkler for se, hvis du kan f et tilfredsstillende svar. RDBMS, FRONT END TOOLS AND OVERVIEWRELATIONAL DATABASE SQL PL/SQL OR, Project Report on CONTENT MANAGEMENT SYSTEM Submitted as a part of course curriculum for the partial fulfillment of the, CMS (CONTENT MANAGEMENT SYSTEM) Content Management System adalah suatu sistem yang digunakan untuk mengelola dan memfasi, Synopsis of Content Management System endstream endobj 158 0 obj<> endobj 159 0 obj<> endobj 160 0 obj<> endobj 161 0 obj(/GKs={5-k) endobj 1 0 obj<>/ProcSet[/PDF/Text]>>/Type/Page>> endobj 2 0 obj<>stream In this Course Management application, only Student Module is present. The where clause corresponds to the selection predicate of the relational-algebra. It shows in which language the student used to talk with other at home/other places in general such as Oriya/Hindi/Bengali/Telug u etc. In contrast to the 2-tier model, where only data is accessible to the public, business-objects can place applications-logic or "services" on the net.

D#]I3yTKE;A"9 ! l>PO9-$(98U'qy:3O[\x|x!_a[X9?Z5Nn-/Lm772sd,qQ+N2-ESf)+KeIVqvz>gD vXTgXkc|6C;[n?Y? Existing system design The Course Management System project deals with the overall details of the student after admission. Compilation problem is isolated. OF WORKING DAYS (NOWD) and MONTH are fully functional dependent on the key attributes ROLLNO and YEAR. The following are the advantages in the web server. Formatted and efficient reports generations as per the clients requirements. 4.3.2.1.

6.3.3 User Manual: Course Management System (SIS) is a user friendly and interactive project based on Graphic User Interface system.

ENTITY SETS:- 4.4.1.1 STUDETAIL:{ Roll no, Name, Date Of Birth, Registration Number, Tc Number, Sex, Religion, Category, Nationality, Marital Status, Mother Tongue, Fathers Name, Fathers Occupation, Course Taken, Staying With, Date Of Admission, Phone, Present Address, Permanent Address }. 2NF: It is already in 2NF. Du kan ha ls hud rundt mageomrdet forrsaket av graviditet eller raskt vekttap. STUDENT: ROLL NAME COURSE 1 Smith CS 2 Black Physics 3 Brown CS 4 John Chemistry 5 George Physics 3 COURSE MANAGEMENT SYSTEM In the above table student each row corresponds to one student. It can also thought as stored query. 1. The project will be then automatically installed. 6.4 MAINTENANCE: The main aspect of maintenance is providing Database Backup and Recovery, Import and Export. Controlled availability:Oracle ca n selectively control the availability of data at the data base level and sub data level. If the user enters any kind of peculiar data or invalid data the system produces an error message and guides the user for correct data entry. It shows the permanent state name of the student where he/she is staying permanently while studying in the college. Selv om valgfrie prosedyrer ikke dekkes, vet du aldri fr du prver. For example when we read our email, we are viewing passive data. 2.2. 7oX6RjU;j D41/c.wk(U(t;Bay1_~OL*%1;NJ(`CeDg^`Z$v+[ fg =/^pIB7Ho^+t1R;Tu|:v.4l=/hzt+|(43c]C8MKGs9%pw:C7\o54# Hence, by making two relations the relation can be made in 2NF.

Click Finish viii. HTML documents are plain text (also known as ASCII) files that can be created using any text editor (e.g.). It shows the contact number of the student if he/she has the telephone facility.

Large data bases and space management control:Oracle supports the largest of Databases. 143 20 0000004897 00000 n The middle tier, or business layer, consists of the application or business logic and the third tierthe data layer contains the data is needed for the application. HVn8}7HdIe9[]tK"qPc+E{|IZl $5.

0000000016 00000 n The files of a database provide the actual physical storage for database information.

3.2.1 Existing Systems Investigation We made a preliminary survey of the Course Management System of the college i.e., how and what information about a 11 COURSE MANAGEMENT SYSTEM student is stored, how many different kinds of records are maintained, in what way they are maintained and what do they contain. 3NF: It is already in 3NF. Synopsis of Content Management, A PROJECT REPORT On Software specified Hardware specified Availability of skilled person to operate the system 4.3.2. These are clusters, tables, views, sequences, stored procedures. 2. Inefficient Reports: The report required by the management cannot be obtained immediately and it requires extensive effort by the staff and officials to generate a simple report, which is often error prone.

0000008186 00000 n 0000001235 00000 n As all attributes values are atomic data items. Then we asked for their time and availability so that we could interact with them. The student must register into the application by providing all the basic and general information after registration student can log in with the default username and password, the student can change the password and he can also recover his password if he forgot the password. It permits two types of authorized people. This method had inflated scope of on-line education and on-line courses.

In this Course Management application, we are having the only module is Student. Course Management System tool is a web application which is useful for students who are going to choose any college or course in higher education, for them this application is helpful to make the correct the decision with the accurate information.

IMPROVED PERFORMANCE: Instead of sending the SQL statements one by one, In PL/SQL the entire blocks of statements can be send to the RDBMS at one time. Distributed Data Base System:Oracle combines the data physically located on different computer to one logical data base that can be accessed by all data base users. Usage This method corresponds to the body of the JSP page and is used for threaded request processing, just like the service () method in the servlets. WX4E+\xaE[Mpz& Snakk med forsikringsselskapet direkte om betaling for prosedyren for plastisk kirurgi. t> Thereafter, the Web servers servlet engine will run the compiled page. In the Proposed Course Management System the student just needs to utilize the search form present in student home page and entering his requirements he can view all the information he needs in just a matter of seconds. Each row in the table represents a collection of related data values, and each row is a record. OF DAYS PRESENT(NODP) The relation ATTENDANCE is in 1NF as all its attributes values are atomic data items. An application is broken up into three separate logical layers, each with a well-defined set of interface. Open control panel. 10 COURSE MANAGEMENT SYSTEM Table space: A database is divided into logical storage units called table space. The database schema objects.

An Oracle database has both the logical and physical structure. Sequence: A sequence simplifies the application program by generating a serial list of unique numbers for a numeric column in database. OF WORKING DAYS(NOWD) NO. xref Because it is already in 1NF and all its non-key attributes NCC, NSS, SPORTS, CULTURAL are fully dependent on ROLLNO. Thus the life cycle and many of the capabilities of JSP pages (in particular the dynamic aspects) are determined by JAVA servlet technology. The SQL DCL provides commands for securing the database. Doing which the system would have been more efficient than what they are now. For example, a program might be provided by the server to display properly the data that the server is sending. A domain is a pool of values from which the actual values appearing in a given column are drawn. Installation: To install the Course Management System project go to the Package folder and open it. One or more data files. [i_vMt:vJoQ.<9[IJ;oK(4VR`[lNJQ&G+/u[ZLX~ gl>L{)tNl`dq]i[ORA7V*'S3y\Bl PXyc%A+'EjVJ(`Bf0PMU5Z=0m 8] WN'vO*B.5u%;r/WWK@%*_hmM!@U{?dI"JA(9 R"XgXft%*z1;t6pNA'D+xn'9e)yO4!`a huK". There are 3 Modules for The Admin, Instructor and Students Respectively. underske sykehuset der operasjonen skal utfres er et utmerket trinn i beslutningsprosessen. As all its attributes values are atomic data items. FOCCUPATI- CHARACTE ON R 20 It shows the designation of the students father. 4.3.1. 33 COURSE MANAGEMENT SYSTEM After the successful installation of the project we will find the Course Management System under programs in start menu. Actors of the Courseware Management System. ADVANTAGES OF PL/SQL: PROCEDURAL CAPABILITY: Loops, branching assignments etc are used in PL/SQL which is used in traditional programming languages. .hide-if-no-js { This also means that every client has to be trained as to how to use the application. unique COURSE MANAGEMENT SYSTEM NAME 30 DOB CHARACTE R DATE REGDNO VARCHAR2 10 SEX CHARACTE R 1 RELIGION CHARACTE R 10 CATEGORY CHARACTE R 3 NATION CHARACTE R 10 MS CHARACTE R 1 DOA DATE 7 MTONGUE CHARACTE R 10 TCNO VARCHAR2 10 FNAME CHARACTE 30 7 29 It shows the name of the student. 4.4.1.3 SPECIAL:{Roll no, Nss, NCC, Sports, Cultural Activities}. RELATIONAL DATABASE A relational database is a shared repository of data. Relational Algebra: In which specialized operators are applied to relations. 0000001419 00000 n Dynamic load balancing: if bottlenecks in terms of performance occur, the server process can be moved to other servers at runtime. RELATIONAL MODEL The relational model is today the primary data model for commercial data-processing applications. MAY HAVE:It is a one-to-many relationship that associates the entity set STUDENT and the entity set SPECIAL PERFORMANCE. In the Proposed System , The Teachers and Students Can maintain their courses Online, in a Easy and User friendly environment. Namely Users and Administrator Users: These are the authorized people who can login and do the following jobs: Data Entry Data Modification Report Generation Administrator: He is the prime authority of the project. (4)RELATION: Tables are usually referred as relations. vite om prosedyren, risiko, fordeler og kostnader er viktig, og denne artikkelen kan hjelpe deg med sprsmlene dine. Industry accepted standards:It satisfy the require standard for the data access languages, operating system user interface and networking command protocols.

Aldri g til et sykehus eller klinikk uten frst sjekke legitimasjonen. BuiltIn Objects: JavaScript provides various built in objects (like String, Date etc) and functions for validating used inputs, changing contents or appearance of a document etc.

Instructor Checks the Uploaded Homeworks and Grades The Students. For HTML writers, the easiest way to being adding dynamic aspects to a web page is through client-side scripting using JavaScript or VBScript. 4.5.7.Exam Details: An exam detail report of each student is maintained, this shows the examination status of the student. 2NF: It is already in 2NF. OF WORKING DAYS(NOWD) NO. In the above table of student ROLL is a domain .Precisely speaking each column in the table is a domain. the Student appeared the examination or not), Examination Name, C_id, Maxmarks, Marksec}. In a network two very broad categories of objects are transmitted between the server and client: passive information and dynamic, active programs. Data Modification: Here the user can modify the data if suppose he thinks that he has entered any wrong data. So by making COURSE TAKEN into atomic data items the relation can be converted into 1NF. As for 1NF the attribute of the relation should be atomic data items. Then dept# is the relation Student is the foreign key for the relation student.

0000008372 00000 n Academic History: College maintains the academic history of the exams passed by the student. An expression language for accessing server-side objects.

Your email address will not be published. It shows the present citys code or pin number of the student where he/she is staying presently while studying in the college. 36 COURSE MANAGEMENT SYSTEM Figure B.1 2-Tier Architecture B.2: 3-Tier Architecture To over come the demerits of 2-tier architecture, 3-tier architecture model is proposed. 41 COURSE MANAGEMENT SYSTEM D.1.2 What can JAVA Script Do Dynamic Web Pages: JavaScript can perform actions such as generating HTML code that affects the display or the contents of the document in the Browser.

As all the attributes values are atomic data items. Built in web server There are two types of architectures of the web server: 2-Tier Architecture 3-Tier Architecture B.1: 2-Tire Architecture In the traditional 2-tier architecture there existed only the server and the client. Therefore it makes sense to run critical business processes that work with security sensitive data, on the server. Hvis prosedyrene er sentrert rundt kroppskonturering, m du huske at dette ikke er en vekttapsprosedyre, men bare vil forbedre kroppsformen din noen f grader.

However a second type of object can be transmitted to the clients computer yet is initiated by the server. We were also given to observe the type of reports that are generated and the references made for the generation of those reports. It shows the permanent city name of the student where 30 COURSE MANAGEMENT SYSTEM PERSTATE CHARACTE R 20 PERPIN NUMBER 6 he/she is staying permanently while studying in the college. This may lead to the confusion while retrieving the data about a particular student unless he mentions his year of joining. whether Indian/Others. Business-objects and data storage should be brought as close together as possible, ideally they should be together physically on the same server. The different types of reports prepared by the clerks where also studied to visualize and characterize the system, its integrated components and operational use.

Sitemap 9

course management system project report

course management system project reportdunelm made to measure blinds

Contact