{"id":4522,"date":"2025-06-09T14:13:25","date_gmt":"2025-06-09T14:13:25","guid":{"rendered":"https:\/\/thecompanyboy.com\/?p=4522"},"modified":"2025-06-09T14:13:25","modified_gmt":"2025-06-09T14:13:25","slug":"college-and-home-automation-system-project-iot-using","status":"publish","type":"post","link":"https:\/\/www.reilsolar.com\/drive\/college-and-home-automation-system-project-iot-using\/","title":{"rendered":"College And Home Automation System Project Using IOT (Python & Machine Learning)"},"content":{"rendered":"

PROJECT \u2013 REPORT<\/span><\/h1>\n

\nCollege and Home Automation System Project Using IOT (Python & Machine Learning)<\/span><\/p>\n

\nCOLLEGE AUTOMATION SYSTEM<\/h2>\n

This report introduces the management system which is designed to automate the entire operations of a college and in reducing time in activities using centralized data handling and paperless work with reduced manpower. This Desktop Application has functionality that is basic requirement for college staff. It will help the college staff to access the application and keep record of college data like Student, their marks details and attendance etc. This general application is planned for aiding the students about details on the Courses, Subjects, Marks, Attendance.<\/p>\n

INTRODUCTION<\/h2>\n

1.1 INTRODUCTION TO PROJECT<\/h3>\n

\nPresently, each and every day, a novel application or software is being introduced in the economy that serves to enhance and uplift the lifestyle of the people in innumerable ways. College Automation System (CAS) is an application which aims to make the work load of college staff less.
\nCAS is a Desktop Application. Users have better experience with desktop application as compared to Web applications. CAS provides basic functionality to the users (in this case teachers) to maintain the records of the students. After login the user is redirected to the home page.
\nThe homepage or gateway displays a tree-view of the students according to their session, course. The gateway also consist of a menubar which can be used to navigate to different pages in the application like New Registration, View Students, Add marks, update marks, view marks, Mark attendance etc.
\nNew registrations can be made through the New Registration Form, user have to enter all the required details of the student and the student\u2019s details will be added to the database. The students can be enrolled to different semesters by using the Semester Registration Page. All the details of already saved students can be accessed by the View Students Page.
\nTeachers can add or update or view the marks of the students using the Add\/Update\/View Page. The teacher has to enter the session, course and semester and the students who fall into these conditions will be displayed in a tree-view. Teacher can select any student and click on the add marks button to add the marks of the student. If the marks of that particular student has been already added, the teacher will be redirected to the update marks page where they can update the marks of the student. There also a view button which displays the entered marks of the students, total marks obtained and percentage of the student.
\nCAS also provides the functionality of marking attendance of the students and maintain the record of the same. The teachers can marks the attendance from the mark attendance page which can be accessed through the submenu of the Attendance. Students present in selected session, course and semester will be displayed. If the student is present checkbox will be checked else it will be left unchecked. The record of the attendance can also be viewed through the view attendance page.
\nCAS also provide a master records which can be used to add a new session or new course or a new subject to the database. Already present sessions, courses and subjects can also be viewed and deleted. Masters records also provides Semester Subject Page which can be used to add different subjects to different semesters.
\nThe project is easy to use and has a friendly user interface so anyone with basic knowledge of computers can use the website and get benefited. Hence, the motto \u201cEducation must be accessible to anyone anytime and everywhere\u201d is fulfilled.<\/p>\n

\n1.2 PROJECT CATEGORY<\/h3>\n

\nThe project presented in this paper belongs to the \u201cDesktop Applications\u201d. The simplest for a desktop application can be:
\nit runs on a PC operating system (Windows, Mac, Linux, etc.)
\nit has a graphical user interface
\nit does not run inside a web browser.
\nAn Internet connection is not required to run to this application.
\nThe application is developed in Python using Tkinter framework. This kind of application contains different forms and widgets. A python desktop application can be deployed as exe file. An EXE file contains an executable program for Windows. EXE is short for “executable,” and it is the standard file extension used by Windows programs.<\/p>\n

\n1.3 PROBLEM FORMULATION<\/h3>\n

\nTeachers have to maintain records of every student on paper which leads to huge paper work. Sometimes, it is hard to find record of some student through huge pile of papers. The idea mainly focuses on making the reducing the workload of teachers by using centralized database from where every teacher has access to the records and they can add, update or remove information.<\/p>\n

1.4 EXISTING SYSTEMS<\/h3>\n

\nCurrently, teachers maintain records on papers. Different information is stored in different registers etc. For marks, there is different register or papers, for attendance there is different. This makes the job more time consuming to maintain records at different places. Further, it is difficult to find records of students. Sometimes, if some information of student say contact number is changed, is has to be updated everywhere where contact number of the student is written. Again, this is very tedious task, finding where contact number is stored and updating it.<\/p>\n

\n1.5 PROPOSED SYSTEM<\/h3>\n

\nThe current scenario presented a few major issues which are resolved in the proposed system. These include:
\n\u2981 This system reduces the paperwork. Records can be maintained in different pages of the application. It is less time consuming. It reduces the after work of maintaining record liking compiling marks of students. In this system, with a click of button it is possible.
\n\u2981 Besides, reducing paperwork it also reduces the efforts to find the records of students. Records of present students or existing student can be found by entering their registration id.
\n\u2981 If some detail of student is to be updated, it can be easily done and we done have to update it manually everywhere, the system will do it itself.
\n\u2981 The proposed system works on centralised database which means every teacher can access the data of students.
\n\u2981 The system interface is very user friendly, anyone can use this who has basic knowledge of English and computer and take the maximum benefit.<\/p>\n

\n

SYSTEM DESIGN<\/h2>\n

DESIGN APPROACH<\/h3>\n

\nObject Oriented Approach has been followed throughout the development of the project. Object oriented design works around the entities and their characteristics instead of functions involved in the software system. This design strategies focuses on entities and its characteristics. The whole concept of software solution revolves around the engaged entities.<\/p>\n

\nThe important concepts of Object Oriented Design:<\/h3>\n

\n\uf0b7 Objects – All entities involved in the solution design are known as objects. For example, person, banks, company and customers are treated as objects. Every entity has some attributes associated to it and has some methods to perform on the attributes.
\n\uf0b7 Classes – A class is a generalized description of an object. An object is an instance of a class. Class defines all the attributes, which an object can have and methods, which defines the functionality of the object.
\nIn the solution design, attributes are stored as variables and functionalities are defined by means of methods or procedures.
\n\uf0b7 Encapsulation – In OOD, the attributes (data variables) and methods (operation on the data) are bundled together is called encapsulation. Encapsulation not only bundles important information of an object together, but also restricts access of the data and methods from the outside world. This is called information hiding.
\n\uf0b7 Inheritance – OOD allows similar classes to stack up in hierarchical manner where the lower or sub-classes can import, implement and re-use allowed variables and methods from their immediate super classes. This property of OOD is known as inheritance. This makes it easier to define specific class and to create generalized classes from specific ones.
\n\uf0b7 Polymorphism – OOD languages provide a mechanism where methods performing similar tasks but vary in arguments, can be assigned same name. This is called polymorphism, which allows a single interface performing tasks for different types. Depending upon how the function is invoked, respective portion of the code gets executed.<\/p>\n

\nDATABASE DESIGN<\/h2>\n

\nStudent Table<\/p>\n

Course Table<\/p>\n

\nSession Table<\/p>\n

\nSubject Table<\/p>\n

\nSemester Subject Table<\/p>\n

\nEnrollments Table<\/p>\n

\nMarks Table<\/p>\n

\nAttendance Table<\/p>\n

\n<\/p>\n

Software Requirements:<\/h2>\n

\u2981 Python : Python is an in high-level, interpreted, interactive and object-oriented programming language programming language. Python is designed to be highly readable. Python offers much more structure and support for large programs. Created by Guido van Rossum and first released in 1991. Board standard library .Python has a huge library that contains reusable code. The huge library helps the developer to develop application in less time. Python\u2019s bulk of the library is portable and cross-platform. It is compatible on UNIX, Windows, and Macintosh.
\nPython language can be used to create different types of applications: Console, Web, Desktop, Enterprise etc.<\/p>\n

\u2981 Tkinter: Tkinter is Python\u2019s de-facto standard GUI(Graphical User Interface) package. It is a thin object-oriented layer on top of Tcl\/Tk. Tkinter is not the only Gui Programming toolkit for Python. It is however the most commonly used one.
\n\u2981 Pyodbc: pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the \u2981 DB API 2.0 specification but is packed with even more Pythonic convenience.<\/p>\n

\n\u2981 IDE
\nSpyder is a powerful scientific environment written in Python, for Python. It offers a unique combination of the advanced editing, analysis, debugging, and profiling functionality of a comprehensive development tool with the data exploration, interactive execution, deep inspection, and beautiful visualization capabilities of a scientific package.
\nBeyond its many built-in features, its abilities can be extended even further via its plugin system and API. Furthermore, Spyder can also be used as a PyQt5 extension library, allowing developers to build upon its functionality and embed its components, such as the interactive console, in their own PyQt software.<\/p>\n

\u2981 Database
\nMicrosoft SQL Server
\nSnapshots<\/p>\n

Login Page<\/p>\n

Homepage<\/p>\n

\nNew Registration<\/p>\n

Semester Registration or Enrollment<\/p>\n

\nView Students<\/p>\n

Mark Attendance<\/p>\n

\nMasters \u2013 Add Course<\/p>\n

\nMasters \u2013 Add Subject<\/p>\n

\nConclusion<\/h2>\n

We have proposed a application which can help the teachers to reduce their work load. If teachers are busy in dealing with records, they might not able to give time to the students. This application will automate the things which teachers had to do manually. They do not have to sit all day and deal with lot of papers, there work will be done in just few clicks.
\nOur long term goal is to add more functionality to the current application and automate more functions, so paper work will be reduced to zero and will help the teachers.<\/p>\n

College Automation System Python Code<\/h1>\n

1.gateway.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Treeview
\nfrom datalayer import DBSessions
\n#from RegistrationForm import RegistrationForm
\n#from ViewStudents import ViewStudents
\n#from Enrollments import Enrollments
\n#from DisplayStudentsForm import DisplayStudentForm
\n#from Attendance import Attendance
\nfrom AddSession import AddSession
\nfrom ViewSessions import ViewSessions
\nfrom AddSubject import AddSubject
\nfrom ViewSubjects import ViewSubjects
\nfrom AddCourse import AddCourse
\nfrom ViewCourses import ViewCourses
\n#from SemesterSubjects import SemesterSubjectsForm
\nfrom datalayer import DBCourse, DBStudents
\n#from ViewAttendance import ViewAttendance
\nfrom datetime import date<\/p>\n

class Gateway:
\ndef __init__(self,username):
\nself.root = tk.Toplevel()<\/p>\n

self.root.geometry(“625×450”)
\nself.root.title(“CAS”)
\nself.root.resizable(‘false’,’false’)<\/p>\n

self.Menu = tk.Menu(self.root)<\/p>\n

dt = date.today()
\nself.welcomeuser = tk.Label(self.root, text = “Welcome, ” + username)
\nself.welcomeuser.place(x = 10 , y = 425)
\nself.datetimelabel = tk.Label(self.root, text = dt)
\nself.datetimelabel.place(x = 550, y = 425)<\/p>\n

studentmenu = tk.Menu(self.Menu, tearoff = 0)
\nstudentmenu.add_command(label = “New Registration”, command = self.NewRegistrationClick)
\nstudentmenu.add_command(label = “View Students”, command = self.ViewStudentsClick)
\nstudentmenu.add_separator()
\nstudentmenu.add_command(label= “Semester Registration”, command = self.SemesterRegistrationClick)<\/p>\n

self.Menu.add_cascade(label = “Students”, menu = studentmenu)<\/p>\n

marksmenu = tk.Menu(self.Menu, tearoff = 0)
\nmarksmenu.add_command(label= “Add\/View\/Update”, command = self.MarksClick)
\nself.Menu.add_cascade(label = “Marks”, menu = marksmenu)<\/p>\n

attendancemenu = tk.Menu(self.Menu, tearoff = 0)
\nattendancemenu.add_command(label = “Mark Attendance”, command = self.AttendanceClick)
\nattendancemenu.add_command(label = “View Attendance”, command = self.ViewAttendanceClick)
\nself.Menu.add_cascade(label = “Attendance”, menu = attendancemenu)<\/p>\n

master = tk.Menu(self.Menu, tearoff = 0)<\/p>\n

session = tk.Menu(master, tearoff = 0)
\nsession.add_command(label = “Add Session”, command = self.AddSessionClick)
\nsession.add_command(label = “View Session”, command = self.ViewSessionClick)
\nmaster.add_cascade(label = “Session”, menu = session)<\/p>\n

course = tk.Menu(master, tearoff = 0)
\ncourse.add_command(label = “Add Course”, command = self.AddCourseClick)
\ncourse.add_command(label = “View Course”, command = self.ViewCourseClick)
\nmaster.add_cascade(label = “Course”, menu = course)<\/p>\n

subject = tk.Menu(master, tearoff = 0)
\nsubject.add_command(label = “Add Subject”, command = self.AddSubjectClick)
\nsubject.add_command(label = “View Subject”, command = self.ViewSubjectClick)
\nmaster.add_cascade(label = “Subject”, menu = subject)
\nmaster.add_separator()
\nmaster.add_command(label = “Semester Subject”, command = self.SemesterSubjectClick)
\nself.Menu.add_cascade(label = “Masters Record”, menu = master)<\/p>\n

self.root.config(menu = self.Menu)<\/p>\n

\nself.Tree = Treeview(self.root)
\nself.Tree[‘columns’] = [‘col1’, ‘col2’]
\nself.Tree.place(x = 10, y = 20, height=400)<\/p>\n

dbsession = DBSessions()
\nallcourses = DBCourse().GetCourse()
\nobjDALStudent = DBStudents()<\/p>\n

sessioncounter = 1
\ncoursecounter=1
\nstudentcounter = 1<\/p>\n

for session in dbsession.GetSession():
\nsessionnode = self.Tree.insert(“”, sessioncounter, text=session.Session, values=(“”,””))<\/p>\n

coursecounter=1
\nfor course in allcourses:
\ncoursenode = self.Tree.insert(sessionnode, coursecounter, text=course.CourseName, values=(“”,””))
\ncoursecounter+=1<\/p>\n

studentcounter = 1
\nfor student in objDALStudent.ViewStudents(course.CourseId, session.SessionId):
\nself.Tree.insert(coursenode, studentcounter, text=str(studentcounter), values=(student.RollNo, student.Name))
\nstudentcounter+=1<\/p>\n

\nsessioncounter+=1<\/p>\n

def NewRegistrationClick(self):
\nobj = RegistrationForm()
\nobj.showDialog()<\/p>\n

def ViewStudentsClick(self):
\nobj = ViewStudents()
\nobj.showDialog()<\/p>\n

def SemesterRegistrationClick(self):
\nobj = Enrollments()
\nobj.showDialog()<\/p>\n

def MarksClick(self):
\nobj = DisplayStudentForm()
\nobj.showDialog()<\/p>\n

def AttendanceClick(self):
\nobj = Attendance()
\nobj.showDiaog()<\/p>\n

def ViewAttendanceClick(self):
\nobj = ViewAttendance()
\nobj.showDialog()<\/p>\n

def AddSessionClick(self):
\nobj = AddSession()
\nobj.showDialog()<\/p>\n

def ViewSessionClick(self):
\nobj = ViewSessions()
\nobj.showDialog()<\/p>\n

def AddSubjectClick(self):
\nobj = AddSubject()
\nobj.showDialog()<\/p>\n

def ViewSubjectClick(self):
\nobj = ViewSubjects()
\nobj.showDialog()<\/p>\n

def AddCourseClick(self):
\nobj = AddCourse()
\nobj.showDialog()<\/p>\n

def ViewCourseClick(self):
\nobj = ViewCourses()
\nobj.showDialog()<\/p>\n

def SemesterSubjectClick(self):
\nobj = SemesterSubjectsForm()
\nobj.showDialog()<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

2.login.py<\/h2>\n

import tkinter as tk
\nfrom tkinter import messagebox
\nfrom gateway import Gateway<\/p>\n

class Login():
\ndef __init__(self):
\nself.root = tk.Tk()
\nself.user = tk.StringVar()
\nself.password = tk.StringVar()
\nself.count = 0<\/p>\n

self.show = tk.PhotoImage(file = r”C:\\Users\\daljeet\\Desktop\\Project – CAS\\TrainingProject – CAS\\Images\\show2.png”)
\nself.hide = tk.PhotoImage(file = r”C:\\Users\\daljeet\\Desktop\\Project – CAS\\TrainingProject – CAS\\Images\\hide1.png”)<\/p>\n

\nself.welcome = tk.Label(self.root, text = “CAS”, font=(28))
\nself.welcome.place(x = 120, y = 10)<\/p>\n

self.accLabel = tk.Label(self.root, text = “Enter Usename”)
\nself.accLabel.place(x = 10, y = 50)
\nself.accEntry = tk.Entry(self.root, textvariable = self.user)
\nself.accEntry.place(x = 110 , y = 50)
\nself.errorLabel1 = tk.Label(self.root, text = “” ,fg = ‘red’)
\nself.errorLabel1.place(x = 110, y =70)<\/p>\n

self.passLabel = tk.Label(self.root, text = “Enter password”)
\nself.passLabel.place(x = 10, y = 90)
\nself.passEntry = tk.Entry(self.root, textvariable = self.password , show = “*”)
\nself.passEntry.place(x = 110 , y = 90)
\nself.errorLabel2 = tk.Label(self.root, text = “” ,fg = ‘red’)
\nself.errorLabel2.place(x = 110, y =110)
\nself.shButton = tk.Button(self.root, image = self.show , command =self.showhidePassword)
\nself.shButton.place(x = 250 , y = 85)<\/p>\n

self.logButton = tk.Button(self.root, text = “LogIn” , command = self.loginClicked, width = 10)
\nself.logButton.place(x = 40, y = 140)
\nself.eButton = tk.Button(self.root, text = “Exit” , command = self.exitClicked, width = 10)
\nself.eButton.place(x = 180, y = 140)<\/p>\n

self.root.geometry(“295×180”)
\nself.root.title(“LogIn”)
\nself.root.resizable(‘false’,’false’)<\/p>\n

def loginClicked(self):
\ncheck = self.validate()
\nif check == True:
\nif self.user.get() == ‘cas’ and int(self.password.get()) == 1234 :
\nobj = Gateway(self.user.get())
\nobj.showDialog()<\/p>\n

else:
\nmessagebox.showerror(“LogIn”, “Wrong username or password.Please Try Again”)<\/p>\n

def exitClicked(self):
\na = messagebox.askyesno(“LogIn”, “Do you want to exit?”)
\nif a == True:
\nself.root.destroy()<\/p>\n

def validate(self):
\nval = True<\/p>\n

self.errorLabel1.config(text = “”)
\nself.errorLabel2.config(text = “”)<\/p>\n

if self.password.get().isdigit() == False:
\nval = False
\nself.errorLabel2.config(text = “*Alphabets not allowed”)<\/p>\n

if len(self.user.get()) == 0:
\nval = False
\nself.errorLabel1.config(text = “*Field Required”)<\/p>\n

if len(self.password.get()) == 0:
\nval = False
\nself.errorLabel2.config(text = “*Field Required”)<\/p>\n

return val<\/p>\n

def showhidePassword(self):
\nif self.count % 2 ==0:
\nself.passEntry.config(show = “”)
\nself.shButton.config(image = self.hide)<\/p>\n

else:
\nself.passEntry.config(show = “*”)
\nself.shButton.config(image = self.show)
\nself.count += 1<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

obj = Login()
\nobj.showDialog()<\/p>\n

3.login.spec<\/h2>\n

# -*- mode: python ; coding: utf-8 -*-<\/p>\n

block_cipher = None<\/p>\n

\na = Analysis([‘login.py’],
\npathex=[‘D:\\\\Python\\\\TrainingProject’],
\nbinaries=[],
\ndatas=[],
\nhiddenimports=[],
\nhookspath=[],
\nruntime_hooks=[],
\nexcludes=[],
\nwin_no_prefer_redirects=False,
\nwin_private_assemblies=False,
\ncipher=block_cipher,
\nnoarchive=False)
\npyz = PYZ(a.pure, a.zipped_data,
\ncipher=block_cipher)
\nexe = EXE(pyz,
\na.scripts,
\na.binaries,
\na.zipfiles,
\na.datas,
\n[],
\nname=’login’,
\ndebug=False,
\nbootloader_ignore_signals=False,
\nstrip=False,
\nupx=True,
\nupx_exclude=[],
\nruntime_tmpdir=None,
\nconsole=True )<\/p>\n

4.Enrollments.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Combobox
\nfrom tkinter import messagebox
\nfrom datalayer import DBEnrollment
\nfrom datetime import date<\/p>\n

class Enrollments:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.geometry(“590×340”)
\nself.root.title(“Enrollment”)<\/p>\n

self.rollno = tk.StringVar()
\nself.registrationid = tk.StringVar()
\nself.redistrationdate = tk.StringVar()
\nself.name = tk.StringVar()
\nself.dob = tk.StringVar()
\nself.gender = tk.StringVar()
\nself.contact = tk.StringVar()
\nself.father = tk.StringVar()
\nself.mother = tk.StringVar()
\nself.city = tk.StringVar()
\nself.email = tk.StringVar()
\nself.course = tk.StringVar()
\nself.session = tk.StringVar()<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Roll No.”)
\nself.lbl1.place(x = 140, y =10)
\nself.ent1 = tk.Entry(self.root, textvariable = self.rollno)
\nself.ent1.place(x = 200, y = 10)<\/p>\n

self.FindButton = tk.Button(self.root, text = “Find”, width = 12, command = self.FindClicked)
\nself.FindButton.place(x = 360, y = 10)<\/p>\n

self.MiddleFrame = tk.Frame(self.root, width = 570, height = 210)
\nself.MiddleFrame.place(x = 10, y = 60)
\nself.MiddleFrame.config(highlightbackground = “Black”, highlightcolor = “Black”, highlightthickness = 1, bd= 0)<\/p>\n

self.lbl2 = tk.Label(self.root, text = “RegistrationId”)
\nself.lbl2.place(x = 30 , y = 80)
\nself.ent2 = tk.Entry(self.root, state = “readonly”, textvariable = self.registrationid)
\nself.ent2.place(x = 130, y = 80)<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Registration Date”)
\nself.lbl3.place(x = 330, y = 80)
\nself.ent3 = tk.Entry(self.root, state = “readonly”, textvariable = self.redistrationdate)
\nself.ent3.place(x = 430, y = 80)<\/p>\n

