Basic MySQL Command-line Operations Project

Abstract:

“Basic MySQL Command line Operations” is an application developed in using MYSQL.This application has the only module which plays a key role which is an admin

Admin can get logged into the application by entering valid credentials.ADmin can add all the details of the employee like employee name, id, salary, email,

address, mobile no.Admin can update and delete all employee details.

In MYSQL command prompt we need to enter MySQL password to get access.Create a database by entering the database name.

After creating the database we can execute the query.We need to create employee table.After creating Employee table all the details of the table can be

inserted into the table.We can update all the details in the employee table by using an update query.: We can delete the details in the employee table by using delete query.

Modules:

admin:

* Admin login with valid username and password

* Admin can add employee details like employee name, id, salary, email, address, mobile no.

* Admin can update and delete all employee details.

Output Screens with Explanation:

Fig: enter mysql password: To Connect Mysql(Database) here user need to enter password, which we enter at the time of installation.

Fig: create Database : Here we need to create database using SQL Query

Fig: execute query: After executing the given query database will be created

Fig: create employee table: Here we will create a table by giving all the required column names using data types and length with a specific table name.

Fig: insert Employee Details: After creating Employee table all the details of the table can be inserted into the table

Fig: Update employee details: We can update all the details in the employee table by using update query.

Fig: Delete Employee Details: We can delete the details in the employee table by using delete query.

 

Course Recommendation through Online (CRO) Android App

Abstract:

  • Through this application, we can choose our desired course from anywhere and anytime around the globe.
  • In order to use this application, initially user need to register to this application and later give their opinion about their subjects.
  • This project proposes feasible predictions for student’s course selection based on choice.
  • By choosing the course through online it gives the complete information about how many students are interested in a subject and it gives an idea about the total ratio of students interest in that particular subject.
  • The module is a computer-assisted program for career decision making on the based on their interest.


Introduction:

  • Nowadays, there are many open course learning systems available in the universities which would interest the students.
  • Course Recommendation enables the system to better help the students and their learning process.
  • A recommendation system is a piece of software that helps users to identify the most interesting and relevant learning items from a large number of items.

Existing System:

  • One of the main problems faced by students is to create and manage the semester course plan.
  • We see that the students are not given the correct choice of course for their semester.

Proposed System

  • Course Recommendation enables the system to better help the students in their learning process.
  • This system emulates the traditional E-learning system study environment with more preference given to the individuals and their opinions.
  • The main functions of recommendation systems include analyzing user data and extracting useful information for further predictions.
  • The user enters their choice considering their skill on a range of areas or domains and then will be recommended which course to take for the semester.
  • The information is shown statistically i.e., in the form of graphs and pie charts.

Software Requirements

Programming Languages and Environment

  • Android Studio
  • Eclipse
  • MySQL

Architecture Diagram:

Modules:

  • Students information fetching module.
  • Course selection module.
  • Results calculating module.

UML Diagrams

 

Automated Retail Management System Synopsis

OBJECTIVE:

The main aim of developing this automation retail management system is to bring the customers into the store and fulfill their buying needs.

In simpler words, automated retail management software application helps customers to shop and retailers to do business without any difficulty.

EXISTING SYSTEM

  • Existing Retail Management System is Totally Manual.
  • Calculate the stock manually.
  • Due to manually process, it requires more time for completion of any work.
  • Existing system is manual, so it increases the chance of error.
  • Immediate responses to the queries are difficulty and time consuming.

PROPOSED SYSTEM

  • This Retail Management System is fully computerize.
  • We can store the information of each product.
  • We can calculate the stock computerize system.
  • We can generate various reports like purchase, sales and stock.
  • Save expensive.

Stock Management System Android App Synopsis

 INTRODUCTION:

  • Stock Management System is software which is helpful for the businesses operate stores, where store owner keeps the records of purchase.
  • This project eliminates the paperwork, human faults, manual delay and speed up the process.
  • Stock Management System will have the ability to track overall worth and available stock.
  • This is simple, fast and intelligent Stock management that can be used by anyone who has a smartphone.

EXISTING SYSTEM:

  • Manual calculation of stock present in any store is time-consuming and very risky.
  • The workers cannot maintain the store when there is no owner as they do not know the prices.

