Trip Planning and Booking System C#.Net Project

The main purpose of this project is to design a user-friendly, rich look application which serves for booking and planning their holiday trip…

This project consists of 2 modules

  1. Admin Module.
  2. User Module.

We will discuss the technical functions of each module in detail

  • Admin Module:

The role of the admin is to maintain the entire site data. Like adding primary information accepting the user booking. The total functionalities in the admin module are…

  • Add Country
  • Add City
  • Add Hotels
  • Adding Photos to Cities
  • Adding videos to Cities
  • Accepting the booking

In this project, we use web services for interacting with the database because using flex we cannot directly access the database… Here we will discuss each form’s functionalities.

  • Add Country:

In this functionality, the admin is adding different countries to the database. Here we are using the “InsertCountry” Method in the web service. Using this method in the web service we are accessing the stored procedure in database names “SP_InsertCountryDetails”. This is taking two values as parameters those are “Cname” and “Description”. Which are there inserted into the “Tbl_Country” table in the database.

  • Add City:

In this functionality, the admin is adding different city names with respect to a particular country name. Here we are using the “get the country” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country” and we are displaying it in the combo box in the flex design. Their admin will select any country name and he will enter a city in the textbox given in the form. When admin clicks on the entering button it will pass those values to “InsertCity” which is there in web service taking 3 parameters and we are storing it in the database using a stored procedure with the name “SP_CityDetails”.

  • Add Hotels:

In this functionality, the admin is adding particular hotel details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from the “get the country” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will enter the hotel details which then call a method in the web service called “InsertHotels” with all the parameters provided by the admin and it will store all the details in the database using the stored procedure “SP_HotelDetails”.

  • Adding photos:

In this functionality, the admin is adding particular Photo details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from “get country” Method in the web service to access all the country names from the database which is stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will select the photos from the local disk and add them to the application. Then it will call the method in the web service called the “InsertImgNames” method where we are writing the insert command to store information in the “Tbl_PhotoDetails” table also we are storing the image in the Photos directory in the web service application folder.

  • Adding videos:

In this functionality, the admin is adding particular video details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from “getcountry” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will browse the video from the local disk and add it to the flex application. Then we are calling a web service method “insertVideoNames” for storing the details in the table “Tbl_VideoDetails” which is there in the database. Here we are storing the name in the database and adding that video to the local directory of the web service.

Note: our application only accepts “FLV” format videos that are of size less than 20MB.

  • Accept Booking:

Here admin is accepting the booking from the user on the basis of the availability of the rooms and other information. For this, we are getting all the booking details that are waiting for admin approval from a method called “CheckStatus” where we are getting all the details from the table “Tbl_Payment” which are having the status as false. And also we are getting other information like user personal details from other tables like “Tbl_UserDetails” and we are storing it in a custom dataset. And I am returning it to the flex as an XML string document. Where I am filling those details in “CheckBoxDataGrid”.  Here admin selects any particular details in the check box which is generated individually for each row. After selecting those rows when the admin click Submit button admin will send all those user details to a particular method called “SendMail” in the web service which will make that record status true in the table “Tbl_Payment” and send a mail to that particular user mail ID as a confirmation mail.

 The above-mentioned functionalities are Admin which provides basic information for the site and accepts the booking and sends mails to the user. Here below given are the functionalities for the user module. Where the user can perform several operations on the application those are….

  • User Module:

Here the functionalities for users are…

  • Login
  • Select places
  • View photos
  • View video
  • Make booking

We will discuss all the functionalities in detail…

  • Login:

Here every user has their own credentials using those credentials only they have to access the site to check those credentials we are using one web method called “LoginUser” here we are accessing the stored procedure “SP_LoginUser” for checking the credentials. If those usernames and passwords are correct then it will return a message called “true” otherwise “false”. If it is true user will redirect to the Home page to access other functionalities.

  • Select Places:

In this functionality, if the user wants to make a booking first he needs to select the particular place in which he wants to book the hotel. For that purpose, we are taking one form called “SelectPlaces” in which we are placing two combo boxes. The first one represents the country names and the second will represent city names. For that purpose, he is getting all the country details from “getcountry” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form.. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. Whenever the user selects both country and city then after pressing on the next button it will redirect to the page where the user will get 3 options like

  • Make Booking
  • View photos
  • View videos
  • View photos:

Here user will get all the photos with respect to the user selection of countries and cities. Here we are using the one web method for retrieving all the image details i.e., “GetPhotoNames” it will return all the photo’s names and paths and there we are giving that details to the photo viewer control in flex.

  • View videos:

Here user will get videos if any with respect to that place based on the country and city names selected in the select city page by the user. For that purpose, we are calling one method in the web service called “GetVideoPath” in the web service with respect to the city Id selected in the front end. In that, we are retrieving the details of the video name and path for that particular city and giving it as a source for the video controller in the flex path.

  • Make Booking:

If the user wants to book a hotel in a particular city then the user clicks on the Booking link. Then the page will redirect to a page where the user has to enter “from date” to “to date” and has to enter the number of adults and number of children when the user clicks on next the page will redirect to the booking page with all this information their user will get all the information of hotel details in that particular place. To fill this grid we are calling “GetHotels” and we will all the hotel details with respect to that city Id and it will display it on the grid. The user will enter a particular hotel id in the form. When a user clicks on the book button then we will call a method called “Payment” in the web service. All the details will be stored in the database using a stored procedure called “SP_Payment” and the booking will be waiting for admin confirmation. Once the admin confirms the user booking user will get a mail regarding the details of the booking.

Download the Complete Project on Trip Planning and Booking System C#.Net Project

Vehicle Management System Project using Python and SQLite

 

The complete development of this Vehicle Management System project using Django as the backend and sqlite3 as the database. This Python project has main sections Login/Signup, Dashboard, Vehicle, Driver, Booking, Repair, and Report which are explained in the coming slides in detail.

Functions Below:

Login/Signup

Users can signup/log in to the portal with this page. It takes in the necessary fields required for the user details

Dashboard

This is the dashboard in which you can view your details is shown and the user can edit the details.

Driver

Driver Section has two pages, one is to add a driver and the other is to view the list of drivers available. This section is only visible to the users which have admin access. The Driver list has the features to search and sort lists according to the fields.

Vehicles

In this section there are two pages one is to add vehicles and the other is to list the vehicles owned by the user. On the vehicle list page, the user can view individual details, edit the details and delete the vehicle.

Booking

The booking section has four pages one is the form to book a trip the second one is the success page where the booking details including the distance, cost, and duration are displayed using google maps API. On the success page, you have the option to pay which will take you to the payment page.

The payment page lets you enter the card details to pay. There is a page to display all the bookings made by the user wherein the user can search for the bookings. The admin will have another option which is to confirm the booking and a driver will be allotted and a mail will be sent to the user saying the mail is confirmed. The map option in the booking list page displays the route using google maps API. When the admin confirms the booking a confirmation mail will be sent to the user.

Repair

The repair section has two pages, one for reporting the issue and another page to show the issues made by the user. On the issues page, the admin has an option to solve the issue made by all the users.

Report

Each user can have a report of the trips that he has made. There is an option to mail the user the report for further use. Demo Here is the live demo of our project. The quality of the gif is a bit low.

Database tables:

Vehicle Table

Owner
Cost per KM
Price
Registration Plate
Vehicle Status
Insurance Status
Total KM traveled
Fuel Type
Mileage
Vehicle Type
Image

Report Table

Registered Date
Registered User
Vehicle Mileage
Issue

Driver Table

First Name
Last Name
National ID
Address
Email
Phone Number
License Category

BookingTable

Source
Destination
Distance
Booking Date
Start Date
End Date
Security Deposit
Allotted User
Allotted Driver
Vehicle
Cost
Duration

StellarStudent College Student and Faculty Communication Project

StellarStudent is a web application that deals with students and faculty. Ever since digitalization started in the country, schools and colleges want the best way possible to share information with their students. Some colleges use Google Drive or Whats app to share materials or collect other documents. However, the chance of data loss or misplacement is guaranteed. It is better for the college to have an admin who can look after all the happenings on the college website with just one click. With high security and validations of users, the chances of data misplacement are low with StellarStudent.

This Student and Faculty Communication project aims to connect the students with their faculty with no miscommunication. It is a web-established web-based application that involves faculty uploading study materials and notices like events and placement drives, viewing certifications, and quiz results of students. Students can also communicate with each other via the exchange of images, feedback, and discussion. This application can be handled by the admin and manage students as well as faculty.

Objective 

The StellarStudent is a web-based Student and Faculty Communication project for BVRIT-H students and faculty. The main objective of this project is to let college students interact with their faculties.  In this project, the faculties can upload materials, quizzes, etc. Even students can ask questions to faculties and can also upload the certificates. Our main goal is to ensure cost-effective, technical excellence, and secure apps.

Methodology 

To store the user data MYSQL has been used as a database. HTML and CSS have been used for front-end development. PHP is used as a server-side language, which is used to connect the front end to the back end. We can run this application in our browser.