self.lbl4 = tk.Label(self.root, text = “Name”)
\nself.lbl4.place(x = 30, y = 110)
\nself.ent4 = tk.Entry(self.root, state = “readonly”, textvariable = self.name)
\nself.ent4.place(x = 130, y = 110)<\/p>\n

self.lbl5 = tk.Label(self.root, text = “D.O.B”)
\nself.lbl5.place(x = 330, y = 110)
\nself.ent5 = tk.Entry(self.root, state = “readonly”, textvariable = self.dob)
\nself.ent5.place(x = 430, y = 110)<\/p>\n

self.lbl6 = tk.Label(self.root, text = “Gender”)
\nself.lbl6.place(x = 30, y = 140)
\nself.ent6 = tk.Entry(self.root, state = “readonly”, textvariable = self.gender)
\nself.ent6.place(x = 130, y = 140)<\/p>\n

self.lbl7 = tk.Label(self.root, text = “Contact Number”)
\nself.lbl7.place(x = 330, y = 140)
\nself.ent7 = tk.Entry(self.root, state = “readonly”, textvariable = self.contact)
\nself.ent7.place(x = 430, y = 140)<\/p>\n

self.lbl8 = tk.Label(self.root, text = “Father Name”)
\nself.lbl8.place(x = 30, y = 170)
\nself.ent8 = tk.Entry(self.root, state = “readonly”, textvariable = self.father)
\nself.ent8.place(x = 130, y = 170)<\/p>\n

self.lbl9 = tk.Label(self.root, text = “Mother Name”)
\nself.lbl9.place(x = 330, y = 170)
\nself.ent9 = tk.Entry(self.root, state = “readonly”, textvariable = self.mother)
\nself.ent9.place(x = 430, y = 170)<\/p>\n

self.lbl10 = tk.Label(self.root, text = “City”)
\nself.lbl10.place(x = 30, y = 200)
\nself.ent10 = tk.Entry(self.root, state = “readonly”, textvariable = self.city)
\nself.ent10.place(x = 130, y = 200)<\/p>\n

self.lbl11 = tk.Label(self.root, text = “E-mail”)
\nself.lbl11.place(x = 330, y = 200)
\nself.ent11 = tk.Entry(self.root, state = “readonly”, textvariable = self.email)
\nself.ent11.place(x = 430, y = 200)<\/p>\n

self.lbl12 = tk.Label(self.root, text = “Course”)
\nself.lbl12.place(x = 30, y = 230)
\nself.ent12 = tk.Entry(self.root, state = “readonly”, textvariable = self.course)
\nself.ent12.place(x = 130, y = 230)<\/p>\n

self.lbl13 = tk.Label(self.root, text = “Session”)
\nself.lbl13.place(x = 330, y = 230)
\nself.ent13 = tk.Entry(self.root, state = “readonly”, textvariable = self.session)
\nself.ent13.place(x = 430, y = 230)<\/p>\n

self.lbl14 = tk.Label(self.root, text = “Semester”)
\nself.lbl14.place(x = 140, y = 300)
\nself.cmb1 = Combobox(self.root)
\nself.cmb1.place(x = 200, y = 300)
\nself.cmb1[‘values’] = [‘1’, ‘2’, ‘3’,’4′,’5′,’6′,’7′,’8′]<\/p>\n

self.RegisterButton = tk.Button(self.root, text = “Register”, width = 12, command = self.RegisterClicked)
\nself.RegisterButton.place(x = 360, y = 300)<\/p>\n

def FindClicked(self):
\nroll = int(self.rollno.get())
\ndb = DBEnrollment()
\nAllData = db.FindRoll(roll)<\/p>\n

for data in AllData:
\nself.registrationid.set(data.RegistrationId)
\nself.redistrationdate.set(data.RegistrationDate)
\nself.name.set(data.Name)
\nself.dob.set(data.Dob)
\nself.gender.set(data.Gender)
\nself.contact.set(data.ContactNo)
\nself.father.set(data.FatherName)
\nself.mother.set(data.MotherName)
\nself.city.set(data.City)
\nself.email.set(data.EmailId)
\nself.course.set(data.CourseId)
\nself.session.set(data.SessionID)<\/p>\n

def RegisterClicked(self):
\nsem = self.cmb1.get()
\nrid = int(self.registrationid.get())
\ntoday = str(date.today())
\ndb = DBEnrollment()
\ndb.Register(today,sem,rid)<\/p>\n

messagebox.showinfo(“Enrollment”, “Student was enrolled successfully.”)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

5.MarksForm.py<\/h2>\n

import tkinter as tk
\nfrom datalayer import DBMarks
\nfrom tkinter import messagebox<\/p>\n

\nclass MarksForm:
\ndef __init__(self,regid,sessid,cid,sem,name):
\nself.root = tk.Toplevel()
\nself.root.geometry(“475×400”)
\nself.root.title(“Add Marks”)
\nself.Date = tk.StringVar()<\/p>\n

self.regID = regid
\nself.y = 130
\nself.reg = tk.StringVar()
\nself.nam = tk.StringVar()<\/p>\n

self.lbl1 = tk.Label(self.root, text = “RegistrationId”)
\nself.lbl1.place(x = 10 , y = 40)
\nself.ent1 = tk.Entry(self.root, textvariable = self.reg, state = “readonly”, width = 10)
\nself.ent1.place(x = 110, y = 40)
\nself.reg.set(self.regID)<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Name”)
\nself.lbl3.place(x = 240 , y = 40)
\nself.ent2 = tk.Entry(self.root, textvariable = self.nam, state = “readonly”, width = 20)
\nself.ent2.place(x = 370, y = 40)
\nself.nam.set(name)<\/p>\n

self.lbl5 = tk.Label(self.root, text = “Subject”)
\nself.lbl5.place(x = 110 , y =100)
\nself.lbl6 = tk.Label(self.root, text = “Marks”)
\nself.lbl6.place(x = 200 , y = 100)<\/p>\n

db = DBMarks()
\nself.AllSubjects = db.GetSubjects(sessid,cid,sem)
\nself.MarksList = []<\/p>\n

for a in self.AllSubjects:
\nlistvar = tk.StringVar()
\nself.MarksList.append((listvar,a.SemesterSubjectId))
\nlbl = tk.Label(self.root, text = a.Subject)
\nlbl.place(x = 110, y = self.y)
\nent = tk.Entry(self.root, textvariable = listvar)
\nent.place(x = 200, y = self.y)
\nself.y += 40<\/p>\n

