skushagra / sql

SQL Applications and Database management

SQL Applications and Database Management

Liabray Management

Liabray Management aims at managing books and students at the same time.

Registered members can add and delete students, books. Also issue and accept books. The application is password protected, a six digit number is generated randomly and sent to a registered email for the application.

Upon login the admin can exxecute the following commands :

  - See available books.
  - See registered students.
  - Issue Book.
  - Accept book.
  - Add Book.
  - Remove Book.
  - Add Student.
  - Remove Student.
  - Search Student
  - Exit

The application is also packed with full power SQL terminal which can run all SQL commands. The changes however for safety reasons are not comitted until exit. The function og the above mention commands is similar to what they are named. The application is terminal based and is equiped with features which can cause major security and logical errors.

Live Class Atendance

The application is designed to accept and keep record of atudents attending a class.

This application is more like an idea of how GUI based live class applications can keep a record of students attending the class. A teacher creates a class using the live_class.py application which gives generates a six digit OTP and a Unique Attendance Register(UAR). The UAR and the OTP is shared with student whic logins to the live_class_student.py application and if correct authentication is provided the student is logged in successfully.

The student submits his/her email and their time of attendance is calculated henceforth. When the student wishes to exit or the class ends, the student is asked for the OTP again. If the final verification is successful the student successfully exits the class and the leave time is recorded. The duration for which the student attended the class is calculated and (by default) if it is more than 75% of the duration of the class the student is marked present else absent. All data is stired and can be referenced in future until deleted manually.

Student is emailed the following information once he/she exits the class :

- Join Time Index : Number of seconds since epoch while joining
- Leave Time Index : Number of seconds since epoch while leaving
- Duration : Time student was in the class in seconds
- Percentage of class attended : (Duration/Duration of class)*100
- Attendance status : Present or Absent
- A short descripitive text

Here is a sample of the email sent :

Banking System

This application is designed create a banking system, in which a user can create a account. The user is alloted a card number and a pin. The Card number is verified and checked as per the credit card security checks. The user can log in inot his/her account, upon log in the user can do the following --

- Check Balance
- Add money
- Do transfer
- Close account
- Log account
- Exit

The funcion of each is similar to what their name suggests.