Software requirements specifications

 Introduction:

Student and Faculty Communication SRS describes the requirements and specifications of StellarStudent, a web-based application for the college. 

Purpose:

The purpose of this document is to present a detailed description of StellarStudent.

Scope:

The project StellarStudent helps college students to interact with their faculties and many more. This web application can be accessed by students and faculty of BVRIT HYDERABAD College of Engineering for Women.

Overall description

The project StellarStudent is a web-based application with two interfaces: One is for students and another is for management. The website works on desktop computers, laptops, and mobile devices with the help of a browser.

Project Functions:

The project Student and Faculty Communication has the following product functions:

  • The web portal will provide the functionality to manage the system and the student
  • The website is secure because users must enter login details to access the
  • The system contains a huge For this reason, the search option has been provided on all report pages. The search results can be viewed in the list view.
  • The product works online with help of the internet

Assumptions and Dependencies

    • Internet connection
    • 24X7 uptime server connection
    • One assumption about the product is that it will always be used on mobile phones that have particular technical support.

Modular Decomposition of Components:

Dashboard Component

• Admin account
• Publish news
• Publish events
• Publish meeting schedule
• Add course records
• Add subject records
• Add certificate types

Faculty Component:

• Quiz materials
• Study materials
• Students record
• Faculty profile
• Certificates

Discussion Component:

• Post discussion forum
• Discussion reply
• View discussion forum

Quiz Component:

• Upload quiz question
• Attend quiz exam
• Quiz result

Study material Component:

• Upload notes
• View study materials

Certificate Component:

• Upload certificates
• View Certificates

Upload certificate by student Screen

View Uploaded Certificates

Order Management System for Steel Fabrication Factory Java Project

The web-based “Steel fabrication Order management system” project is an attempt to simulate the basic concepts of order management systems. The system enables the customer to do the things such as view all available products, and products by category-wise distribution. The user can place the order, the delivery agent will get the order details and it will be delivered to the customer at their residence. Users can request customized products with their own requirements and budget.

The Order Management System provides a facility that enables users to view details about products without logging in. But if the user wants to place the order, then it is required to log in first. Users can view all available products with detailed descriptions, reviews, and ratings. Users can choose a particular product. The system checks for the availability of the quantity of the product. If the product is available then the system allows the customer to select the product and place an order. To order a product the system asks the customer to enter his details such as first name, last name, city, street, landmark, state, pin, phone number, etc.

Scope 

  1. Order Management System for Steel Fabrication Factory is a web-based application that allows the admin to handle all the activities online quickly.
  2. So, the aim of the project is to provide products to customers. The customer can choose the products from the category and place the order. Users can request customized products to their own requirements and budget. Staff then can contact the user with the details provided by the user at the login time
  3. Staff will arrange the products as per the order and make them available for collection.
  4. Once the order is ready, the delivery agent will collect the products and they will be delivered to the customer at their residence

SYSTEM ANALYSIS AND DESIGN

System analysis is the performance management and documentation of activities late to the life cycle phase of any software namely:

  1. The Study Phase
  1. The Design Phase
  1. The Development Phase
  1. The Implementation Phase
  1. The Testing Phase

Software analysis starts with preliminary analysis and later switches to a detailed one. During the preliminary analysis, the Analyst took a quick look at what is needed and whether the cost benefits. Detailed analysis studies in depth all the cornered factor, which build and strengthens the software.

ER Diagram:

PROJECT FEATURES

Admin module

Admin is the main role in the overall system. Admin can log in into the system using credential where admin credential was already stored in the database.

After successful login into the admin dashboard, there are various operations that the admin can do mentioned below –

  1. View customer: Admin is able to view the list of customers who are already registered into the system. Customer data is stored in a database so the admin can fetch those data to view the list of customers
  2. Add remove staff: Admin can add staff by giving a particular role also admin is able to delete it from the system
  3. View feedback: Admin can view feedback which is given by customers on products after purchasing

Manager module

Like the admin, the manager can log in to the system with the credentials stored in the database. The manager carries out the most of operations on the owner’s side. The manager can perform the following functionalities mentioned below:

  • Manage products: The manager can add products into the system with all the necessary details. As the products are managed category-wise, the manager can add distinct categories first and then products under that specific category. Managers can also update products by changing the price of products or the available quantity of product
  • Manage delivery: The manager is able to see all the orders. After placing an order by the user, the manager assigns that order to the particular delivery That order is visible to that delivery agent’s dashboard with details.
  • View feedback: The manager can view feedback and ratings given by customers on products after purchasing. The manager can review and analyze the feedback
  • View order customization: The manager can review the customized orders that users have requested, and contact that specific user from the contact details given at the login time

