GitHub - GithmiHashara/SQL: The SQL database practices

2 Branches 0 Tags

Name	Name	Last commit message	Last commit date
Latest commit GithmiHashara Create function to insert student marks into Student_Marks table Jan 3, 2025 8018ea6 · Jan 3, 2025 History 30 Commits
Books.sql	Books.sql	Create Books.sql to initialize the database	Dec 29, 2024
Functions_Correct.sql	Functions_Correct.sql	Create function to insert student marks into Student_Marks table	Jan 3, 2025
Journal_Question.sql	Journal_Question.sql	Create Journal_Question.sql to define Journals database and related t…	Dec 29, 2024
SP_CheckEligibility.sql	SP_CheckEligibility.sql	Add stored procedure to check student eligibility based on attendance	Oct 2, 2024
SP_TotalNoOfStudentsBySubject.sql	SP_TotalNoOfStudentsBySubject.sql	Refactor SP_TotalNoOfStudentsBySubject.sql	Oct 2, 2024
Student_DB.sql	Student_DB.sql	Create temporary table for calculating total marks in Science and Eng…	Oct 1, 2024
Student_table_create.sql	Student_table_create.sql	Create Student_Marks table and insert initial data	Oct 1, 2024
Temporary_Table_2.sql	Temporary_Table_2.sql	Create temporary tables for calculating total marks in different subj…	Oct 1, 2024
Trains_Q.sql	Trains_Q.sql	Add views for enhanced train information and pricing in Trains_Q.sql	Dec 30, 2024
Views_1.sql	Views_1.sql	Create views for publication details, author journal, and research pa…	Oct 2, 2024
add-Value-function.sql	add-Value-function.sql	Refactor InsertStudentMarks function to use 'ma' instead of 'm' for M…	Oct 2, 2024
call_SP.sql	call_SP.sql	Fix missing semicolon in call to TotalNoOfStudentsBySubject stored pr…	Oct 2, 2024
call_stored procedure.sql	call_stored procedure.sql	Add call to stored procedure to retrieve the first student's marks	Oct 1, 2024
function_AVGMarks.sql	function_AVGMarks.sql	Add GetAverageMark function to calculate the average mark for a student	Oct 1, 2024
stored_procedure.sql	stored_procedure.sql	Refactor stored procedure to return only the first student record and…	Jan 3, 2025
stored_procedure_2.sql	stored_procedure_2.sql	Add stored procedure to retrieve the number of students for a given s…	Oct 1, 2024
stored_procedure_getFirstRecord.sql	stored_procedure_getFirstRecord.sql	Add stored procedure to retrieve the first student's record	Oct 2, 2024
view_2.sql	view_2.sql	Create views	Oct 2, 2024
view_3.sql	view_3.sql	Create view for Author_Journal	Oct 2, 2024
view_4_ainfo.sql	view_4_ainfo.sql	Create view for ainfo table	Oct 2, 2024
view_5_Fees.sql	view_5_Fees.sql	Create view for NewFee table	Oct 2, 2024
view_6.sql	view_6.sql	Create view for NewFee_2 table	Oct 5, 2024
view_7.sql	view_7.sql	changed the file	Dec 29, 2024