self.AddButton = tk.Button(self.root, text = “Add”, command = self.AddMarks, width = 12)
\nself.AddButton.place(x = 150, y = self.y + 20)<\/p>\n

def AddMarks(self):
\ndb = DBMarks()
\nfor marks in self.MarksList:
\nssid = marks[1]
\nrid = self.regID
\nmarks = marks[0].get()
\ndate = self.Date.get()
\nmessagebox.showinfo(“Add Marks”, “Marks was added successfully.”)<\/p>\n

\ndb.AddMarks(ssid,rid,marks,date)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

6.RegistrationForm.py<\/h2>\n

import tkinter as tk
\nfrom tkinter import messagebox
\nfrom tkinter.ttk import Combobox
\nfrom components import Student,Course, Session
\nfrom datalayer import DBStudents, DBCourse, DBSessions<\/p>\n

class RegistrationForm:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.geometry(“650×390”)
\nself.root.title(“Registration”)<\/p>\n

self.CourseId = 0
\nself.SessionID = 0
\nself.RegistrationDate = tk.StringVar()
\nself.RollNo = tk.StringVar()
\nself.Name = tk.StringVar()
\nself.Dob = tk.StringVar()
\nself.Gender = tk.StringVar()
\nself.FatherName = tk.StringVar()
\nself.MotherName = tk.StringVar()
\nself.Address = tk.StringVar()
\nself.City = tk.StringVar()
\nself.Nationality = tk.StringVar()
\nself.ContactNo = tk.StringVar()
\nself.EmailId = tk.StringVar()<\/p>\n

\nself.lbl1 = tk.Label(self.root, text = “Course”)
\nself.lbl1.place(x = 10 , y = 10)<\/p>\n

self.cmb1 = Combobox(self.root, state = “readonly”, width = 20)
\nself.cmb1.place(x = 110, y = 10)<\/p>\n

\ndbcourse = DBCourse()
\nself.AllCourses = dbcourse.GetCourse()<\/p>\n

courseslist = []
\nfor c in self.AllCourses:
\ncourseslist.append(c.CourseName)<\/p>\n

self.cmb1[‘values’] = courseslist<\/p>\n

self.lbl2 = tk.Label(self.root, text = “Session”)
\nself.lbl2.place(x = 350 , y = 10)<\/p>\n

self.cmb2 = Combobox(self.root, state = “readonly”, width = 20)
\nself.cmb2.place(x = 460, y = 10)<\/p>\n

\ndbsession = DBSessions()
\nself.AllSessions = dbsession.GetSession()<\/p>\n

sessionlist = []<\/p>\n

for s in self.AllSessions:
\nsessionlist.append(s.Session)<\/p>\n

self.cmb2[‘values’] = sessionlist<\/p>\n

\nself.lbl13 = tk.Label(self.root, text = “Registration Date”)
\nself.lbl13.place(x = 10 , y = 70)
\nself.ent13 = tk.Entry(self.root , textvariable = self.RegistrationDate, width = 25)
\nself.ent13.place(x = 110, y = 70)<\/p>\n

self.lbl14 = tk.Label(self.root, text = “Name”)
\nself.lbl14.place(x = 350 , y = 70)
\nself.ent14 = tk.Entry(self.root, textvariable = self.Name, width = 25)
\nself.ent14.place(x = 460, y = 70)<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Roll Number”)
\nself.lbl3.place(x = 10 , y = 110)
\nself.ent3 = tk.Entry(self.root, textvariable = self.RollNo, width = 25)
\nself.ent3.place(x = 110, y = 110)<\/p>\n

self.lbl4 = tk.Label(self.root, text = “D.O.B”)
\nself.lbl4.place(x = 350 , y = 110)
\nself.ent4 = tk.Entry(self.root, textvariable = self.Dob, width = 25)
\nself.ent4.place(x = 460, y = 110)<\/p>\n

self.lbl5 = tk.Label(self.root, text = “Gender”)
\nself.lbl5.place(x = 10, y = 150)
\nself.rbn1 = tk.Radiobutton(self.root, text = “Male”, variable = self.Gender, value = “Male”)
\nself.rbn1.place(x = 110, y = 150)
\nself.rbn2 = tk.Radiobutton(self.root, text = “Female”, variable = self.Gender, value = “Female”)
\nself.rbn2.place(x = 210, y = 150)
\nself.rbn3 = tk.Radiobutton(self.root, text = “Others”, variable = self.Gender, value = “Others”)
\nself.rbn3.place(x = 310, y = 150)<\/p>\n

self.lbl6 = tk.Label(self.root, text = “Father Name”)
\nself.lbl6.place(x = 10 , y = 190)
\nself.ent6 = tk.Entry(self.root, textvariable = self.FatherName, width = 25)
\nself.ent6.place(x = 110, y = 190)<\/p>\n

self.lbl7 = tk.Label(self.root, text = “Mother Name”)
\nself.lbl7.place(x = 350 , y = 190)
\nself.ent7 = tk.Entry(self.root, textvariable = self.MotherName, width = 25)
\nself.ent7.place(x = 460, y = 190)<\/p>\n

self.lbl8 = tk.Label(self.root, text = “Address”)
\nself.lbl8.place(x = 10 , y = 230)
\nself.ent8 = tk.Entry(self.root, textvariable = self.Address, width = 25)
\nself.ent8.place(x = 110, y = 230)<\/p>\n

self.lbl9 = tk.Label(self.root, text = “City”)
\nself.lbl9.place(x = 350 , y = 230)
\nself.ent9 = tk.Entry(self.root, textvariable = self.City, width = 25)
\nself.ent9.place(x = 460, y = 230)<\/p>\n

self.lbl10 = tk.Label(self.root, text = “Nationality”)
\nself.lbl10.place(x = 10 , y = 270)
\nself.ent10 = tk.Entry(self.root, textvariable = self.Nationality, width = 25)
\nself.ent10.place(x = 110, y = 270)<\/p>\n

self.lbl11 = tk.Label(self.root, text = “Contact Number”)
\nself.lbl11.place(x = 350 , y = 270)
\nself.ent11 = tk.Entry(self.root, textvariable = self.ContactNo, width = 25)
\nself.ent11.place(x = 460, y = 270)<\/p>\n

self.lbl12 = tk.Label(self.root, text = “Email Id”)
\nself.lbl12.place(x = 10 , y = 310)
\nself.ent12 = tk.Entry(self.root, textvariable = self.EmailId, width = 25)
\nself.ent12.place(x = 110, y = 310)<\/p>\n

self.btn = tk.Button(self.root, text = “Submit”, width = 20, command = self.SubmitClicked)
\nself.btn.place(x = 250 , y = 350)<\/p>\n

\ndef SubmitClicked(self):<\/p>\n

comp = Student()
\ncomp.CourseId = self.AllCourses[self.cmb1.current()].CourseId
\ncomp.SessionID = self.AllSessions[self.cmb2.current()].SessionId
\ncomp.RegistrationDate = self.RegistrationDate.get()
\ncomp.RollNo = self.RollNo.get()
\ncomp.Name = self.Name.get()
\ncomp.Dob = self.Dob.get()
\ncomp.Gender = self.Gender.get()
\ncomp.FatherName = self.FatherName.get()
\ncomp.MotherName = self.MotherName.get()
\ncomp.Address = self.Address.get()
\ncomp.City = self.City.get()
\ncomp.Nationality = self.Nationality.get()
\ncomp.ContactNo = self.ContactNo.get()
\ncomp.EmailId = self.EmailId.get()
\ndb = DBStudents()
\ndb.AddStudent(comp)
\nmessagebox.showinfo(“Registration”, “Registration successful.”)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

7.SemesterSubjects.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Combobox, Treeview
\nfrom datalayer import DBSessions, DBCourse, DBSubjects, DBSemesterSubjects
\nfrom components import SemesterSubjects<\/p>\n

class SemesterSubjectsForm:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.geometry(“625×330”)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Session”)
\nself.lbl1.place(x = 10 , y =10)
\nself.cmb1 = Combobox(self.root, state = “readonly”)
\nself.cmb1.place(x = 70, y = 10)
\ndbsessions = DBSessions()
\nself.AllSessions = dbsessions.GetSession()
\nSessionList = []
\nfor sess in self.AllSessions:
\nSessionList.append(sess.Session)
\nself.cmb1[‘values’] = SessionList<\/p>\n

self.lbl2 = tk.Label(self.root, text = “Semester”)
\nself.lbl2.place(x = 270 , y =10)
\nself.cmb2 = Combobox(self.root, state = “readonly”)
\nself.cmb2.place(x = 330, y = 10)
\nself.cmb2[‘values’] = [‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’]<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Course”)
\nself.lbl3.place(x = 10 , y =40)
\nself.cmb3 = Combobox(self.root, state = “readonly”)
\nself.cmb3.place(x = 70, y = 40)
\ndbcourses = DBCourse()
\nself.AllCourses = dbcourses.GetCourse()
\nCourseList = []
\nfor cour in self.AllCourses:
\nCourseList.append(cour.CourseName)
\nself.cmb3[‘values’] = CourseList<\/p>\n

self.lbl4 = tk.Label(self.root, text = “Subject”)
\nself.lbl4.place(x = 270 , y =40)
\nself.cmb4 = Combobox(self.root, state = “readonly”)
\nself.cmb4.place(x = 330, y = 40)
\ndbsubjects = DBSubjects()
\nself.AllSubjects = dbsubjects.GetSubjects()
\nSubjectList = []
\nfor sub in self.AllSubjects:
\nSubjectList.append(sub.Subject)
\nself.cmb4[‘values’] = SubjectList<\/p>\n

self.AddButton = tk.Button(self.root, text = “Show” , width = 12, command = self.ShowClicked)
\nself.AddButton.place(x = 520, y = 10)<\/p>\n

self.AddButton = tk.Button(self.root, text = “Add” , width = 12, command = self.AddClicked)
\nself.AddButton.place(x = 520, y = 40)<\/p>\n

self.Tree = Treeview(self.root)
\nself.Tree.place(x = 10, y = 90)
\nself.Tree[‘columns’] = [‘c1′,’c2’]
\nself.Tree.heading(“#0”, text = “SemesterSubjectId”)
\nself.Tree.heading(“c1”,text = “Semester”)
\nself.Tree.heading(“c2”,text = “Subject”)<\/p>\n

def ShowClicked(self):
\nself.Tree.delete(*self.Tree.get_children())
\nsessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb3.current()].CourseId
\nsubid = self.AllSubjects[self.cmb4.current()].SubjectId
\nss = SemesterSubjects()
\nss.SessionId = sessid
\nss.CourseId = cid
\nss.SubjectId = subid
\nss.Semester = self.cmb2.get()<\/p>\n

db = DBSemesterSubjects()
\nAllSemesterSubjects = db.Getdata(ss)<\/p>\n

i = 0
\nfor allss in AllSemesterSubjects:
\nself.Tree.insert(“”,i,text = allss.SemesterSubjectId, values = (allss.Semester, allss.SubjectId))
\ni += 1<\/p>\n

def AddClicked(self):
\nsessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb3.current()].CourseId
\nsubid = self.AllSubjects[self.cmb4.current()].SubjectId
\nss = SemesterSubjects()
\nss.SessionId = sessid
\nss.CourseId = cid
\nss.SubjectId = subid
\nss.Semester = self.cmb2.get()<\/p>\n

db = DBSemesterSubjects()
\ndb.StoreValues(ss)<\/p>\n

self.Tree.delete(*self.Tree.get_children())
\nAllSemesterSubjects = db.Getdata(ss)<\/p>\n

i = 0
\nfor allss in AllSemesterSubjects:
\nself.Tree.insert(“”, i, text = allss.SemesterSubjectId, values = (allss.Semester, allss.SubjectId))
\ni += 1<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

8.UpdateMarksForms.py<\/h2>\n

import tkinter as tk
\nfrom datalayer import DBMarks
\nfrom tkinter import messagebox<\/p>\n

class UpdateMarksForm:
\ndef __init__(self,regid,sessid,cid,sem,name, Marks):
\nself.root = tk.Toplevel()
\nself.root.geometry(“455×400”)
\nself.root.title(“Add Marks”)<\/p>\n

self.regID = regid
\nself.y = 130
\nself.reg = tk.StringVar()
\nself.nam = tk.StringVar()<\/p>\n

self.lbl1 = tk.Label(self.root, text = “RegistrationId”)
\nself.lbl1.place(x = 10 , y = 40)
\nself.ent1 = tk.Entry(self.root, textvariable = self.reg, state = “readonly”, width = 10)
\nself.ent1.place(x = 110, y = 40)
\nself.reg.set(self.regID)<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Name”)
\nself.lbl3.place(x = 270 , y = 40)
\nself.ent2 = tk.Entry(self.root, textvariable = self.nam, state = “readonly”, width = 10)
\nself.ent2.place(x = 370, y = 40)
\nself.nam.set(name)<\/p>\n

self.lbl5 = tk.Label(self.root, text = “Subject”)
\nself.lbl5.place(x = 110 , y =100)
\nself.lbl6 = tk.Label(self.root, text = “Marks”)
\nself.lbl6.place(x = 200 , y = 100)<\/p>\n

dbsubjects = DBMarks()
\nself.AllSubjects = dbsubjects.GetSubjects(sessid,cid,sem)
\nself.MarksList = []<\/p>\n

for a,m in zip(self.AllSubjects,Marks):
\nlistvar = tk.StringVar()
\nself.MarksList.append((listvar,a.SemesterSubjectId))
\nlbl = tk.Label(self.root, text = a.Subject)
\nlbl.place(x = 110, y = self.y)
\nent = tk.Entry(self.root, textvariable = listvar)
\nent.place(x = 200, y = self.y)
\nself.y += 40
\nlistvar.set(m)<\/p>\n

self.AddButton = tk.Button(self.root, text = “Update”, command = self.UpdateMarks, width = 12)
\nself.AddButton.place(x = 150, y = self.y + 20)<\/p>\n

def UpdateMarks(self):
\ndb = DBMarks()
\nfor marks in self.MarksList:
\nmarks = marks[0].get()
\nssid = marks[1]
\nregid = self.regID
\nmessagebox.showinfo(” UpdateMarks”, “Marks was Updated successfully.”)<\/p>\n

\ndb.UpdateMarks(marks, regid, ssid)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

9.DisplayStudentsForm.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Combobox, Treeview
\nfrom datalayer import DBSessions, DBCourse, DBStudents, DBMarks
\nfrom MarksForm import MarksForm
\nfrom UpdateMarksForms import UpdateMarksForm
\nfrom ViewMarksForm import ViewMarksForm<\/p>\n