User module

User can login into the system, or even without login users can see product lists, detailed descriptions of products, reviews, and ratings of products. Even without a login user can check all available products. But to place an order user needs to log in first to the system.

Registration and creation of user profile

The system shall require a user to register, in order to carry out the process to place an order. For registration it will ask the user for the following information first name, last name, city, street, landmark, state, pin, phone number, email, and password. The system will automatically generate the user’s profile.

Making Order

After registration user’s credential is saved in databases and using the credential user can log in to the system. For place an order user must do login first otherwise the system will not allow the user to place an order.

After login into the system successfully now the user is able to place an order. The first user needs to search for the available product or the user can search for a product by category, one more option is available the user can select a product and customize it according to their need.

If a user wants to place an order of multiple products, then the first user selects one item and moves it to the cart using the ‘add to cart button, after adding it to the cart now user can go for another product and the user can add multiple products to add.

After adding products to the cart, the cart dashboard will show all the products, product quantity, and total price. Now users can place orders by selecting a payment method.

View Order History: The system shall allow a user to view all information about his previous orders. In history, the system shows the previous product, delivery status, etc.

Delivery Agent

Account Delivery agent is another important role in this system. The main role of the delivery agent is to deliver the product to the mentioned address and update the status of delivery. The delivery agent has functionalities mentioned below:

  1. Receive order: The delivery agent received the order and does a job of delivering the product on time
  2. Track order: The tracking status of the product during delivery is updated by the delivery agent. Tracking status like ‘product arrives, ‘on the way, ‘delivered’, etc. Users get to see this status on his/her side
  3. Verify payment: The delivery agent needs to verify the payment details like whether payment is already done or needs to be collected at the time of delivery
  4. Update order status: After delivering the order successfully, the delivery agent needs to update the status as ‘delivered’.

Software Required for Development

Module 1: Database Design – MySQL-for database

Module 2: Front End – HTML, CSS, JavaScript, React js.

Module 3: Back End – Eclipse IDE(Any IDE), Spring tool suite, Tomcat

Download The Complete Project code, report, and PPT of the Order Management System for Steel Fabrication Factory Java & MySQL Project.

Payroll Management System C++ Project

OBJECTIVES

  • Manage Employee Information efficiently.
  • Define earnings, deductions, leave, etc.
  • Generate Pay-Slip at the convenience of a click.
  • Generate and Manage the Payroll according to the Salary Structure assigned to the employee.
  • Manage your own Security.

SYSTEM REQUIREMENTS

Software Requirements

Operating system:   Windows XP or Later versions of windows

IDE:    Dev C++

Hardware Requirements

Processor: Intel Pentium core or later versions

 Hard Disc: 120GB

RAM: 256 MB or More 

SYSTEM ARCHITECTURE

MODULES

Admin Login Module

Here in this module call, the user is prompted to enter the login credentials. The Login Module is a portal that allows users to type a username and password to log in. This module is no longer available to users after they have logged in. The Login Module appears to users next to the introduction module.

Data Entry Module

After you selected data entry from the main menu you land on this screen. In this module, the Data of the employee are inserted. The Fields required here are Name, Id of the employee, Designation, Age, Years of experience, No. of working hours,  Loan Status if any.

All the required data is processed and the salary, earnings, and deductions of the employee are calculated and finally stored in the files for permanent storage.

Storing and Retrieving Data Records Module

Records of all the employees are to be maintained and the records are stored in Files and the information is retrieved from the files. All the Records are separated by new lines, and each field of an individual record is separated by a ‘tab’. 

WORKING PROCEDURE

STEP 1

The main function is executed first and the control the followed by code.

The function ‘intro()’ got executed and the welcome message is displayed when the user proceeds to the next step by pressing any key.

STEP 2

The user is prompted with a login screen here and a user with valid credentials can have the access to the software.

STEP 3

 After the user with the valid credentials logs in, the data of previous employee records are retrieved.

STEP 4

After the user with the valid credentials logged in and successful retrieval, the user land on the home screen (the Main menu), and based on the choice of the user he lands on the requested screen.

STEP 5

After the job is done, all the modified or created data is stored in the files and the software is successfully exited.

FUTURE SCOPE

  • Continuous tracking of their activities within the company of every employee can be provided with their individual login credentials.
  • Auto updates of the details like bank loan updates can be provided.
  • Administration control over the software is to be improved.

