Answer to Question #241106 in HTML/JavaScript Web Application for Sello

Question

Develop an Institution management system (based on VB.NET platform) linked with Microsoft Access Database as infrastructural support. The primary purpose of this application is to automate students, modules, staff’s information and other data resources. 

Answer 1

1.Create a Student Table with all the required columns having the student's information.Given below is a Sample query to create a Student Table.

CREATE TABLE STUDENT(STUDENT_ID INT NOT NULL,NAME VARCHAR (20) NOT NULL,FEES BIGINT NOT NULL,

ADDRESS VARCHAR (50), COURSE VARCHAR (50),

HEAD_FACULTY VARCHAR (20), PRIMARY KEY (STUDENT_ID));

Note:You can add More columns if you need.

2. Create a Faculty Table with all the required columns having the student's information. Given below is a sample query to create a Faculty Table.

CREATE TABLE FACULTY(FACULTY_ID INT NOT NULL, NAME VARCHAR (20) NOT NULL,
SALARY DECIMAL(18,2) NOT NULL,
ADDRESS VARCHAR (50), PRIMARY KEY (FACULTY_ID));

Note: You can add more columns if you need.

3. Create a Course Table with all the required columns having the student's information. Given below is a sample query to create a Course Table.

CREATE TABLE COURSE(COURSE_ID INT NOT NULL, COURSE_NAME VARCHAR (20) NOT NULL,
COURSE_DETAIL VARCHAR (100) NOT NULL,COURSE_FEE DECIMAL(18,2) NOT NULL,
COURSE_CODE VARCHAR (20) NOT NULL,COURSE_DURATION INT NOT NULL,
PRIMARY KEY (COURSE_ID));

Note: You can add more columns if you need.

4. Create a System User Table with all the required columns having the student's information. Given below is a sample query to create a System User Table.

CREATE TABLE SYS_USER(USER_ID INT NOT NULL, USER_NAME VARCHAR (20) NOT NULL,
PRIMARY KEY (COURSE_ID));

Note: You can add more columns if you need.

5. ADD Queries for adding details

INSERT INTO STUDENT(STUDENT_ID,NAME,FEES,ADDRESS,COURSE,HEAD_FACULTY)
VALUES(123456,'Rohan kapoor',45000,'Pune','Electronics','Rohit Kumar');

Note: Similar Queries for other ADD operations.

6. UPDATE Queries for editing details

UPDATE STUDENT SET FEES = 65000 WHERE STUDENT_ID = 123456;

Note: Similar Queries for other UPDATE/EDIT operations.

7. SELECT Queries for listing all the details

SELECT * FROM STUDENT;

Listing details based on some condition.

SELECT * FROM STUDENT WHERE COURSE = 'Electronics';

Note: Similar Queries for other SELECT operations.