The intent of the practical schoolroom system is to incorporate the benefits of a physical schoolroom with the convenience of a “no-physical bar” practical acquisition environment. It will usher in the huge flexibleness and edification in the bing acquisition platform constructions. with the perfect blend of synchronal and asynchronous interaction. It provides a agency of collaborative acquisition for the pupils.
Scope: This undertaking has a batch of range for future development. Developing a practical schoolroom system to advance a greater count of pupils to fling into the field of Education.
Problem Statement:
The inquiry of which learning methodological analysis is better. traditional or practical. is ever a perplexing one. Traditional schoolroom instruction methodological analysiss are well-tested. and the environment most of us grew up in. but they have some major restrictions. Virtual schoolrooms. on the other manus. are new and high tech.
The term “traditional classroom” brings to mind visions of a schoolroom of 20 or more kids. all approximately the same age. listening raptly to the teacher or instructor. while all working diligently at their surveies. The world is far different.
In a traditional schoolroom environment. there are normally anyplace from 20 to thirty kids and one instructor. In some instances. that instructor might hold a “teacher’s aid” or an adjunct instructor. This is where the disadvantage starts- it is merely impossible for one individual to give each pupil the one-on-one attending or direction that may be required. In order to avoid these job there is need t set up a system which provide epicurean manner of learning. The system which is much flexible for instructor and every bit good as for pupils. Our undertaking will besides supply aid in conformity of this job.
Overview:
Developing a practical schoolroom system to advance a greater count of pupils to fling into the field of Education. It integrates the benefits of a physical schoolroom with the convenience of a ‘no-physical bar’ practical acquisition environment. minus the commutation jeopardies and disbursals. It will usher in the huge flexibleness and edification in the bing acquisition platform constructions. with the perfect blend of synchronal and asynchronous interaction. It provides a agency of collaborative acquisition for the pupils.
Lectures
Class Diagram:
A Class is description of a set of objects that portion the same properties. operations. relationships and semantics. Graphically it is rendered as a rectangle. An Property is named belongings of a category thatdescribes a scope of values that cases of the belongings may keep. A category may hold many properties orno properties at all. An property represents some belongings of the thing you are patterning that is sharedby the objects of the category. They are shown in the compartment under the name of the category. AnOperation is the execution of a service that can be requested from any object of the category to affectbehavior. They are written in the last compartment in the category word picture.
ER Diagram ( Entity Relationship Diagram ) :
Relational Schema:
Relationship Table:
Function
create table Role ( Role_id INT AUTO_INCREMENT NOT NULL. Role_name varchar ( 10 ) NOT NULL. primary key ( Role_id ) ) ;
Department
create table Department ( Department_id INT AUTO_INCREMENT NOT NULL. Department_name varchar ( 10 ) NOT NULL. primary key ( Department_id ) ) ;
Course
create table Course ( Course_id INT AUTO_INCREMENT Not NULL. Course_namevarchar ( 10 ) NOT NULL. course of study varchar ( 10000 ) . primary key ( Course_id ) ) ;
User
create table User ( User_id INT AUTO_INCREMENT NOT NULL. User_name varchar ( 10 ) NOT NULL. User_passwd varchar ( 30 ) NOT NULL. Course_id INT NOT NULL. Department_id INT NOT NULL. primary key ( User_id ) . FOREIGN KEY ( Course_id ) REFERENCES Course ( Course_id ) on DELETE CASCADE ON UPDATE CASCADE. FOREIGN KEY ( Department_id ) REFERENCES Department ( Department_id ) on DELETE CASCADE ON UPDATE CASCADE ) ;
Attendance
create table Attendance ( Attendance_no INT AUTO_INCREMENT NOT NULL. Date day of the month NOT NULL. twenty-four hours varchar ( 15 ) NOT NULL. User_id INT NOT NULL. Course_id INT NOT NULL. position varchar ( 10 ) NOT NULL. PRIMARY KEY ( Attendance_no ) . FOREIGN KEY ( Course_id ) REFERENCES Course ( Course_id ) on DELETE CASCADE ON UPDATE CASCADE. FOREIGN KEY ( User_id ) REFERENCES User ( User_id ) on DELETE CASCADE ON UPDATE CASCADE ) ;
Assignment
create table Assignment ( Assignment_id INT AUTO_INCREMENT NOT NULL. Given_date day of the month NOT NULL. Due_date day of the month NOT NULL. Course_id INT NOT NULL. Assignment_que varchar ( 1000 ) NOT NULL. Assignment_ans_file varchar ( 10000000 ) NOT NULL. Assignment_markint non null. PRIMARY KEY ( Assignment_id ) . FOREIGN KEY ( Course_id ) REFERENCES Course ( Course_id ) on DELETE CASCADE ON UPDATE CASCADE ) ;
Question_bank
create table Question_bank ( Question_bank_id INT AUTO_INCREMENT NOT NULL. Question_bank_name varchar ( 15 ) NOT NULL. Course_id INT NOT NULL. Question_bank_que varchar ( 1000 ) NOT NULL. Question_bank_ans varchar ( 100000 ) NOTNULL. PRIMARY KEY ( Question_bank_id ) . FOREIGN KEY ( Course_id ) REFERENCES Course ( Course_id ) on DELETE CASCADE ON UPDATE CASCADE ) ;
Lectures create table Lectures ( Lecture_id INT AUTO_INCREMENT NOT NULL. Lecture_name varchar ( 15 ) NOT NULL. Course_id INT NOT NULL. Lecture_note varchar ( 10000000 ) NOT NULL. PRIMARY KEY ( Lecture_id ) . FOREIGN KEY ( Course_id ) REFERENCES Course ( Course_id ) on DELETE CASCADE ON UPDATE
Decision:
At the terminal of the twenty-four hours. practical schoolrooms can salvage your organisation money. let greater flexibleness in the bringing of your preparation. and do your work force more productive and effectual. This allows for real-time presentations. inquiries. replies. and peer to peer coaction. None of the traditional facilitation techniques are lost. Surprisingly. with the usage of practical schoolroom engineering. some of these techniques. like equal to peer interaction. are enhanced. The ability to come together in this practical manner saves organisations 10s of 1000s of dollars every twelvemonth.