Ex: Administration can able to add the employee credentials such that the employee can know their status and companies administration legally.

  • Databases can be used for easier and more efficient access.
  • The proposed system is capable of handling only 100 employee records and can be improved.

You can also visit & download the Java Application project on Payroll Management System

Online Shopping Store Website Project using C# and SQL

MY ONLINE SHOPPING STORE 

We have a physical shopping store, which is doing well in terms of revenue and margin. We want to increase the business by extending the availability of our products through online mechanisms. Quick time-to-market is the main criterion;

we are adding some features: 

  1. Home Page 
  2. Product Search facility 
  3. Product Detail Page 
  4. Add to Cart 
  5. Place Order

Use Case Diagram-Online Shopping Website:

The use case diagram is usually referred to as a behavior diagram used to describe the actions of all users in a system.

All users described in the use case are actors and the functionality is the action of the system.

The use case for an online  shopping website:

Specification of Use Cases:

Use Case                                      Home page

Home Page

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

Various Categories of the items are displayed

Post Conditions

On clicking each category, various sub-items are to be displayed

Normal course

1.      On hovering various categories are displayed

2.      On each Category, the subcategories are displayed

 

Use Case                      Search Product

Search Product

Element

Details

Actor

User

Trigger

On clicking the search bar for the item to be searched.

Pre Conditions

 Users can check the items they needed

Post Conditions

The various items of the searched product are displayed

Normal course

1.      User enters the Product name or product category

2.      The various items of the product are displayed

Use Case                                      GetAllProducts

GetAllProducts

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

The user needs to enter a product name

Post Conditions

The sub-list of all the items should be displayed.

Normal course

1.      The various products should be displayed varying in different perspectives

Use Case                                      GetProductDetails

Get Product Details

Element

Details

Actor

User

Trigger

On clicking a particular item the info about the product is to be displayed.

Pre Conditions

The user needs to enter the product name or category

Post Conditions

The total info regarding the product is to be displayed

Normal course

1.      User enters the Product name and then submits

2.      The fetching records will be displayed

Use Case                                      AddProduct

Add Product

Element

Details

Actor

Admin

Trigger

When the User Quantity is not available

Pre Conditions

 Checks whether the searched item is available in the inventory or not

Post Conditions

The user can search for the prescribed item

Normal course

1.      Admin checks in the inventory stock

2.      During the period of offers or when the inventory is not available to the users, he adds to the database.

Use Case                                      Delete Product

Delete Product

Element

Details

Actor

Admin

Trigger

When the offer period is completed

Pre Conditions

 Refactoring the product as per the daily market price

Post Conditions

The product is not available after the deletion.

Normal course

1.      Admin login using his credentials

2.      Search for the product to be deleted

3.      Deletes the particular products

Use Case                                      Edit Product

Edit Product

Element

Details

Actor

Admin

Trigger

When the product needs to be updated during the season sale

Pre Conditions

 The product may vary in its cost and delivery

Post Conditions

The product has been updated regarding the information

Normal course

1.      Admin logins using his credentials

2.      Updates the selected products in the inventory.

Use Case                                      Add To Cart

Add To Cart

Element

Details

Actor

User

Trigger

When a user needs to buy the item at a later point in time

Pre Conditions

 If the user likes a particular product he can choose to buy it by clicking the Add To Cart

   

Post Conditions

The selected items are available later until the selected product is available

Normal course

1.      User selects the particular product

2.      He then clicks on Add To Cart.

3.      The liked items are available for later usage

 Use Case                                     BuyNow

BuyNow

Element

Details

Actor

User

Trigger

With  authentication

Pre Conditions

The total amount should be displayed.

Post Conditions

On Clicking the order needs to be placed.

Normal course

1.      Click on Buy Now, select the items and then go to payment

2.      The order should be placed after payment.

Shopping cart System ER Diagram:

ER Diagram:

Flow Chart For Online Shopping system:

Database Table Design:

ProductCategory:

Field Name

Type

Remark

CategoryId

Int

PK

CategoryName

Nvarchar(50)

 

Products:

Field Name

Type

Remark

Id

int

PK

CategoryId

int

FK

Price

Float

 

Quantity

Int

 

Description

Nvarchar(Max)

 

Picture

Nchar(100)

 

CartItem: 

FieldName

Type

Remark

Id

Int

FK

Price

Float

 

Quantity

Int

 

 

DBMS Project on Student Management System