PROPOSED SYSTEM:

The proposed system is an Android application, it is better than existing system because of following reasons:

  • Easily accessible by anyone.
  • Overall worth of stock, products worth can be viewed by owner.
  • Prices of stock present in the store can be seen so that worker can also manage the stock without the presence of the owner.
  • It doesn’t require manpower, so it is not expensive.

ADVANTAGES:

This Stock Management System project will be a great help for the stores because it is a great difficult task that to manage stock and calculating the worth. He can also manage the stock by doing operations(add, remove) so that the person will be notified when to get the new stock into the store.

APPLICATIONS:

“Stock Management System” can be used in small stores for keeping track of stock easily and save the time.

Online CD Store Project Synopsis

Abstract:

This application will be a web UI allowing customers to buy or rent CD’s that are available online. This application will have CD’s for sale and also for rent. Customers will register and buy CD by adding them to the kart. They can rent CD’s by requesting for the same and can use membership plans related to rent offers. We will provide a logical search engine which will show related CD’s as per interests and usually rented or ordered CD’s.

This application will have different vendors too who can add their CD or DVD or any related products. They can sell it via our application.  Registered vendors can add products and sell them online.

User Types: Admin, Employee , Customer and Vendor

Modules:

1. Admin Module
2. Kart Module
3. User Module
4. Vendor module
5. Order management
6. The about us and Contact us pages
7. Products module

Admin: Will be able to add all base information, create CD category types. Will then add subcategory types to it. Admin will approve vendors who will send a request to register and then they can add their products. Vendors can sell products that are allowed by admin (as per categories added by admin).  Admin can view all orders in a day, deliveries in a day and update delivery status for any order. Admin can deactivate any vendor login in case of issues. Admin will also be able to add products which will be sold online in kart.  Registered employees login are also managed by admin, he can deactivate any employee logins. Admin will basically manage the admin panel which will allow saving all data related to products that are for sale online in the application.  He can view and manage all registered vendors and users. He can view and manage all products are being sold and also manage the stock of products. For products related to vendors, stock info will be updated by vendors itself.

Kart: This module will allow registered customers to add products to kart and then order them. It will basically be used to handle all products that are to be handled initially and also apply coupons or discounts if any.

User module: It will allow customers to register and login to the application. They will be allowed to search or browse through various products. Select products and add them to kart before confirming the order. They will have My orders option which will show the history of orders for a logged in customer (taken care in order management module for customers).

Vendor module: It will allow vendors to register and add their products that will be sold online in the web application Online CD store. The registration will be first approved by admin and then products can be uploaded with all info. They will upload Product name, images relevant, pricing, stock or quantity to be sold, delivery timeframe, contact number, email id, office address, warehouse address etc.

Order management: This module will handle all orders for all customers if viewed from admin side. It will show orders specifically for a customer if he or she is logged in. It will be linked to admin panel backend and provides a secured management of orders placed by customers. It will allow admin to update delivery status once all products related to a order is delivered. In case of logged in customers, it will show the history of orders and status of delivery in the same grid.

Products module: This basically is the admin panel backend which stores all related data for a product that has to be sold via this application. It will save each and every information related to a product. Category type, subcategory type, product name, product type, quantity, images, cost, color, description, features etc. It is accessible only to admin/employees or vendors.

Future Enhancements:

We can introduce wallet system to handle points as per orders and then provide discounts.
We can plan payment gateway integration.
We can introduce feature of holding a product in cart for n number of days and then dissolve it.
Provide feature where sms alerts are sent for confirmation of order, delivery confirmation etc along with email notifications.
Price comparison features for a product with other similar web sites providing same products.

System Requirement Specification: 

Hardware Requirements:
Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Software Requirements:

Technology: HTML,CSS, Jquery, PHP

Back End: SQLServer or Mysql

Operating System: Windows7 and more

Frame Work: Larvel or Phalcon

Or it can also be done in .Net

OPERATING PLATFORM:           WINDOWS 7 or later
Database:           SQLSERVER 2008 or  more
IDE & Tools:           VStudio.Net 2010 or more
Web Server:           IIS 6.0
Web Technologies:           Asp. Net, C#, Javascript, HTML, CSS