Project Title: LearnSmart Exam

Project Title: LearnSmart Exam

This is web application used by any Training Institute to conduct the various exams of the student. It enables institute and schedule the exams for the student. Students can give online exams and get the student performance. It will have two modules –

1. Company Admin
2. Student

Company Admin: Company admin can configure the exam software which contains following activates –

1. Configure – Subject, Topic, Courses, Categories
2. Manage Students, Register, Activate, De Activate Students.
3. Exams – Exams, Questions, Results, Performance

Student: – Student can login, and appear for the exams –

1. View Scheduled Exam
2. Appear for Exams
3. View Results.

GenderEnum

Male=1

FeMale=2

Other=3

DurationEnum

Days-1

Months-2

Hours-3

Weeks-4

QuestionTypeEnum

Subjective=1

Objective=2

GenderEnum

Male=1

FeMale=2

Model Name: Company
Sr. No.	Property Name	Data Type	Remark
1	CompanyID	bigint	pk
2	CompanyName	string
3	Address	string
4	EmailID	string
5	MobileNo	string
6	LogoPath	string
7	RegistrationDate	DateTime
8	CityID	FK
9	WebsiteUrl	string
10	ContactNo	string
11	ContactPersonName	string

Class Name:Country
Sr. No.	Property Name	Data Type	Remark
1	CountryID	bigint	FK
2	CountryName	string

Class Name:State
Sr. No.	Property Name	Data Type	Remark
1	StateID	bigint	FK
2	StateName	string
3	CountryID	bigint	FK

Class Name:City
Sr. No.	Property Name	Data Type	Remark
1	CityID	bigint	FK
2	CityName	string
3	StateID	bigint	FK

Model Name: CompanyAdmin
Sr. No.	Property Name	Data Type	Remark
1	CompanyAdminID	bigint	pk
2	CompanyID	bigint	FK
3	FirstName	string
4	LastName	string
5	EmailID	string
6	MobileNo	string
7	Address	string
8	CityID	bigint	FK
9	Password	string

Model Name: CourseCategory
Sr. No.	Property Name	Data Type	Remark
1	CourseCategoryID	bigint	pk
2	CourseCategoryName	string

Model Name: Course
Sr. No.	Property Name	Data Type	Remark
1	CourseID	bigint	pk
2	CourseName	string
3	CourseDescription	string
4	Duration	int
9	DurationUnit	DurationEnum
10	CourseCategoryID	bigint	FK

Model Name: StudentCourse
Sr. No.	Property Name	Data Type	Remark
1	StudentCourseID	bigint	pk
2	StudentID	bigint	fk
3	CourseID	bigint	fk
4	AssignedDate

Model Name: ExamSchedule
Sr. No.	Property Name	Data Type	Remark
1	ExamScheduleID	bigint	pk
2	StudentID	bigint	fk
3	StartDateTime	DateTime
4	ExamID	bigint	fk
5	Note	string

Model Name: SubjectCategory
Sr. No.	Property Name	Data Type	Remark
1	SubjectCategoryID	bigint	pk
2	SubjectCategory	string

Model Name: Subject
Sr. No.	Property Name	Data Type	Remark
1	SubjectID	bigint	pk
2	SubjectName	string
3	SubjectDescription	string

Model Name: CourseSubject
Sr. No.	Property Name	Data Type	Remark
1	CourseSubjectID	bigint	pk
2	SubjectID	bigint	fk
3	CourseID	bigint
4	AddedDate	DateTime

Model Name: Topic
Sr. No.	Property Name	Data Type	Remark
1	TopicID	bigint	pk
2	TopicName	string
3	SubjectID	bigint
4	TopicDescription	string

Model Name: Exams
Sr. No.	Property Name	Data Type	Remark
1	CourseExamID	bigint	pk
2	ExamTitle	string
3	NoOfQuestions	int
4	QuestionTypes	QuestionTypeEnum
5	MarksPerQuestion	int
6	IsNegativeMarking	boolean
7	PassingPercentile	decimal

Model Name: ExamsSubject
Sr. No.	Property Name	Data Type	Remark
1	ExamsSubjectID	bigint	pk
2	SubjectID	bigint	FK
3	CourseExamID	bigint	fk
4	SubjectPercentage	int

Model Name:Question
Sr. No.	Property Name	Data Type	Remark
1	QuestionID	bigint	PK
2	QuestionTitle	string
3	QuestionDescription	string
4	TopicID	bigint	FK
5	QuestionType	QuestionTypeEnum
6	FiePath	string

Model Name: QuestionOptions
Sr. No.	Property Name	Data Type	Remark
1	QuestionOptionsID	bigint	pk
2	QuestionID	bigint	fk
3	Option	string
4	IsCorrect	bit

Model Name: Student
Sr. No.	Property Name	Data Type	Remark
1	StudentID	bigint	pk
2	FirstName	string
3	LastName	string
4	Gender	GenderEnum
5	EmailID	string
6	MobileNo	string
7	Password	string
8	IsActive	boolean
9	ProfilePicture	string

Model Name: ExamsResult
Sr. No.	Property Name	Data Type	Remark
1	ExamResult	bigint	pk
2	StudentID	bigint	FK
3	ExamDate	ExamDate
4	CourseExamID	bigint	fk
5	TotalMarks	int
6	NegativeMarks	int
7	ObtainedMarks	int
8	FinalMarks	int