Student Management System is purely developed by using DBMS queries. The main functions involved to develop this project is developing ER diagram, DDL/DML, SQL constraints,  Retrieving data using the select function, Restrictions, and sorting functions,  Aggregate, and grouping, Single row function, Joins, and finally Subquery.

ER DIAGRAM OF STUDENT MANAGEMENT SYSTEM

DDL AND DML

1) Create a table name student and attribute of s_id, first last and middle name, address, email, city, and state.

2) Display the datatype of all attributes in the student table?

3) Insert values into the table student?

4) Change the datatype of s_id in the student table?

5) Update the city of s_id=001 to bby?

SQL CONSTRAINTS

1) Create a table name student with an attribute s_id that is not null?

2) Create a table name student with an attribute s_id that is unique?

3) Create a table name student with an attribute s_id which is a primary key?

4) Create a table name teacher with an attribute s_id which is a foreign key and team name?

5) Create a table name student and with an attributes city which a default constraints “KOLKATA”?

RETRIEVING DATA USING SELECT

1) Display all the columns of the table name course?

2) Display the columns c_name aliases course name of table name course?

3) Display the columns c_fee and c_name using concatenation and aliases course details of table name course?

4) Display the course fee and increase in course fee by 3000 where the course duration is 45_hr?

5) Remove the duplicate value from course duration with a student ID from the table name course?

RESTRICTIONS AND SORTING

1) Display the student ID and the first name from the table name student whose state is westbengal?

2) Display all the data of the table course whose course ID is ‘11’.

3) Display all the data of the table course whose course fee range is less than 100000?

4) Display the Lastname and city of the table student where the student’s first name starts with ‘a’ and consists of 4 characters?

5) Display the course fee of the table name course which is between 10000 to 50000?

AGGREGATE AND GROUPING

1) Display the average course fee for all the courses in the given table?

2) Display the minimum and maximum course fees in the given table?

3) Display the count number of course names from the table name course?

4) Display the total course fee in the table name course?

5) Display the student ID and minimum course fee from the course table and group by student ID having a course fee less than 102000 and sort the minimum course fee in descending order?

SINGLE ROW FUNCTION

1) Display the student ID and student first name and state from the student table where convert student first name and state into uppercase?

2) Display the student ID and student first name and state from the student table where convert student first name and state into lowercase?

3) Display the student ID and student state from table student and change the first character of all states to uppercase?

4) Display the student ID and student first name middle name last name together from the table student use the character-manipulation function?

5) Display the student ID and the length of the first name and the last name from the table student using the character-manipulation function.

JOINS

1) Display the registration number for the user’s table and the student’s first name on the table student use inner join?

2) Display the registration number for the user’s table and the student’s first name on the table student use left join and order by the first name.

3) Display the registration number for the user’s table and the student’s first name and last name from the table student use the right join and order by registration number.

4) Select all teachers and all courses in the given table using full join and order by teacher ID.

5) Select all students’ first names and last names and city in the given table using self-join and order by the city?

SUBQUERY

1) Display the first middle and last name of the student where the course fee is minimum?

2) Display the teacher ID and first middle and last name of the teacher where the course name is DBMS?

3) Display the phone number of the student of who’s registration number is 20?

4) Display the registration number who live in Jaipur?

5) Display teacher ID first name and phone number whose qualification is b.tech?

Online Learning Management System PHP Project

Objectives of the Project:-

The general objective of this Online Learning Management System project is to provide various courses to students as well as others who are interested in learning online. The use of the internet has increased and so the courses are available to be learned online. By providing this option, it would be easy for the users to learn by sitting in a comfortable place and learning based on the time they have.

The courses will be added, deleted, etc. by the admin. This project consists of the front end and back end sides. The front end side of the website is developed for the general public who are interested to know about us and to find out the courses provided by the management system. The back end is for the users who have created their accounts and admin utilities.

Scope of the Project:-

For this project, to store all the data various tables and attributes are required. As the main idea of this project is to provide courses for the students to enroll in and learn, it will also allow the instructors to teach courses. Thus the scope of this project is limited to the following tables: COURSES, USER DETAILS, STUDENTXREF, and INSTRUCTORXREF.

User requirements:-

Following would be the basic user requirements-

  1. Users should be able to view the Home page, About Us, and login/Register page of the website.
  2. Users should be able to search for the courses in which they are interested.
  3. Users will be asked to enter the user type as Student, or Instructor while creating the account.
  4. Users who have been marked as Students will be allowed to enroll in the available courses and will be displayed the courses in which they are already enrolled.
  5. Users marked as Instructors will be able to teach the course which is not taught by anyone else. They will be able to see the courses which are taught.
  6. Admin type of user will be able to add or delete courses as well as delete instructors from the courses.