class DisplayStudentForm:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.geometry(“855×350”)
\nself.root.title(“Marks”)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Session”)
\nself.lbl1.place(x = 10 , y = 10)
\nself.cmb1 = Combobox(self.root, state = “readonly”)
\nself.cmb1.place(x = 70, y = 10)
\ndbsessions = DBSessions()
\nself.AllSessions = dbsessions.GetSession()
\nSessionList = []
\nfor sess in self.AllSessions:
\nSessionList.append(sess.Session)
\nself.cmb1[‘values’] = SessionList<\/p>\n

self.lbl2 = tk.Label(self.root, text = “Course”)
\nself.lbl2.place(x = 250 , y =10)
\nself.cmb2 = Combobox(self.root, state = “readonly”)
\nself.cmb2.place(x = 310, y = 10)
\ndbcourses = DBCourse()
\nself.AllCourses = dbcourses.GetCourse()
\nCourseList = []
\nfor cour in self.AllCourses:
\nCourseList.append(cour.CourseName)
\nself.cmb2[‘values’] = CourseList<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Semester”)
\nself.lbl3.place(x = 490 , y =10)
\nself.cmb3 = Combobox(self.root, state = “readonly”)
\nself.cmb3.place(x = 560, y = 10)
\nself.cmb3[‘values’] = [‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’]<\/p>\n

self.ShowButton = tk.Button(self.root, text = “Show”, command = self.ShowClicked, width = 12)
\nself.ShowButton.place(x = 750, y = 10)<\/p>\n

self.Tree = Treeview(self.root)
\nself.Tree.place(x = 10, y = 70)
\nself.Tree[‘columns’] = [‘c1′,’c2′,’c3′,’c4′,’c5’]
\nself.Tree.heading(“#0”, text = “RegId”)
\nself.Tree.heading(“c1”,text = “Name”)
\nself.Tree.heading(“c2”,text = “Roll No.”)
\nself.Tree.heading(“c3”,text = “DOB”)
\nself.Tree.heading(“c4”,text = “Gender”)
\nself.Tree.heading(“c5”,text = “Contact No.”)<\/p>\n

self.Tree.column(“#0”, width = 50)
\nself.Tree.column(“c2”, width = 130)
\nself.Tree.column(“c3”, width = 130)
\nself.Tree.column(“c4”, width = 120)<\/p>\n

self.MarksButton = tk.Button(self.root, text = “Marks”, command = self.MarksClicked, width = 12)
\nself.MarksButton.place(x = 300, y = 310)<\/p>\n

self.ViewMarksButton = tk.Button(self.root, text = “View Marks”, command = self.ViewMarksClicked, width = 12)
\nself.ViewMarksButton.place(x = 460, y = 310)<\/p>\n

def ShowClicked(self):
\nsessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb2.current()].CourseId
\nsem = self.cmb3.get()<\/p>\n

db = DBStudents()
\nAllDetails = db.FindStudent(sessid,cid,sem)<\/p>\n

i = 0
\nfor ad in AllDetails:
\nself.Tree.insert(“”,i,text = ad.RegistrationId, values = (ad.Name, ad.RollNo, ad.Dob, ad.Gender, ad.ContactNo))
\ni += 1<\/p>\n

def MarksClicked(self):
\nkey = self.Tree.focus()
\nregid =self.Tree.item(key,”text”)
\nname =self.Tree.item(key,”values”)<\/p>\n

sessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb2.current()].CourseId
\nsem = self.cmb3.get()<\/p>\n

db = DBMarks()
\nMarksList = db.CheckMarks(regid,sem)<\/p>\n

if MarksList != []:
\nobj = UpdateMarksForm(regid,sessid,cid,sem,name, MarksList)
\nobj.showDialog()<\/p>\n

else:
\nobj = MarksForm(regid,sessid,cid,sem,name)
\nobj.showDialog()<\/p>\n

def ViewMarksClicked(self):
\nkey = self.Tree.focus()
\nregid =self.Tree.item(key,”text”)
\nname = self.Tree.item(key,”values”)<\/p>\n

sessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb2.current()].CourseId
\nsem = self.cmb3.get()<\/p>\n

db = DBMarks()
\nMarksList = db.CheckMarks(regid,sem)<\/p>\n

obj = ViewMarksForm(sem,regid,name,sessid,cid,MarksList)
\nobj.showDialog()<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

10.datalayer.py<\/h2>\n

import pyodbc
\nfrom abc import ABC
\nfrom components import Course, Session, Subject, Student, SemesterSubjects, SubjectNames,AttendanceRecord<\/p>\n

class DBOperations(ABC):
\ndef __init__(self):
\nself.con = pyodbc.connect(“DRIVER={SQL SERVER};SERVER=DESKTOP-4GE4N50\\DALJEETSERVER;database=myproject;username=sa;pwd=1@Daljeet”)<\/p>\n