*Note – User can be general public without creating an account, student, instructor, and admin.

Business Rules:-

Below are some basic business rules-

  1. One student can enroll in many courses.
  2. Every single course can be taken by many students.
  3. One instructor can teach many courses.
  4. One course will be taught by only one instructor.
  5. Users can be students or instructors based on the details entered while creating an account.

Entities and their attributes:

In this proposal, there are basically 4 entities. The description for each is given below-

USERDETAILS Entity –.When a student or instructor wants to enroll/teach for any course, first of all, they will have to create an account on the website by using the login page. All the details entered while creating an account will be stored in this table. This table will consist of the attributes as User id, user last name, user first name, user type (it can be student or instructor), and password. The primary key of this table will be the user id. Once the user has created an account, they will be able to know about the courses.

COURSE Entity – The course table will store all the details related to the courses which are offered. This table will have the following attributes Course id, Course name, course department, course description, course start date, and course end date. Course id will be the primary key for this table. Based on the above attributes, students can decide which course they are interested in. The instructors will also be able to know about the courses which are already taught by some other instructors and the courses available for them to teach.

STUDENTXREF Entity- This table will act as a reference table between the COURSE and USER DETAILS tables. The attributes of this table are student id, course id, and user id. The primary key of this table will be the student id.

INSTRUCTORXREF entity – This table is also a reference table between COURSE and USER DETAILS tables. If the user type is instructor then the details for that user id will be stored in this table. The attributes of this table are instructor id, user id, and course id. Instructor id will be the primary key for this table. Here the course id will be unique as 1 course cannot be taught by multiple instructors.

Entity-Relationship Diagram:-

Fig 1: Entity relationship diagram for Online Learning Management System.

Website Description:-

The online learning management system is a system that provides students to learn about various courses online. Various pages have been created for the users like Home Page, About Us page, Login/Register Page, and Search courses page.

The sitemap for the online Learning management system is as:

The project consists of the Front end and back end. The front-end pages are described below:

Home Page:

This page is the main page of the project. This page gives a brief description of the management system and also posts the latest courses which are going to be added in the future. This page will be linked to all other pages. Whenever the user is interested in learning any course, then they need to create an account by clicking on the Login/Register button provided on the navigation bar.

Login/Register Page:

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on the enroll/register for courses link in order to login into the account. Students who are already registered can put in their username and password to login to the account. In the case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password, and date of birth. The user has to make a selection of the account type either teacher or student from a drop-down menu. Then they can simply login into their account. 

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on enroll/register for courses link in order to login into the account.

Students who are already registered can put their username and password to login to the account. In case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password and date of birth. The user has to make a selection of the account type either teacher or student from a drop down menu. Then they can simply login into their account. 

About Us Page:

This page describes the goal of developing this project. This will make clear to the users what the purpose of developing this website is and how they can use it. Contact information is also provided for the users so that if they have any doubts, they can send an email with the query. 

1.6.4 Search course Page:

When a user is interested in learning any course, before creating an account he can check whether the course in which he is interested is provided by the management system or not. This search option will help them to know about the courses and then they can decide whether to enroll in those courses or not. While using the search option, users are not required to create an account.

The back end part will come into the picture when the user has created an account. Users can be students or instructors. While creating an account, the user will be asked to select the User type from the drop-down option. The pages at the backend side are described below:

Student Page:

This page (student.php) will be displayed to the user whose user type is Student. It will display the courses which are available for a particular student to enroll. He can select multiple courses for enrolling. Checkboxes are provided in front of all courses and then finally enroll button is provided.

Once the student selects any course and clicks on Enroll button, he will be shown a thank you message for enrolling in those courses. Student.php will call enroll.php when an enroll button is clicked by the student. The back button is provided on enroll.php which will re-direct the student to student.php. The student will also be displayed the courses in which he has already enrolled on student.php. 

Instructor Page:

When a user selects the user type as an instructor, he will be directed to instructor.php page. On this page, he will be displayed with the courses which he is already teaching. The instructor will be able to teach courses that are not being taught by any other instructor. A checkbox option will be provided to the instructor to select courses and then he can click on each button. This button will direct the instructor to teach.php page where he will be displayed a thank you message.

Admin Page:

Admin page is designed for the administrator to add and delete courses in the system. In order to login as an admin the user needs to select the admin-Add/Delete courses link from the Login/Register page. Two options appears in the admin page 1.Add a course and 2.Remove a course. Add a course lets the admin add new courses in the system.

The details the admin needs to provide in order to add a course are course name, course department, course description, course start date, and course end date. The admin can simply press the Add Class button. A success message appears on the page after the submission of the details. In order to remove a class the admin can make a selection from the drop-down menu and press the Delete Class button. The success message appears afterward.

Functions provided by the website are:

  1. The following are the functions provided by the online learning management system:
  2. Browse the homepage, and about us page.
  3. Search courses without creating an account.
  4. Interested users can create an account.
  5. Students can enroll in courses.
  6. The instructor can teach courses that are not being taught by any other instructor.
  7. Admin can add/delete courses.

Usability considerations:

The online management learning system website has logical navigation. Users can easily navigate around the webpage. The home page gives the users information about the whole system. All the contents are written in simple language. It has a user-friendly interface and functions well with no broken links. All the links and sub-links are clearly represented. The procedures to log in to the account, register for courses, and add or remove the courses from the system are very clear.

The system lets the users know if their attempts of adding courses or removing courses were successful. When the users put wrong credentials while logging in, it lets users know their attempt has failed because of the wrong username or password. So, that user can put the correct information and log in to the account. The website has all the required functions based on user types. That makes the website informative and user-centered. 

FUTURE ENHANCEMENTS:

  1. Based on the entries in the database, graphs can be created to provide information about the number of students in each course.
  2. A class entity can be added to provide more information about courses like classrooms, class timings, etc.
  3. Change the template to make it more attractive and user-friendly.
  4. Passwords can be stored in an encrypted way to avoid giving away personal information.

Online Job Portal using Cloud Tech Stack

Topic Name: Online Job Portal

Objective

The online job portal system is between job seekers and job providers (companies). The Job seeker can easily find and apply for a job by login into the system. The Employer or company can quickly get an expert employee from our job portal site by posting a job.

Create a web application for a company that job seekers will use to apply to the job requirements.

We will create a front end where users will view jobs.

There will be a login page that also has register functionality.

The user will be taken to the home page after login, where they can view different jobs.

Modules

  1. Job seeker/Employee
  • able to view register/login
  • Search jobs
  1. Employer-
  • Users- view all registered users
  • Jobs – add jobs based on category
  • Delete jobs
  • Edit jobs
  • View jobs

Cloud Tech Stack

AWS Elastic Beanstalk

AWS Aurora

AWS S3

AWS Cloud Watch

Covid-19 Testing Management System Python Project

Covid-19 Testing Management System is a small project developed using Python programming. Here are the application features below.

Project features:

• Adding new testing centers
• Search for available testing centers by locality
• Update and delete testing centers
• Show all testing centers by city, state
• Shows the number and type of testing kits available at each center.

Software to be used to develop this application:

• Python
• SQL for creating a database
• Library to interface between Python and SQL
• Either Django (to create a web app) or a GUI library to create the UI (not decided yet)

Implementation

1. Login page (This has a simple login prompt designed using a GUI library that asks for the user id and password.)
2. Menu:
a. Add a testing center
B. Delete testing center
C. Edit the number of testing kits available
D. Search for the testing center by district/city/state
E. Show all testing centers
3. Separate sections for:
a. Adding a new center
b. Deleting center
c. Updating center information
d. Searching for center
e. Nationwide data

Covid-19 Testing Management System can be developed by using PHP & MySQL Server with different functionalities below.

User Characteristics

The Covid 19 Testing Management system has 2 types of users they are Admin and user(patient)

General Constraints

The tools and technologies that are used to develop this project are:
The language used in this project is PHP5.6 and PHP7.x.
The database used in this project is MySQL 5.x.
The web browsers that are used in this project are Mozilla, Google Chrome, IE8, and OPERA.

Operational Scenarios

Scenario A:
How your application starts
Our application covid19 testing management system starts by login into the application, if the user is a new user, the user needs to register by providing the needed credentials.
New users need to provide testing information. A registered user needs to provide test information.

Scenario B:
Usage Scenarios like Customer Check-out
When a customer visits our application, he/she needs to log in by providing their credentials according to their role i.e., admin and user.
If the user is new, he needs to register if he is an old user, he can directly enter the login details and login directly.

Scenario C:
Database

The data that we are going to store in the database
1) Admin Login
Username
Password

2) New admin login
Admin name
Username
Password

3) User login
Username
Password

4) New user login
Name
Phone number
Username
Password

5) User Registration
Name
Current address
Gender
D.O.B
E-mail id
Phone number
Age
Aadhar card number