class DBCourse(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def AddCourse(self, c):<\/p>\n

cur = self.con.cursor()<\/p>\n

query = “Insert into Courses values (?,?)”
\nrow = (c.CourseName, c.Description)<\/p>\n

cur.execute(query, row)
\nself.con.commit()<\/p>\n

def GetCourse(self):
\ncur = self.con.cursor()
\ncur.execute(“Select * from Courses”)<\/p>\n

records = cur.fetchall()
\nAllCourses = []<\/p>\n

for record in records:
\npro = Course()
\npro.CourseId = record[0]
\npro.CourseName = record[1]
\npro.Description = record[2]<\/p>\n

AllCourses.append(pro)<\/p>\n

return AllCourses<\/p>\n

def DeleteCourse(self, c):
\ncur = self.con.cursor()<\/p>\n

query = “Delete from Courses where CourseId = ?”
\nrow = (c.CourseId)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

class DBSessions(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def AddSession(self, ses):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into Sessions values(?)”
\nrow = (ses.Session)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

def GetSession(self):
\ncur = self.con.cursor()
\ncur.execute(“Select * from Sessions”)<\/p>\n

records = cur.fetchall()
\nAllSessions = []<\/p>\n

for record in records:
\npro = Session()
\npro.SessionId = record[0]
\npro.Session = record[1]<\/p>\n

AllSessions.append(pro)<\/p>\n

return AllSessions<\/p>\n

def DeleteSessions(self, c):
\ncur = self.con.cursor()<\/p>\n

query = “Delete from Sessions where SessionId = ?”
\nrow = (c.SessionId)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

\nclass DBSubjects(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def AddSubject(self, sub):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into Subjects values(?,?)”
\nrow = (sub.Subject, sub.Description)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

def GetSubjects(self):
\ncur = self.con.cursor()
\ncur.execute(“Select * from Subjects”)<\/p>\n

records = cur.fetchall()
\nAllSubjects = []<\/p>\n

for record in records:
\npro = Subject()
\npro.SubjectId = record[0]
\npro.Subject = record[1]
\npro.Description = record[2]<\/p>\n

AllSubjects.append(pro)<\/p>\n

return AllSubjects<\/p>\n

def DeleteSubjects(self, c):
\ncur = self.con.cursor()<\/p>\n

query = “Delete from Subjects where SubjectId = ?”
\nrow = (c.SubjectId)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

class DBStudents(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

\ndef AddStudent(self, stud):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into Students values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)”
\n#row =(stud.RollNo, stud.RegistrationDate, stud.Name, stud.Dob, stud.Gender, stud.FatherName, stud.MotherName, stud.Address, stud.City, stud.ContactNo, stud.EmailId, stud.Nationality, stud.CourseId, stud.SessionID)
\nrow=(stud.RollNo, stud.RegistrationDate,stud.Name,stud.Dob, stud.Gender,stud.FatherName,stud.MotherName,stud.Address, stud.City, stud.ContactNo,stud.EmailId,stud.Nationality,stud.CourseId,stud.SessionID)
\ncur.execute(query,row)
\nself.con.commit()<\/p>\n

def ViewStudents(self, cid , sid):
\ncur = self.con.cursor()<\/p>\n

query=”Select RegistrationId,Name,RollNo,RegistrationDate,Dob,ContactNo from Students where CourseId = ? and SessionId = ?”
\nrow = (cid,sid)<\/p>\n

cur.execute(query, row)
\nrecords = cur.fetchall()
\nStudentDetailsList = []<\/p>\n

for record in records:
\ncomp = Student()
\ncomp.RegistrationId = record[0]
\ncomp.Name = record[1]
\ncomp.RollNo = record[2]
\ncomp.RegistrationDate = record[3]
\ncomp.Dob = record[4]
\ncomp.ContactNo = record[5]<\/p>\n

StudentDetailsList.append(comp)<\/p>\n

return StudentDetailsList<\/p>\n

def FindStudent(self,sessid,cid,sem):
\ncur = self.con.cursor()<\/p>\n

query = “select * from students where CourseId=? and SessionId=? and RegistrationId IN (Select RegistrationId From Enrollments Where Semester=? and IsCurrent=1)”
\nrow = (cid,sessid,sem)<\/p>\n

cur.execute(query,row)
\nrecords = cur.fetchall()<\/p>\n

AllDetails = []<\/p>\n

for record in records:
\nst = Student()
\nst.RegistrationId = record[0]
\nst.RollNo = record[1]
\nst.RegistrationDate = record[2]
\nst.Name = record[3]
\nst.Dob = record[4]
\nst.Gender = record[5]
\nst.FatherName = record[6]
\nst.MotherName = record[7]
\nst.Address = record[8]
\nst.City = record[9]
\nst.ContactNo = record[10]
\nst.EmailId = record[11]
\nst.Nationality = record[12]
\nst.CourseId = record[13]
\nst.SessionID = record[14]<\/p>\n

AllDetails.append(st)<\/p>\n

return AllDetails<\/p>\n

\nclass DBSemesterSubjects(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def StoreValues(self, val):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into SemesterSubjects values (?,?,?,?)”
\nrow = (val.Semester, val.CourseId, val.SubjectId, val.SessionId)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

def Getdata(self, val):
\ncur = self.con.cursor()<\/p>\n

query = “Select ss.SemesterSubjectId, ss.Semester, sub.Subject from SemesterSubjects as ss,Sessions as sess, Courses as c,Subjects as sub where ss.CourseId = c.CourseId and ss.SubjectId = sub.SubjectId and ss.SessionId = sess.SessionId and ss.CourseId = ? and ss.SessionId = ? and ss.Semester = ?”
\nrow = (val.CourseId, val.SessionId , val.Semester)<\/p>\n

cur.execute(query, row)<\/p>\n

records = cur.fetchall()
\nSemesterSubjectsList = []<\/p>\n

for record in records:
\nss = SemesterSubjects()
\nss.SemesterSubjectId = record[0]
\nss.Semester = record[1]
\nss.SubjectId = record[2]<\/p>\n

SemesterSubjectsList.append(ss)
\nreturn SemesterSubjectsList<\/p>\n

class DBEnrollment(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def FindRoll(self, roll):
\ncur = self.con.cursor()<\/p>\n

query = “Select RegistrationId,RollNo,RegistrationDate,Name,Dob,Gender,FatherName,MotherName,Address,City,ContactNo,EmailId,Nationality,c.courseName, s.session from Students as st ,Courses as c ,Sessions as s where st.CourseId = c.CourseId and st.SessionId = s.SessionId and RollNo = ?”
\nrow = roll<\/p>\n

cur.execute(query, row)
\nrecords = cur.fetchall()
\nAllData = []<\/p>\n

for record in records:
\nst = Student()
\nst.RegistrationId = record[0]
\nst.RollNo = record[1]
\nst.RegistrationDate = record[2]
\nst.Name = record[3]
\nst.Dob = record[4]
\nst.Gender = record[5]
\nst.FatherName = record[6]
\nst.MotherName = record[7]
\nst.Address = record[8]
\nst.City = record[9]
\nst.ContactNo = record[10]
\nst.EmailId = record[11]
\nst.Nationality = record[12]
\nst.CourseId = record[13]
\nst.SessionID = record[14]<\/p>\n

AllData.append(st)
\nreturn AllData<\/p>\n

def Register(self,date,sem,rid):
\ncur = self.con.cursor()<\/p>\n

cur.execute(“Update Enrollments set IsCurrent=0 where RegistrationId=?”,(rid))<\/p>\n

cur.execute(“Insert into Enrollments values(?,?,?,?)”,(date,sem,rid,1))
\nself.con.commit()<\/p>\n

class DBMarks(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def CheckMarks(self,rid,sem):
\ncur = self.con.cursor()<\/p>\n

cur.execute(“select Marks from Marks as [M] , SemesterSubjects[SS] where M.SemesterSubjectId = SS.SemesterSubjectId and RegistrationId = ? and SS.Semester = ?”,(rid,sem))
\ndbMarks = cur.fetchall()
\nMarksList = []
\nfor marks in dbMarks:
\nMarksList.append(marks[0])<\/p>\n

return MarksList<\/p>\n

def GetSubjects(self, sessid,cid,sem):
\ncur = self.con.cursor()<\/p>\n

query = “Select SS.SemesterSubjectId, S.Subject From SemesterSubjects as [SS], Subjects as [S] Where SS.SubjectId=S.SubjectId and SS.SessionId = ? and SS.CourseId = ? and SS.Semester = ?”
\nrow = (sessid,cid,sem)<\/p>\n

cur.execute(query, row)
\nrecords = cur.fetchall()<\/p>\n

AllSubjects = []<\/p>\n

for record in records:
\nsn = SubjectNames()
\nsn.SemesterSubjectId = record[0]
\nsn.Subject = record[1]<\/p>\n

AllSubjects.append(sn)<\/p>\n

return AllSubjects<\/p>\n

def AddMarks(self, ssid, rid, marks,date):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into Marks values (?,?,?,?)”
\nrow = (ssid,rid,marks,date)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

def UpdateMarks(self, regid,ssid, marks):
\ncur = self.con.cursor()<\/p>\n

query = “Update Marks set Marks = ? where RegistrationId = ? and SemesterSubjectId = ?”
\nrow = (marks, regid, ssid)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

class DBAttendance(DBOperations):
\ndef __init__(self):
\nDBOperations.__init__(self)<\/p>\n

def SaveAttendance(self,date,rid,eid,att):
\ncur = self.con.cursor()<\/p>\n

query = “Insert into Attendance values(?,?,?,?)”
\nrow = (date, rid, eid, att)<\/p>\n

cur.execute(query,row)
\nself.con.commit()<\/p>\n

def GetEnrollmentId(self, regid):
\ncur = self.con.cursor()<\/p>\n

cur.execute(“Select EnrollmentId from Enrollments where RegistrationId = ? and IsCurrent = 1”, (regid))
\nrecords = cur.fetchall()
\nEnrollmentIdList = []<\/p>\n

for record in records:
\nEnrollmentIdList.append(record[0])<\/p>\n

return EnrollmentIdList<\/p>\n

def GetAttendance(self, sem, cid, sid):
\ncur = self.con.cursor()<\/p>\n

query = “select S.RegistrationId, S.Name, DatePart(Day, A.Date) as [Day], A.Attendence From Attendance as [A], Students as [S] Where A.RegistrationId=S.RegistrationId and A.RegistrationId IN (Select RegistrationId From Enrollments where Semester=? and IsCurrent=1) and S.CourseId = ? and S.SessionId = ? Order by A.RegistrationId, [Day]”
\nrow = (sem, cid, sid)<\/p>\n

cur.execute(query, row)
\nrecords = cur.fetchall()
\nAttendanceList = []<\/p>\n

\nfor record in records:
\nAtt = AttendanceRecord()
\nAtt.RegistrationId = int(record[0])
\nAtt.Name = record[1]
\nAtt.Day = record[2]
\nAtt.Attendance = record[3]<\/p>\n

AttendanceList.append(Att)<\/p>\n

return AttendanceList<\/p>\n

11.components.py<\/h2>\n

class Course:
\ndef __init__(self):
\nself.CourseId = 0
\nself.CourseName = “”
\nself.Description = “”<\/p>\n

class Session:
\ndef __init__(self):
\nself.SessionId = 0
\nself.Session = 0<\/p>\n

class Subject:
\ndef __init__(self):
\nself.SubjectId = 0
\nself.Subject = “”
\nself.Description = “”<\/p>\n

class Student:
\ndef __init__(self):
\nself.RegistrationId = 0
\nself.RollNo = 0
\nself.RegistrationDate = “”
\nself.Name = “”
\nself.Dob = “”
\nself.Gender = “”
\nself.FatherName = “”
\nself.MotherName = “”
\nself.Address = “”
\nself.City = “”
\nself.ContactNo = 0
\nself.EmailId = “”
\nself.Nationality = “”
\nself.CourseId = 0
\nself.SessionID = 0<\/p>\n

class SemesterSubjects:
\ndef __init__(self):
\nself.SemesterSubjectId = 0
\nself.Semester = “”
\nself.CourseId = 0
\nself.SubjectId = 0
\nself.SessionId = 0<\/p>\n

class SubjectNames:
\ndef __init__(self):
\nself.SemesterSubjectId = 0
\nself.Subject = “”<\/p>\n

class AttendanceRecord:
\ndef __init__(self):
\nself.RegistrationId = 0
\nself.Name = “”
\nself.Day = 0
\nself.Attendance = 0<\/p>\n

12.Attendance.py<\/h2>\n

import tkinter as tk
\nfrom tkinter import Canvas, Scrollbar,messagebox
\nfrom tkinter.ttk import Combobox
\nfrom datalayer import DBSessions, DBCourse, DBStudents, DBAttendance<\/p>\n

class Attendance:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.geometry(“505×480”)
\nself.root.title(“Marks”)
\nself.Date = tk.StringVar()<\/p>\n

self.topframe = tk.Frame(self.root, width = 505 , height = 120)
\nself.lbl1 = tk.Label(self.topframe, text = “Session”)
\nself.lbl1.place(x = 10 , y = 10)
\nself.cmb1 = Combobox(self.topframe, state = “readonly”)
\nself.cmb1.place(x = 70, y = 10)
\ndbsessions = DBSessions()
\nself.AllSessions = dbsessions.GetSession()
\nSessionList = []
\nfor sess in self.AllSessions:
\nSessionList.append(sess.Session)
\nself.cmb1[‘values’] = SessionList<\/p>\n

self.lbl2 = tk.Label(self.topframe, text = “Course”)
\nself.lbl2.place(x = 290 , y =10)
\nself.cmb2 = Combobox(self.topframe, state = “readonly”)
\nself.cmb2.place(x = 350, y = 10)
\ndbcourses = DBCourse()
\nself.AllCourses = dbcourses.GetCourse()
\nCourseList = []
\nfor cour in self.AllCourses:
\nCourseList.append(cour.CourseName)
\nself.cmb2[‘values’] = CourseList<\/p>\n

self.lbl3 = tk.Label(self.topframe, text = “Semester”)
\nself.lbl3.place(x = 10 , y = 40)
\nself.cmb3 = Combobox(self.topframe, state = “readonly”)
\nself.cmb3.place(x = 70, y = 40)
\nself.cmb3[‘values’] = [‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’]<\/p>\n

self.lbl4 = tk.Label(self.topframe, text = “Date”)
\nself.lbl4.place(x = 290, y = 40)
\nself.ent4 = tk.Entry(self.topframe, textvariable = self.Date, width = 23)
\nself.ent4.place(x = 350, y = 40)
\nself.errlbl = tk.Label(self.topframe, text = “”, fg = “Gray”)
\nself.errlbl.place(x = 350, y = 60)<\/p>\n

self.ShowButton = tk.Button(self.topframe, text = “Show”,command = self.ShowClicked, width = 12)
\nself.ShowButton.place(x = 205, y = 80)<\/p>\n

self.topframe.pack(side = “top”)<\/p>\n

self.myframe = tk.Frame(self.root, width = 400, height = 100, bd = 1)
\nself.myframe.place(x = 10 , y = 140)
\nself.scrollableframe()<\/p>\n

self.btn= tk.Button(self.root, text = “Mark Attendence”, command = self.MarkAttendance)
\nself.btn.place(x = 200, y = 445)<\/p>\n

def ShowClicked(self):
\nself.r = 1
\nsessid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb2.current()].CourseId
\nsem = self.cmb3.get()<\/p>\n

db = DBStudents()
\nStudentsList = db.FindStudent(sessid,cid,sem)
\nself.AttendanceList = []
\nself.EnrollmentIdList = []<\/p>\n

self.frame.destroy()
\nself.myframe = tk.Frame(self.root, width = 465, height = 100, bd = 1)
\nself.myframe.place(x = 10 , y = 140)
\nself.scrollableframe()<\/p>\n

for Student in StudentsList:
\nlistvar = tk.StringVar()
\nlistvar.set(0)
\nlbl5 = tk.Label(self.frame, text = Student.RegistrationId, bg = “White”)
\nlbl5.grid(row = self.r, column = 0)
\nlbl6 = tk.Label(self.frame, text = Student.Name, bg = “White”)
\nlbl6.grid(row = self.r, column = 1)
\nlbl7 = tk.Label(self.frame, text = Student.RollNo, bg = “White”)
\nlbl7.grid(row = self.r, column = 2)
\nchk = tk.Checkbutton(self.frame, variable = listvar, text = “”, bg = “White”)
\nchk.grid(row = self.r, column = 3)
\nself.r += 1<\/p>\n

self.AttendanceList.append((listvar,Student.RegistrationId))
\ndb = DBAttendance()
\nEIL = db.GetEnrollmentId(Student.RegistrationId)
\nself.EnrollmentIdList.append(EIL)<\/p>\n

def MarkAttendance(self):
\nCheck = self.CheckEntries()
\nif Check == True:
\ndb = DBAttendance()
\nfor a,m in zip(self.AttendanceList, self.EnrollmentIdList):
\natt = a[0].get()
\nrid = a[1]
\neid = m[0]
\ndate = self.Date.get()
\ndb.SaveAttendance(date,rid,eid,att)
\nmessagebox.showinfo(“Attendance”, “Attendance has been Marked”)<\/p>\n

def CheckEntries(self):
\nErr = True
\nself.errlbl.config(text = “”)<\/p>\n

if self.Date.get() == “”:
\nself.errlbl.config(text = “*Field cannot be empty.”)
\nmessagebox.showerror(“Attendence”, “Fill the required fields!”)
\nErr = False<\/p>\n

return Err<\/p>\n

def scrollableframe(self):
\nself.canvas = Canvas(self.myframe, bg = “White”)
\nself.frame = tk.Frame(self.canvas, bg = “White”)
\nself.myscrollbar = Scrollbar(self.myframe, orient = “vertical”, command = self.canvas.yview)
\nself.canvas.configure(yscrollcommand = self.myscrollbar.set)<\/p>\n

self.myscrollbar.pack(side = “right”, fill = “y”)
\nself.canvas.pack(side = “left”)
\nself.canvas.create_window((0,0),window = self.frame, anchor = ‘nw’)
\nself.frame.bind(“<Configure>”, self.myfunction)<\/p>\n

self.lbl1 = tk.Label(self.frame, text = “RegistrationId” , bg = “White”)
\nself.lbl1.grid(row = 0, column = 0)
\nself.lbl2 = tk.Label(self.frame, text = “Name” , bg = “White”)
\nself.lbl2.grid(row = 0, column = 1)
\nself.lbl3 = tk.Label(self.frame, text = “Roll No.” , bg = “White”)
\nself.lbl3.grid(row = 0, column = 2)
\nself.lbl4 = tk.Label(self.frame, text = “Attendance” , bg = “White”)
\nself.lbl4.grid(row = 0, column = 3)
\nself.frame.grid_columnconfigure(0, minsize =80)
\nself.frame.grid_columnconfigure(1, minsize =180)
\nself.frame.grid_columnconfigure(2, minsize =100)
\nself.frame.grid_columnconfigure(3, minsize =100)<\/p>\n

def myfunction(self,event):
\nself.canvas.configure(scrollregion = self.canvas.bbox(“all”), width = 465, height = 270)<\/p>\n

def showDiaog(self):
\nself.root.mainloop()<\/p>\n

13.AddSubject.py<\/h2>\n

import tkinter as tk
\nfrom datalayer import DBSubjects
\nfrom components import Subject
\nfrom tkinter import messagebox<\/p>\n

class AddSubject:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.grab_set()<\/p>\n

self.SubjectName = tk.StringVar()
\nself.Description = tk.StringVar()<\/p>\n

self.root.geometry(“250×100”)
\nself.root.title(“Add Subject”)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Subject”)
\nself.lbl1.place(x = 10, y = 10)<\/p>\n

self.ent1 = tk.Entry(self.root, textvariable = self.SubjectName)
\nself.ent1.place(x = 110, y = 10)<\/p>\n

self.lbl3 = tk.Label(self.root, text=”Description”)
\nself.lbl3.place(x = 10, y = 40)<\/p>\n

self.ent3 = tk.Entry(self.root, textvariable = self.Description)
\nself.ent3.place(x = 110, y =40)<\/p>\n

self.btn1 = tk.Button(self.root, text = “Save”, command = self.SaveClicked, width = 12)
\nself.btn1.place(x = 90, y =70)<\/p>\n

def SaveClicked(self):
\np = Subject()<\/p>\n

p.Subject = self.SubjectName.get()
\np.Description = self.Description.get()
\nobj=DBSubjects()
\nobj.AddSubject(p)
\nmessagebox.showinfo(“AddSubject”,”Subject has been Added successfully.”)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

14.AddSession.py<\/h2>\n

import tkinter as tk
\nfrom components import Session
\nfrom datalayer import DBSessions
\nfrom tkinter import messagebox<\/p>\n

class AddSession:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.grab_set()
\nself.root.geometry(“240×80”)
\nself.root.title(“Session”)
\nself.session = tk.StringVar()<\/p>\n

self.lbl = tk.Label(self.root, text= “Enter Session”)
\nself.lbl.place(x = 10, y = 10)
\nself.ent = tk.Entry(self.root, textvariable = self.session)
\nself.ent.place(x = 100, y = 10)<\/p>\n

self.btn = tk.Button(self.root, text = “Add”, command = self.addButton, width = 12)
\nself.btn.place(x = 70, y = 40)<\/p>\n

def addButton(self):
\ns = Session()
\ns.Session = self.session.get()
\ndb = DBSessions()
\ndb.AddSession(s)
\nmessagebox.showinfo(“Add Session”, “Session was added successfully.”)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

15.AddCourse.py<\/h2>\n

import tkinter as tk
\nfrom datalayer import DBCourse
\nfrom components import Course
\nfrom tkinter import messagebox<\/p>\n

class AddCourse:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.grab_set()
\nself.root.title(“Add Course”)<\/p>\n

self.CourseName = tk.StringVar()
\nself.Description = tk.StringVar()<\/p>\n

self.root.geometry(“245×115”)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Course Name”)
\nself.lbl1.place(x = 10, y = 10)<\/p>\n

self.ent1 = tk.Entry(self.root, textvariable = self.CourseName)
\nself.ent1.place(x = 110, y = 10)<\/p>\n

self.lbl3 = tk.Label(self.root, text=”Description”)
\nself.lbl3.place(x = 10, y = 40)<\/p>\n

self.ent3 = tk.Entry(self.root, textvariable = self.Description)
\nself.ent3.place(x = 110, y =40)<\/p>\n

self.btn1 = tk.Button(self.root, text = “Save”, command = self.SaveClicked, width = 12)
\nself.btn1.place(x = 70, y =80)<\/p>\n

def SaveClicked(self):
\np = Course()<\/p>\n

p.CourseName = self.CourseName.get()
\np.Description = self.Description.get()
\nobj=DBCourse()
\nobj.AddCourse(p)
\nmessagebox.showinfo(“Add Course”, “Course was added successfully.”)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

16.ViewAttendance.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Combobox, Treeview
\nfrom datalayer import DBSessions, DBCourse, DBStudents, DBAttendance<\/p>\n

class ViewAttendance:
\ndef __init__ (self):
\nself.root=tk.Toplevel()
\nself.root.geometry(“1055×340”)
\nself.root.title(“ViewAttendance”)
\nself.root.resizable(“false”,”false”)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Session”)
\nself.lbl1.place(x = 10 , y = 10)
\nself.cmb1 = Combobox(self.root, state = “readonly”)
\nself.cmb1.place(x = 70, y = 10)
\ndbsessions = DBSessions()
\nself.AllSessions = dbsessions.GetSession()
\nSessionList = []
\nfor sess in self.AllSessions:
\nSessionList.append(sess.Session)
\nself.cmb1[‘values’] = SessionList<\/p>\n

self.lbl2 = tk.Label(self.root, text = “Course”)
\nself.lbl2.place(x = 260 , y =10)
\nself.cmb2 = Combobox(self.root, state = “readonly”)
\nself.cmb2.place(x = 330, y = 10)
\ndbcourses = DBCourse()
\nself.AllCourses = dbcourses.GetCourse()
\nCourseList = []
\nfor cour in self.AllCourses:
\nCourseList.append(cour.CourseName)
\nself.cmb2[‘values’] = CourseList<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Semester”)
\nself.lbl3.place(x = 540 , y = 10)
\nself.cmb3 = Combobox(self.root, state = “readonly”)
\nself.cmb3.place(x = 620, y = 10)
\nself.cmb3[‘values’] = [‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’]
\nself.cmb3.bind(“<<ComboboxSelected>>”, self.SemesterChanged)<\/p>\n

\nself.lbl4 = tk.Label(self.root, text = “Month”)
\nself.lbl4.place(x = 820 , y = 10)
\nself.cmb4 = Combobox(self.root, state = “readonly”)
\nself.cmb4.place(x = 900, y = 10)<\/p>\n

self.btn = tk.Button(self.root, text = “Show”, command = self.ShowClicked, width = 12)
\nself.btn.place(x = 350, y = 50)<\/p>\n

self.btn1 = tk.Button(self.root, text = “Exit”, command = self.root.destroy, width = 12)
\nself.btn1.place(x = 650, y = 50)<\/p>\n

self.Tree = Treeview(self.root)
\nself.Tree.place(x = 10, y = 100, width = 1035)<\/p>\n

\ndef SemesterChanged(self, event):
\nsemesterindex = self.cmb3.current()+1<\/p>\n

if semesterindex%2==0:
\nself.cmb4[‘values’]=[“Aug”,”Sept”,”Oct”,”Nov”,”Dec”]
\nelse:
\nself.cmb4[‘values’]=[“Jan”,”Feb”,”Mar”,”Apr”,”May”]<\/p>\n

def ShowClicked(self):
\nself.Tree.column(“#0”,width=100)
\nsemesterindex = self.cmb3.current()+1<\/p>\n

month = 0<\/p>\n

if semesterindex%2==0:
\nmonth = self.cmb4.current()+7
\nelse:
\nmonth = self.cmb4.current()+1<\/p>\n

headings = []<\/p>\n

if month==2:
\nfor i in range(1,29):
\nheadings.append(str(i))<\/p>\n

elif month==1 or month==3 or month==5 or month==7 or month==8 or month==10 or month==12:
\nfor i in range(1,32):
\nheadings.append(str(i))<\/p>\n

else:
\nfor i in range(1,31):
\nheadings.append(str(i))<\/p>\n

\nself.Tree[“columns”] = headings <\/p>\n

\nfor heading in headings:
\nself.Tree.heading(heading, text=heading)<\/p>\n

if len(headings) == 28:
\nprint(“28”)
\nself.Set28Widths()
\nelif len(headings) == 30:
\nself.Set30Widths()
\nelse:
\nself.Set31Widths()<\/p>\n

sid = self.AllSessions[self.cmb1.current()].SessionId
\ncid = self.AllCourses[self.cmb2.current()].CourseId
\nsem = self.cmb3.get()<\/p>\n

db = DBAttendance()
\nrecords = db.GetAttendance(sem, cid ,sid)<\/p>\n

i = 0
\natt = [”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”]<\/p>\n

\nregid = records[0].RegistrationId
\nName = “”<\/p>\n

for record in records: <\/p>\n

if record.RegistrationId==regid:
\natt[record.Day-1] = record.Attendance
\nelse:
\nself.Tree.insert(“”, i, text = Name , values= (att))
\natt = [”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”]
\natt[record.Day-1] = record.Attendance<\/p>\n

regid=record.RegistrationId<\/p>\n

Name=record.Name<\/p>\n

i += 1<\/p>\n

if i==len(records):
\nself.Tree.insert(“”, i, text = Name , values= (att))<\/p>\n

def Set31Widths(self):<\/p>\n

self.Tree.column(“1”,width=30)
\nself.Tree.column(“2”,width=30)
\nself.Tree.column(“3”,width=30)
\nself.Tree.column(“4”,width=30)
\nself.Tree.column(“5”,width=30)
\nself.Tree.column(“6”,width=30)
\nself.Tree.column(“7”,width=30)
\nself.Tree.column(“8”,width=30)
\nself.Tree.column(“9”,width=30)
\nself.Tree.column(“10”,width=30)
\nself.Tree.column(“11”,width=30)
\nself.Tree.column(“12”,width=30)
\nself.Tree.column(“13”,width=30)
\nself.Tree.column(“14”,width=30)
\nself.Tree.column(“15”,width=30)
\nself.Tree.column(“16”,width=30)
\nself.Tree.column(“17”,width=30)
\nself.Tree.column(“18”,width=30)
\nself.Tree.column(“19”,width=30)
\nself.Tree.column(“20”,width=30)
\nself.Tree.column(“21”,width=30)
\nself.Tree.column(“22”,width=30)
\nself.Tree.column(“23”,width=30)
\nself.Tree.column(“24”,width=30)
\nself.Tree.column(“25”,width=30)
\nself.Tree.column(“26”,width=30)
\nself.Tree.column(“27”,width=30)
\nself.Tree.column(“28”,width=30)
\nself.Tree.column(“29”,width=30)
\nself.Tree.column(“30”,width=30)
\nself.Tree.column(“31”,width=30)<\/p>\n

def Set30Widths(self):
\nself.Tree.column(“1”,width=30)
\nself.Tree.column(“2”,width=30)
\nself.Tree.column(“3”,width=30)
\nself.Tree.column(“4”,width=30)
\nself.Tree.column(“5”,width=30)
\nself.Tree.column(“6”,width=30)
\nself.Tree.column(“7”,width=30)
\nself.Tree.column(“8”,width=30)
\nself.Tree.column(“9”,width=30)
\nself.Tree.column(“10”,width=30)
\nself.Tree.column(“11”,width=30)
\nself.Tree.column(“12”,width=30)
\nself.Tree.column(“13”,width=30)
\nself.Tree.column(“14”,width=30)
\nself.Tree.column(“15”,width=30)
\nself.Tree.column(“16”,width=30)
\nself.Tree.column(“17”,width=30)
\nself.Tree.column(“18”,width=30)
\nself.Tree.column(“19”,width=30)
\nself.Tree.column(“20”,width=30)
\nself.Tree.column(“21”,width=30)
\nself.Tree.column(“22”,width=30)
\nself.Tree.column(“23”,width=30)
\nself.Tree.column(“24”,width=30)
\nself.Tree.column(“25”,width=30)
\nself.Tree.column(“26”,width=30)
\nself.Tree.column(“27”,width=30)
\nself.Tree.column(“28”,width=30)
\nself.Tree.column(“29”,width=30)
\nself.Tree.column(“30”,width=30)<\/p>\n

def Set28Widths(self):
\nself.Tree.column(“1”,width=30)
\nself.Tree.column(“2”,width=30)
\nself.Tree.column(“3”,width=30)
\nself.Tree.column(“4”,width=30)
\nself.Tree.column(“5”,width=30)
\nself.Tree.column(“6”,width=30)
\nself.Tree.column(“7”,width=30)
\nself.Tree.column(“8”,width=30)
\nself.Tree.column(“9”,width=30)
\nself.Tree.column(“10”,width=30)
\nself.Tree.column(“11”,width=30)
\nself.Tree.column(“12”,width=30)
\nself.Tree.column(“13”,width=30)
\nself.Tree.column(“14”,width=30)
\nself.Tree.column(“15”,width=30)
\nself.Tree.column(“16”,width=30)
\nself.Tree.column(“17”,width=30)
\nself.Tree.column(“18”,width=30)
\nself.Tree.column(“19”,width=30)
\nself.Tree.column(“20”,width=30)
\nself.Tree.column(“21”,width=30)
\nself.Tree.column(“22”,width=30)
\nself.Tree.column(“23”,width=30)
\nself.Tree.column(“24”,width=30)
\nself.Tree.column(“25”,width=30)
\nself.Tree.column(“26”,width=30)
\nself.Tree.column(“27”,width=30)
\nself.Tree.column(“28”,width=30)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

17.ViewCourses.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Treeview
\nfrom tkinter import messagebox
\nfrom datalayer import DBCourse
\nfrom components import Course<\/p>\n

class ViewCourses:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.grab_set()<\/p>\n

self.tree = Treeview(self.root)
\nself.tree.pack()<\/p>\n

self.tree[‘columns’] = (“c1″,”c2”)
\nself.tree.heading(“c1”, text = “Course”)
\nself.tree.heading(“c2”, text = “Description”)<\/p>\n

db = DBCourse()
\nAllCourses = db.GetCourse()<\/p>\n

i = 1<\/p>\n

for c in AllCourses:
\nself.tree.insert(“”,i,text = c.CourseId, values= (c.CourseName, c.Description))
\ni = i+1<\/p>\n

self.DeleteButton = tk.Button(self.root,text=”Delete”, command = self.DeleteClicked)
\nself.DeleteButton.pack()<\/p>\n

def DeleteClicked(self):
\nret = messagebox.askyesno(“Courses”,”Do you want to delete the course?”)
\nif ret == True:
\nkey = self.tree.focus()
\ncid = int(self.tree.item(key,”text”))
\nc = Course()
\ndb = DBCourse()
\nc.CourseId = cid
\ndb.DeleteCourse(c)
\nself.tree.delete(key)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

18.ViewMarksForm.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Combobox
\nfrom datalayer import DBMarks
\nfrom functools import partial<\/p>\n

class ViewMarksForm:
\ndef __init__(self,sem,regid,name,sessid,cid,Marks):
\nself.root = tk.Toplevel()
\nself.root.geometry(“530×385”)
\nself.root.title(“View Marks”)
\nself.y = 5
\nself.rid = tk.StringVar()
\nself.Name = tk.StringVar()<\/p>\n

self.lbl2 = tk.Label(self.root, text = “RegistrationId”)
\nself.lbl2.place(x = 10, y = 10)
\nself.ent2 = tk.Entry(self.root, textvariable = self.rid, state = “readonly”)
\nself.ent2.place(x = 110, y = 10)
\nself.rid.set(regid)<\/p>\n

self.lbl3 = tk.Label(self.root, text = “Name”)
\nself.lbl3.place(x = 250, y = 10)
\nself.ent3 = tk.Entry(self.root, textvariable = self.Name, state = “readonly”)
\nself.ent3.place(x = 350, y = 10)
\nself.Name.set(name)<\/p>\n

self.lbl1 = tk.Label(self.root, text = “Semester”)
\nself.lbl1.place(x = 10, y = 50)
\nself.cmb = Combobox(self.root)
\nself.cmb.place(x = 110, y = 50)
\nself.cmb[‘values’] = [‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8’]<\/p>\n

self.ShowButton = tk.Button(self.root, text = “Show”, command = partial(self.ShowClicked,sessid,cid,regid))
\nself.ShowButton.place(x = 350, y = 50)<\/p>\n

self.frame = tk.Frame(self.root, width = 400, height = 400)
\nself.frame.place(x = 105, y = 100)<\/p>\n

self.GetMarks(sessid,cid,sem,Marks)
\nomarks = 0
\nfor mark in Marks:
\nomarks += mark<\/p>\n

if Marks != []:
\nobt = tk.Label(self.frame, text = “Obtained Marks”)
\nobt.place(x = 25, y = self.y + 20)
\nobtlbl = tk.Label(self.frame, text = omarks).place(x = 125, y = self.y + 20)<\/p>\n

total = tk.Label(self.frame, text = “Total Marks”)
\ntotal.place(x = 25, y = self.y + 50)
\ntotallbl = tk.Label(self.frame, text = len(Marks)*100).place(x = 125, y = self.y + 50)<\/p>\n

per = tk.Label(self.frame, text = “Percentage”)
\nper.place(x = 25, y = self.y + 80)
\nperlbl = tk.Label(self.frame, text = (omarks\/len(Marks))).place(x = 125, y = self.y + 80)<\/p>\n

def ShowClicked(self,sessid,cid,regid):
\nself.y = 5
\nself.frame.destroy()
\nself.frame = tk.Frame(self.root, width = 400, height = 400)
\nself.frame.place(x = 105, y = 100)
\nsem = self.cmb.get()
\ndb = DBMarks()
\nMarks = db.CheckMarks(regid,sem)
\nself.GetMarks(sessid,cid,sem,Marks)<\/p>\n

if Marks != []:
\nomarks = 0
\nfor mark in Marks:
\nomarks += mark
\nobt = tk.Label(self.frame, text = “Obtained Marks”)
\nobt.place(x = 25, y = self.y + 20)
\nobtlbl = tk.Label(self.frame, text = omarks).place(x = 125, y = self.y + 20)<\/p>\n

total = tk.Label(self.frame, text = “Total Marks”)
\ntotal.place(x = 25, y = self.y + 50)
\ntotallbl = tk.Label(self.frame, text = len(Marks)*100).place(x = 125, y = self.y + 50)<\/p>\n

per = tk.Label(self.frame, text = “Percentage”)
\nper.place(x = 25, y = self.y + 80)
\nperlbl = tk.Label(self.frame, text = (omarks\/len(Marks))).place(x = 125, y = self.y + 80)<\/p>\n

def GetMarks(self,sessid,cid,sem,Marks):
\ndb = DBMarks()
\nself.AllSubjects = db.GetSubjects(sessid,cid,sem)
\nself.MarksList = []<\/p>\n

if Marks == []:
\nMarks = [“NULL”] * len(self.AllSubjects)<\/p>\n

for a,m in zip(self.AllSubjects,Marks):
\nlistvar = tk.StringVar()
\nself.MarksList.append((listvar,a.SemesterSubjectId))
\nlbl = tk.Label(self.frame, text = a.Subject)
\nlbl.place(x = 5, y = self.y)
\nent = tk.Entry(self.frame, textvariable = listvar, state = “readonly”)
\nent.place(x = 95, y = self.y)
\nself.y += 40
\nlistvar.set(m)<\/p>\n

\ndef showDialog(self):<\/p>\n

self.root.mainloop()<\/p>\n

19.ViewSessions.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Treeview
\nfrom tkinter import messagebox
\nfrom datalayer import DBSessions
\nfrom components import Session<\/p>\n

class ViewSessions:
\ndef __init__(self):
\nself.root=tk.Toplevel()
\nself.root.grab_set()<\/p>\n

self.tree=Treeview(self.root)
\nself.tree.pack()<\/p>\n

self.tree[‘columns’]=(“c1”)
\nself.tree.heading(“c1″,text=”Session”)<\/p>\n

db=DBSessions()
\nAllSessions=db.GetSession()<\/p>\n

i=1<\/p>\n

for c in AllSessions:
\nself.tree.insert(“”,i,text=c.SessionId,values=(c.Session))
\ni=i+1<\/p>\n

self.btn=tk.Button(self.root,text=”Delete”,command=self.delete)
\nself.btn.pack()<\/p>\n

def delete(self):
\nret=messagebox.askyesno(“Session”,”do you want to delete Session?”)
\nif ret==True:
\nkey=self.tree.focus()
\ncid=int(self.tree.item(key,”text”))
\nc=Session()
\nc.SessionId=cid
\ndb=DBSessions()
\ndb.DeleteSessions(c)
\nself.tree.delete(key)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

20.ViewSubjects.py<\/h2>\n

import tkinter as tk
\nfrom tkinter.ttk import Treeview
\nfrom tkinter import messagebox
\nfrom datalayer import DBSubjects
\nfrom components import Subject<\/p>\n

class ViewSubjects:
\ndef __init__(self):
\nself.root = tk.Toplevel()
\nself.root.grab_set()
\nself.root.title(“View Subject”)<\/p>\n

self.tree = Treeview(self.root)
\nself.tree.pack()<\/p>\n

self.tree[‘columns’] = (“c1″,”c2”)
\nself.tree.heading(“c1”, text = “Course”)
\nself.tree.heading(“c2”, text = “Description”)<\/p>\n

db = DBSubjects()
\nAllSubjects = db.GetSubjects()<\/p>\n

i = 1<\/p>\n

for c in AllSubjects:
\nself.tree.insert(“”,i,text = c.SubjectId, values= (c.Subject, c.Description))
\ni = i+1<\/p>\n

self.DeleteButton = tk.Button(self.root,text=”Delete”, command = self.DeleteClicked)
\nself.DeleteButton.pack()<\/p>\n

def DeleteClicked(self):
\nret = messagebox.askyesno(“Courses”,”Do you want to delete the subject?”)
\nif ret == True:
\nkey = self.tree.focus()
\nsid = int(self.tree.item(key,”text”))
\nc = Subject()
\ndb = DBSubjects()
\nc.SubjectId = sid
\ndb.DeleteSubjects(c)
\nself.tree.delete(key)<\/p>\n

def showDialog(self):
\nself.root.mainloop()<\/p>\n

College Automation Syetem Data Base Code<\/h1>\n

USE [master]
\nGO
\n\/****** Object: Database [ProjectDB] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nCREATE DATABASE [ProjectDB]
\nCONTAINMENT = NONE
\nON PRIMARY
\n( NAME = N’ProjectDB’, FILENAME = N’C:\\Program Files\\Microsoft SQL Server\\MSSQL14.SQLEXPRESS\\MSSQL\\DATA\\ProjectDB.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
\nLOG ON
\n( NAME = N’ProjectDB_log’, FILENAME = N’C:\\Program Files\\Microsoft SQL Server\\MSSQL14.SQLEXPRESS\\MSSQL\\DATA\\ProjectDB_log.ldf’ , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
\nGO
\nALTER DATABASE [ProjectDB] SET COMPATIBILITY_LEVEL = 140
\nGO
\nIF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))
\nbegin
\nEXEC [ProjectDB].[dbo].[sp_fulltext_database] @action = ‘enable’
\nend
\nGO
\nALTER DATABASE [ProjectDB] SET ANSI_NULL_DEFAULT OFF
\nGO
\nALTER DATABASE [ProjectDB] SET ANSI_NULLS OFF
\nGO
\nALTER DATABASE [ProjectDB] SET ANSI_PADDING OFF
\nGO
\nALTER DATABASE [ProjectDB] SET ANSI_WARNINGS OFF
\nGO
\nALTER DATABASE [ProjectDB] SET ARITHABORT OFF
\nGO
\nALTER DATABASE [ProjectDB] SET AUTO_CLOSE ON
\nGO
\nALTER DATABASE [ProjectDB] SET AUTO_SHRINK OFF
\nGO
\nALTER DATABASE [ProjectDB] SET AUTO_UPDATE_STATISTICS ON
\nGO
\nALTER DATABASE [ProjectDB] SET CURSOR_CLOSE_ON_COMMIT OFF
\nGO
\nALTER DATABASE [ProjectDB] SET CURSOR_DEFAULT GLOBAL
\nGO
\nALTER DATABASE [ProjectDB] SET CONCAT_NULL_YIELDS_NULL OFF
\nGO
\nALTER DATABASE [ProjectDB] SET NUMERIC_ROUNDABORT OFF
\nGO
\nALTER DATABASE [ProjectDB] SET QUOTED_IDENTIFIER OFF
\nGO
\nALTER DATABASE [ProjectDB] SET RECURSIVE_TRIGGERS OFF
\nGO
\nALTER DATABASE [ProjectDB] SET DISABLE_BROKER
\nGO
\nALTER DATABASE [ProjectDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
\nGO
\nALTER DATABASE [ProjectDB] SET DATE_CORRELATION_OPTIMIZATION OFF
\nGO
\nALTER DATABASE [ProjectDB] SET TRUSTWORTHY OFF
\nGO
\nALTER DATABASE [ProjectDB] SET ALLOW_SNAPSHOT_ISOLATION OFF
\nGO
\nALTER DATABASE [ProjectDB] SET PARAMETERIZATION SIMPLE
\nGO
\nALTER DATABASE [ProjectDB] SET READ_COMMITTED_SNAPSHOT OFF
\nGO
\nALTER DATABASE [ProjectDB] SET HONOR_BROKER_PRIORITY OFF
\nGO
\nALTER DATABASE [ProjectDB] SET RECOVERY SIMPLE
\nGO
\nALTER DATABASE [ProjectDB] SET MULTI_USER
\nGO
\nALTER DATABASE [ProjectDB] SET PAGE_VERIFY CHECKSUM
\nGO
\nALTER DATABASE [ProjectDB] SET DB_CHAINING OFF
\nGO
\nALTER DATABASE [ProjectDB] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
\nGO
\nALTER DATABASE [ProjectDB] SET TARGET_RECOVERY_TIME = 60 SECONDS
\nGO
\nALTER DATABASE [ProjectDB] SET DELAYED_DURABILITY = DISABLED
\nGO
\nALTER DATABASE [ProjectDB] SET QUERY_STORE = OFF
\nGO
\nUSE [ProjectDB]
\nGO
\n\/****** Object: Table [dbo].[Attendance] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Attendance](
\n[uid] [int] IDENTITY(1,1) NOT NULL,
\n[Date] [date] NULL,
\n[RegistrationId] [int] NULL,
\n[EnrollmentId] [int] NULL,
\n[Attendance] [int] NOT NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[uid] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Courses] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Courses](
\n[CourseId] [int] IDENTITY(1,1) NOT NULL,
\n[courseName] [varchar](50) NULL,
\n[Description] [varchar](50) NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[CourseId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Enrollments] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Enrollments](
\n[EnrollmentId] [int] IDENTITY(1,1) NOT NULL,
\n[EDate] [date] NULL,
\n[Semester] [varchar](3) NULL,
\n[RegistrationId] [int] NULL,
\n[IsCurrent] [int] NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[EnrollmentId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Marks] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Marks](
\n[SerialNo] [int] IDENTITY(1,1) NOT NULL,
\n[SemesterSubjectId] [int] NULL,
\n[RegistrationId] [int] NULL,
\n[Marks] [int] NOT NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[SerialNo] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[SemesterSubjects] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[SemesterSubjects](
\n[SemesterSubjectId] [int] IDENTITY(1,1) NOT NULL,
\n[Semester] [varchar](3) NULL,
\n[CourseId] [int] NULL,
\n[SubjectId] [int] NULL,
\n[SessionId] [int] NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[SemesterSubjectId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Sessions] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Sessions](
\n[SessionId] [int] IDENTITY(1,1) NOT NULL,
\n[Session] [varchar](9) NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[SessionId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Students] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Students](
\n[RegistrationId] [int] IDENTITY(1,1) NOT NULL,
\n[RollNo] [int] NULL,
\n[RegistrationDate] [date] NULL,
\n[Name] [varchar](40) NULL,
\n[DOB] [date] NULL,
\n[Gender] [varchar](6) NULL,
\n[FatherName] [varchar](40) NULL,
\n[MotherName] [varchar](40) NULL,
\n[Address] [varchar](50) NULL,
\n[City] [varchar](20) NULL,
\n[ContactNo] [int] NULL,
\n[EmailId] [varchar](50) NULL,
\n[Nationality] [varchar](20) NULL,
\n[CourseId] [int] NULL,
\n[SessionId] [int] NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[RegistrationId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\n\/****** Object: Table [dbo].[Subjects] Script Date: 7\/18\/2019 2:52:01 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nCREATE TABLE [dbo].[Subjects](
\n[SubjectId] [int] IDENTITY(1,1) NOT NULL,
\n[Subject] [varchar](10) NULL,
\n[Description] [varchar](40) NULL,
\nPRIMARY KEY CLUSTERED
\n(
\n[SubjectId] ASC
\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
\n) ON [PRIMARY]
\nGO
\nSET IDENTITY_INSERT [dbo].[Courses] ON
\nGO
\nINSERT [dbo].[Courses] ([CourseId], [courseName],<\/a> [Description]) VALUES (12, N’B.Tech EE’, N’Electrical Engineering’)
\nGO
\nINSERT [dbo].[Courses] ([CourseId], [courseName], [Description]) VALUES (13, N’B.Tech ME’, N’Mechanical engineering’)
\nGO
\nINSERT [dbo].[Courses] ([CourseId], [courseName], [Description]) VALUES (14, N’B.Tech CSE’, N’Computer Science and Engineering’)
\nGO
\nINSERT [dbo].[Courses] ([CourseId], [courseName], [Description]) VALUES (15, N’B.Tech ECE’, N’Electronics and Communication Engineering’)
\nGO
\nINSERT [dbo].[Courses] ([CourseId], [courseName], [Description]) VALUES (16, N’BTech IT’, N’Information Technology’)
\nGO
\nSET IDENTITY_INSERT [dbo].[Courses] OFF
\nGO
\nSET IDENTITY_INSERT [dbo].[Enrollments] ON
\nGO
\nINSERT [dbo].[Enrollments] ([EnrollmentId], [EDate], [Semester], [RegistrationId], [IsCurrent]) VALUES (3, CAST(N’2019-07-18′ AS Date), N’5th’, 5, 1)
\nGO
\nINSERT [dbo].[Enrollments] ([EnrollmentId], [EDate], [Semester], [RegistrationId], [IsCurrent]) VALUES (4, CAST(N’2019-07-18′ AS Date), N’5th’, 8, 1)
\nGO
\nINSERT [dbo].[Enrollments] ([EnrollmentId], [EDate], [Semester], [RegistrationId], [IsCurrent]) VALUES (5, CAST(N’2019-07-18′ AS Date), N’5th’, 7, 1)
\nGO
\nSET IDENTITY_INSERT [dbo].[Enrollments] OFF
\nGO
\nSET IDENTITY_INSERT [dbo].[SemesterSubjects] ON
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (1, N”, 16, 6, 16)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (2, N”, 16, 6, 16)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (3, N’2nd’, 13, 3, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (4, N’1st’, 14, 3, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (5, N’1st’, 14, 4, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (6, N’1st’, 14, 5, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId],<\/a> [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (7, N’1st’, 14, 6, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (8, N’1st’, 14, 6, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (9, N’2nd’, 14, 3, 13)
\nGO
\nINSERT [dbo].[SemesterSubjects] ([SemesterSubjectId], [Semester], [CourseId], [SubjectId], [SessionId]) VALUES (10, N’2nd’, 14, 4, 13)
\nGO
\nSET IDENTITY_INSERT [dbo].[SemesterSubjects] OFF
\nGO
\nSET IDENTITY_INSERT [dbo].[Sessions] ON
\nGO
\nINSERT [dbo].[Sessions] ([SessionId], [Session]) VALUES (13, N’2017-2021′)
\nGO
\nINSERT [dbo].[Sessions] ([SessionId], [Session]) VALUES (14, N’2018-2022′)
\nGO
\nINSERT [dbo].[Sessions] ([SessionId], [Session]) VALUES (15, N’2019-2023′)
\nGO
\nINSERT [dbo].[Sessions] ([SessionId], [Session]) VALUES (16, N’2020-2024′)
\nGO
\nSET IDENTITY_INSERT [dbo].[Sessions] OFF
\nGO
\nSET IDENTITY_INSERT [dbo].[Students] ON
\nGO
\nINSERT [dbo].[Students] ([RegistrationId], [RollNo], [RegistrationDate], [Name], [DOB], [Gender], [FatherName], [MotherName], [Address],<\/a> [City], [ContactNo], [EmailId], [Nationality], [CourseId], [SessionId]) VALUES (5, 11701131, CAST(N’2019-08-18′ AS Date), N’Ankush Kamboj’, CAST(N’2000-02-16′ AS Date), N’Male’, N”, N”, N”, N’Abohar’, 75893, N’ankush@gmail.com’, N’Indian’, 14, 13)
\nGO
\nINSERT [dbo].[Students] ([RegistrationId], [RollNo], [RegistrationDate], [Name], [DOB], [Gender], [FatherName], [MotherName], [Address], [City], [ContactNo], [EmailId], [Nationality], [CourseId], [SessionId]) VALUES (7, 11701042, CAST(N’2019-08-18′ AS Date), N’Vanshika’, CAST(N’1999-08-06′ AS Date), N’Female’, N”, N”, N”, N’Sunam’, 78945, N’Vanshika@gmail.com’, N’Indian’, 14, 13)
\nGO
\nINSERT [dbo].[Students] ([RegistrationId], [RollNo], [RegistrationDate], [Name], [DOB], [Gender], [FatherName], [MotherName], [Address], [City], [ContactNo], [EmailId], [Nationality], [CourseId], [SessionId]) VALUES (8, 11701029, CAST(N’2019-08-18′ AS Date), N’Mehak’, CAST(N’2000-04-21′ AS Date), N’Female’, N”, N”, N”, N’Fazilka’, 78945, N’Mehak@gmail.com’, N’Indian’, 14, 13)
\nGO
\nSET IDENTITY_INSERT [dbo].[Students] OFF
\nGO
\nSET IDENTITY_INSERT [dbo].[Subjects] ON
\nGO
\nINSERT [dbo].[Subjects] ([SubjectId], [Subject], [Description]) VALUES (3, N’CP’, N’Computer Programming’)
\nGO
\nINSERT [dbo].[Subjects] ([SubjectId], [Subject], [Description]) VALUES (4, N’CN’, N’Computer Networks’)
\nGO
\nINSERT [dbo].[Subjects] ([SubjectId], [Subject], [Description]) VALUES (5, N’OOPs’, N’Object Oriented Programming’)
\nGO
\nINSERT [dbo].[Subjects] ([SubjectId], [Subject], [Description]) VALUES (6, N’SE’, N’Software Enginnering’)
\nGO
\nSET IDENTITY_INSERT [dbo].[Subjects] OFF
\nGO
\nALTER TABLE [dbo].[Attendance] WITH CHECK ADD FOREIGN KEY([EnrollmentId])
\nREFERENCES [dbo].<\/a>[Enrollments] ([EnrollmentId])
\nGO
\nALTER TABLE [dbo].[Attendance] WITH CHECK ADD FOREIGN KEY([RegistrationId])
\nREFERENCES [dbo].[Students] ([RegistrationId])
\nGO
\nALTER TABLE [dbo].[Enrollments] WITH CHECK ADD FOREIGN KEY([RegistrationId])
\nREFERENCES [dbo].[Students] ([RegistrationId])
\nGO
\nALTER TABLE [dbo].[Marks] WITH CHECK ADD FOREIGN KEY([RegistrationId])
\nREFERENCES [dbo].[Students] ([RegistrationId])
\nGO
\nALTER TABLE [dbo].[Marks] WITH CHECK ADD FOREIGN KEY([SemesterSubjectId])
\nREFERENCES [dbo].[SemesterSubjects] ([SemesterSubjectId])
\nGO
\nALTER TABLE [dbo].[SemesterSubjects] WITH CHECK ADD FOREIGN KEY([CourseId])
\nREFERENCES [dbo].[Courses] ([CourseId])
\nGO
\nALTER TABLE [dbo].[SemesterSubjects] WITH CHECK ADD FOREIGN KEY([SessionId])
\nREFERENCES [dbo].[Sessions] ([SessionId])
\nGO
\nALTER TABLE [dbo].[SemesterSubjects] WITH CHECK ADD FOREIGN KEY([SubjectId])
\nREFERENCES [dbo].[Subjects] ([SubjectId])
\nGO
\nALTER TABLE [dbo].[Students] WITH CHECK ADD FOREIGN KEY([CourseId])
\nREFERENCES [dbo].[Courses] ([CourseId])
\nGO
\nALTER TABLE [dbo].[Students] WITH CHECK ADD FOREIGN KEY([SessionId])
\nREFERENCES [dbo].[Sessions] ([SessionId])
\nGO
\nUSE [master]
\nGO
\nALTER DATABASE [ProjectDB] SET READ_WRITE
\nGO<\/p>\n

College and Home Automation System Project Using IOT Database Script<\/a><\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n
\u00a0<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Creating a “College and Home Automation System” using IoT (Internet of Things), Python, and Machine Learning involves several steps. Here’s an outline and some key components to help you get started with your project:<\/p>\n

\n

Project Objectives<\/strong><\/h3>\n
    \n
  1. Automate tasks in college and home environments, such as:\n
      \n
    • Controlling lights, fans, and appliances.<\/li>\n
    • Monitoring energy consumption.<\/li>\n
    • Security and surveillance.<\/li>\n
    • Room temperature and humidity control.<\/li>\n<\/ul>\n<\/li>\n
    • Use machine learning to make intelligent decisions:\n
        \n
      • Predict energy usage patterns.<\/li>\n
      • Detect anomalies in security systems.<\/li>\n
      • Recognize speech for voice commands.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
        \n

        Key Components<\/strong><\/h3>\n

        1. Hardware Requirements<\/strong><\/h4>\n
          \n
        • Microcontroller:<\/strong> ESP32 or Raspberry Pi.<\/li>\n
        • Sensors:<\/strong>\n
            \n
          • Temperature & Humidity (DHT11\/DHT22).<\/li>\n
          • Motion Detection (PIR Sensor).<\/li>\n
          • Light Intensity (LDR Sensor).<\/li>\n<\/ul>\n<\/li>\n
          • Actuators:<\/strong>\n
              \n
            • Relays for controlling appliances.<\/li>\n
            • Smart bulbs or plugs.<\/li>\n<\/ul>\n<\/li>\n
            • Camera Module:<\/strong> For security and surveillance.<\/li>\n
            • Wi-Fi Router:<\/strong> For IoT connectivity.<\/li>\n<\/ul>\n

              2. Software Requirements<\/strong><\/h4>\n
                \n
              • Programming Language:<\/strong> Python.<\/li>\n
              • Libraries:<\/strong>\n
                  \n
                • IoT Communication: paho-mqtt<\/code>, socket<\/code>.<\/li>\n
                • Sensor Integration: gpiozero<\/code>, adafruit-dht<\/code>.<\/li>\n
                • Machine Learning: scikit-learn<\/code>, tensorflow<\/code>.<\/li>\n
                • Voice Control: speechrecognition<\/code>, pyttsx3<\/code>.<\/li>\n<\/ul>\n<\/li>\n
                • Cloud Services:<\/strong>\n
                    \n
                  • MQTT Broker: Eclipse Mosquitto or AWS IoT.<\/li>\n
                  • Data Storage: Firebase, AWS, or Azure.<\/li>\n<\/ul>\n<\/li>\n
                  • Database:<\/strong> SQLite or cloud-based (e.g., Firebase).<\/li>\n<\/ul>\n

                    3. Machine Learning Models<\/strong><\/h4>\n
                      \n
                    • Energy Prediction:<\/strong> Time-series analysis using LSTM.<\/li>\n
                    • Anomaly Detection:<\/strong> Using k-means or isolation forests for security alerts.<\/li>\n
                    • Voice Command Recognition:<\/strong> Using an NLP model like SpeechRecognition or pretrained models (e.g., Google Speech-to-Text).<\/li>\n<\/ul>\n
                      \n

                      Project Development Steps<\/strong><\/h3>\n

                      Step 1: Setup IoT Framework<\/strong><\/h4>\n
                        \n
                      • Install necessary libraries and frameworks.<\/li>\n
                      • Use MQTT for communication between devices and server.<\/li>\n
                      • Connect sensors and actuators to ESP32 or Raspberry Pi.<\/li>\n<\/ul>\n

                        Step 2: Develop Python Backend<\/strong><\/h4>\n
                          \n
                        • Write Python scripts to read sensor data and control devices.<\/li>\n
                        • Implement APIs (using Flask or FastAPI) for communication with a web or mobile app.<\/li>\n<\/ul>\n

                          Step 3: Implement Machine Learning<\/strong><\/h4>\n
                            \n
                          • Train a model to predict energy consumption using historical data.<\/li>\n
                          • Build an anomaly detection system for identifying irregularities in sensor data.<\/li>\n
                          • Train or use a pretrained model for voice command recognition.<\/li>\n<\/ul>\n

                            Step 4: Create a User Interface<\/strong><\/h4>\n
                              \n
                            • Mobile App:<\/strong> Use Flutter or React Native.<\/li>\n
                            • Web Dashboard:<\/strong> Use Django or Flask with a front-end framework (e.g., React).<\/li>\n<\/ul>\n

                              Step 5: Integration and Testing<\/strong><\/h4>\n
                                \n
                              • Integrate all components (hardware, backend, ML models, UI).<\/li>\n
                              • Test functionality for different use cases (e.g., appliance control, security monitoring).<\/li>\n<\/ul>\n
                                \n

                                Sample Python Code Snippets<\/strong><\/h3>\n

                                Reading Data from a DHT Sensor<\/strong><\/h4>\n

                                import Adafruit_DHT<\/p>\n

                                sensor = Adafruit_DHT.DHT22
                                \npin = 4 # GPIO pin<\/p>\n

                                humidity, temperature = Adafruit_DHT.read_retry(sensor, pin)
                                \nif humidity and temperature:
                                \nprint(f”Temp: {temperature:.1f}C, Humidity: {humidity:.1f}%”)
                                \nelse:
                                \nprint(“Failed to retrieve data from sensor”)<\/p>\n

                                Controlling a Relay<\/strong><\/h4>\n
                                \n
                                \n

                                import RPi.GPIO as GPIO
                                \nimport time<\/p>\n

                                GPIO.setmode(GPIO.BCM)
                                \nrelay_pin = 17
                                \nGPIO.setup(relay_pin, GPIO.OUT)<\/p>\n

                                # Turn ON relay
                                \nGPIO.output(relay_pin, GPIO.HIGH)
                                \ntime.sleep(5) # Keep ON for 5 seconds<\/p>\n

                                # Turn OFF relay
                                \nGPIO.output(relay_pin, GPIO.LOW)
                                \nGPIO.cleanup()<\/p>\n

                                Future Enhancements<\/strong><\/h3>\n
                                  \n
                                1. Integrate AI-powered chatbots<\/strong> for natural language communication.<\/li>\n
                                2. Implement a recommendation system<\/strong> for energy optimization.<\/li>\n
                                3. Add blockchain for enhanced security<\/strong> in IoT communications.\u00a0<\/li>\n<\/ol>\n<\/div>\n
                                  \n

                                  import paho.mqtt.client as mqtt
                                  \nimport RPi.GPIO as GPIO
                                  \nimport Adafruit_DHT
                                  \nimport json
                                  \nimport time
                                  \nfrom tensorflow.keras.models import load_model<\/p>\n

                                  # — GPIO Setup —
                                  \nGPIO.setmode(GPIO.BCM)
                                  \nrelay_pins = {
                                  \n“light”: 17,
                                  \n“fan”: 27,
                                  \n“appliance”: 22
                                  \n}
                                  \nfor pin in relay_pins.values():
                                  \nGPIO.setup(pin, GPIO.OUT)
                                  \nGPIO.output(pin, GPIO.LOW)<\/p>\n

                                  # — Sensor Setup —
                                  \nsensor = Adafruit_DHT.DHT22
                                  \nsensor_pin = 4 # GPIO pin for temperature and humidity sensor<\/p>\n

                                  # — Machine Learning Model —
                                  \nmodel = load_model(“energy_predictor.h5”) # Pretrained model for energy prediction<\/p>\n

                                  def predict_energy(temperature, humidity):
                                  \n# Example preprocessing of data for prediction
                                  \ninput_data = [[temperature, humidity]]
                                  \nprediction = model.predict(input_data)
                                  \nreturn prediction[0][0]<\/p>\n

                                  # — MQTT Setup —
                                  \nbroker = “mqtt.example.com”
                                  \nport = 1883
                                  \ntopic_subscribe = “home\/automation\/control”
                                  \ntopic_publish = “home\/automation\/status”<\/p>\n

                                  def on_connect(client, userdata, flags, rc):
                                  \nprint(“Connected to MQTT Broker!\\n”)
                                  \nclient.subscribe(topic_subscribe)<\/p>\n

                                  def on_message(client, userdata, msg):
                                  \ndata = json.loads(msg.payload)
                                  \ndevice = data.get(“device”)
                                  \naction = data.get(“action”)
                                  \nif device in relay_pins:
                                  \nGPIO.output(relay_pins[device], GPIO.HIGH if action == “on” else GPIO.LOW)
                                  \nprint(f”{device} turned {action}”)
                                  \nclient.publish(topic_publish, json.dumps({“device”: device, “status”: action}))
                                  \nelse:
                                  \nprint(“Unknown device”)<\/p>\n

                                  client = mqtt.Client()
                                  \nclient.on_connect = on_connect
                                  \nclient.on_message = on_message<\/p>\n

                                  client.connect(broker, port, 60)<\/p>\n

                                  # — Main Loop —
                                  \ntry:
                                  \nclient.loop_start()
                                  \nwhile True:
                                  \n# Read sensor data
                                  \nhumidity, temperature = Adafruit_DHT.read_retry(sensor, sensor_pin)
                                  \nif humidity and temperature:
                                  \nprint(f”Temp: {temperature:.1f}C, Humidity: {humidity:.1f}%”)
                                  \nenergy_prediction = predict_energy(temperature, humidity)
                                  \nprint(f”Predicted Energy Usage: {energy_prediction:.2f} kWh”)<\/p>\n

                                  # Publish sensor data
                                  \nsensor_data = {
                                  \n“temperature”: temperature,
                                  \n“humidity”: humidity,
                                  \n“energy_prediction”: energy_prediction
                                  \n}
                                  \nclient.publish(topic_publish, json.dumps(sensor_data))
                                  \nelse:
                                  \nprint(“Failed to retrieve sensor data”)
                                  \ntime.sleep(10)
                                  \nexcept KeyboardInterrupt:
                                  \nprint(“Exiting… Cleaning up GPIO”)
                                  \nGPIO.cleanup()
                                  \nclient.loop_stop()
                                  \nclient.disconnect()<\/p>\n

                                  Here is the implementation for a “College and Home Automation System” using IoT with MQTT for communication, Raspberry Pi for hardware control, and a TensorFlow model for energy prediction.<\/p>\n

                                  The script includes:<\/p>\n

                                    \n
                                  • GPIO setup for controlling devices (lights, fan, appliances).<\/li>\n
                                  • Sensor integration for temperature and humidity.<\/li>\n
                                  • Energy prediction using a machine learning model.<\/li>\n
                                  • MQTT setup for remote control and data exchange.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n","protected":false},"excerpt":{"rendered":"

                                    PROJECT \u2013 REPORT College and Home Automation System Project Using IOT (Python & Machine Learning) COLLEGE AUTOMATION SYSTEM This report introduces the management system which is designed to automate the entire operations of a college and in reducing time in activities using centralized data handling and paperless work with reduced manpower. This Desktop Application has […]<\/p>\n","protected":false},"author":49,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3790,3795,3798],"tags":[3786,3787,3788,3789,3791,3792,3793,3794,3796,3797,3799,3800],"class_list":["post-4522","post","type-post","status-publish","format-standard","hentry","category-college-automation-system-project","category-home-automation-using-arduino","category-home-automation-using-iot","tag-arduino-based-home-automation","tag-automatic-car-parking-system-using-arduino","tag-automation-system-project","tag-college-and-home-automation-system-project","tag-college-automation-system-project","tag-home-automation-system-project-using-iot-python-machine-learning","tag-home-automation-system-using-arduino","tag-home-automation-system-using-iot","tag-home-automation-using-arduino","tag-home-automation-using-iot","tag-home-automation-using-iot-ppt","tag-iot-based-home-automation-using-arduino"],"_links":{"self":[{"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/posts\/4522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/comments?post=4522"}],"version-history":[{"count":0,"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/posts\/4522\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/media?parent=4522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/categories?post=4522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.reilsolar.com\/drive\/wp-json\/wp\/v2\/tags?post=4522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}