Project
Report
On
TeleVision Shop
Submitted by
Mr. Ghodake Sagar Satyavan
Under the guidance of Prof.H.O.Tapase.
Faculty of MCA
In partial fulfillment for the award of the degree Of
MASTER OF COMPUTER APPLICATION
(MCA-II) Semester-IV 2018-2019
IN SCIENCE FACULTY AT
YSPM’s
Yashoda Technical Campus, Satara (YTC)
- Introduction
1.1 Existing System and Need for System
Existing System
The existing system is manual system of limitation like accuracy, expense, low speed and efficiency and unformatted outputs. In the existing system, all data processing is done manually. All the files and records are replaced by the software system. When there are a lot of issues such as retrieval and storage of the information and keeping track of them becomes a tedious task. By implementing a computerized system, the limitation in the present system will be reduced to a great extent and efficiency and accuracy can be increased to manifold. More over consumption of time can be reduced to far greater extend by the implementation of the proposed system.
We are developing website for existing system because there are some drawbacks of existing system to overcome those problems there is need of computerization.
Problems in Existing System:
There are following problems occurs in existing System.
- In existing system there are manual works, therefore, it is complex to save more data.
- In existing system there are data are store in register, so the number of files are increased. Therefore, sometimes unauthorized person are access that important data.
- When we have to saw any old record that time we have to saw all files, therefore, time in wastage.
- The work is done in such a way that whole system goes so complicated that there does not exists synchronization over all.
- In existing system customer can see more variety of product.
Need for System
- This is very useful for the purchasing Television of yours own choice.
- Easy and quick delivery.
1.2 Scope of Work
- In this system provide door to door service.
- In this system we also provide to buy more category of televisions easily also give the offers to customer.
- In this system multiple categories under single side.
- Place an order in any time.
1.3 Feasibility Study
The main objective of feasibility study is to test the Technical, Operational and Economical feasibility of developing a computer system.
The feasibility of any system may be viewed from the following three methods:
- Economic Feasibility :-
It is the measure of cost effectiveness of the system. At present the system can use one person to operate so the labor charge is reduced and other charges for the facility along with maintenance cost is reduced.
Our system is less costly. There is no restriction for use high level or specific printer for printing bills or records slips. This system can install any lower cost machines.
- Technical Feasibility :-
The website is user friendly interactive. User of the system should have known required web knowledge. They have to be technically trained before this system is implemented. But here is not special training required. This system is portable. Technical guarantees of accuracy, reliability, ease of access and data security is assured.
- Operational Feasibility :-
The system is user friendly hence any person in the organization can operate or use the system. The system can provide correctly timely information as required by the organizational personal.
1.4 Operating Environment – Hardware and Software
Software Requirements:
Operating System | Win 7/10 |
Front End | php |
Back End | MySQL |
Web Server | Xampp |
Hardware Requirements:
Processor | Intel(R) Core I3(R) 2.90GHz |
RAM | 2 GB |
Hard Disk | Minimum 100 GB |
Keyboard | Multimedia keyboard |
Mouse | Optical scroll mouse
|
|
|
1.4 Detail Description of Technology Used
PHP stands for Hypertext Pre-processor (no, the acronym doesn't follow the name). It's an open source, server-side, scripting language used for the development of web applications. By scripting language, we mean a program that is script-based (lines of code) written for the automation of tasks.
PHP can be embedded in HTML, and it's well suited for web development and the creation of dynamic web pages for web applications, e-commerce applications, and database applications. It's considered a friendly language with abilities to easily connect with MySQL, Oracle, and other databases.
The standard PHP interpreter, powered by the Zend Engine, is free software released under the PHP License. PHP has been widely ported and can be deployed on most web servers on almost every operating system and platform, free of charge.
Features of PHP –
- Portability
PHP is supported on multiple operating systems. This is for example the case of Microsoft Windows ™ versions as well as systems based on UNIX base (Apple Mac OS X ™, Linux or Sun Solaris). It will be very easy to move an application written in PHP an original Windows server to a Linux server without having to modify (or very little).
2. Execution
From a performance standpoint, PHP needs a Web server to run. All pages requested by a client will be built by the web server, depending on the parameters passed, before being returned to the client. The diagram below illustrates the principle of operation of PHP.
3. PHP Learning
PHP is a "high level" language whose syntax is very similar to the C language syntax. Nevertheless, the rapid control of its syntax does not mean control of its features and its concepts. A good knowledge and advanced use of PHP Programming requires a relatively long learning curve.
4. PHP language of wealth
One of PHP's strengths is its richness in terms of functionality. Indeed, it has at the origin of more than 3,000 native features ready-guaranteeing developers to overcome additional development time and sometimes tedious. These functions among others to treat strings, to operate mathematically on numbers, convert dates to connect to a database system, manipulate files present on the server.
5. PHP, a reliable and efficient language
The language has now become a reliable language, efficient and viable. It is capable of supporting sites that sollicent millions of daily requests. Many nationally and internationally renowned companies trust it for the development of their website. We can mention among them IBM, Le Monde, Le Figaro, Club-Internet, Orange, Yellow Pages ... A recent report shows that 87% of companies use PHP.
Advantages –
- Cross-Platform
PHP is, an application can be run on various platforms. The most important advantage of PHP is the developer need not have to worry about the operating system the user is working on. As the PHP code run properly and smoothly on all operating systems. Furthermore, the server-side scripting language or PHP hosting service providers can easily be found.
- Ease of use
Any individuals who are new to programming can easily learn to use them within a short duration of time. The syntax for programming in the hypertext pre-processor is quite similar to the C programming language. So the individual who is familiar with C can easily create PHP website scripts.
- Speed
A very vital side of web development is the speed. Considering the very important fact, some individuals still struggle with the challenge of web data speed. A quick loading website always appreciated by many individuals. Furthermore, individuals typically like quick loading web sites compared to slower loading ones. Folks use PHP because of the important fact that it’s quick.
Disadvantages -
- Weak type
By the way, the PHP pre-processor hypertext language was created; it’ll be tough to use it to program large applications. Since the programming language isn’t extremely modular, large applications created out of the programming language.
MySQL Server [Back End]
Ø MySQL is a database server. It is ideal for both small and large applications.
Ø MySQL supports standard SQL and compiles on a number of platforms it
is free to download and use.
Ø MySQL SQL is the standard query language for interacting with databases.
Ø MySQL is an open source, SQL database server that is more or less free and extremely fast.
Ø MySQL is also cross platform.
MySQL Database
MySQL is the world’s most popular open source database for cost-effectively delivering reliable, high performance and scalable e-commerce, online transaction processing, and embedded database applications. It is an integrated, transaction safe, ACID−compliant database with full commit, rollback, crash recovery, and row-level locking capabilities. MySQL delivers the ease of use, scalability, and high performance, as well as a full suite of database drivers and visual tools to help developers and DB As build and manage their MySQL applications. The MySQL Database provides the following features:
- High Performance Scalability to meet the demands of exponentially growing data loads and users.
- Self-healing Replication Clusters to improve scalability, performance and availability.
- Online Schema Changes to meet changing business requirements.
- Performance Schema for monitoring user application level performance and resource consumption.
MySQL: Features
- Speed
- Multi-threaded architecture
Multiple clients have concurrent access
- Query Cache
Cache the results of common queries
- Proposed System
The main motto of computerized television shopping system is to make the workflow flexible and to improve the services provided to the customers. The Television shop is part of a large entertainment service chain that provides desired entertainment items to the customers. The manager of this television shop is concerned about delivering on time for customer satisfaction. The first and foremost module is receiving order by the customer. For every new customer a unique id is given. All the details of the customers along with their unique id are maintained in a database .so the customer need not specify all his address details each time he places an order. All details of the customer and his order along with his specifications is received and saved. Price varies according to the customer’s specifications. The implementation of this system has completely changed the existing norm of people moving into shops to get their orders because of their busy routines. So this system is more comfortable in the present busy life. And also the timeliness and punctuality keeps the customers satisfied
2.1 Objectives of System –
The main aim to develop this system is to provide the good quick services. This system also provides all the Category Flavors Cakes to customer. Document needed for varies activities proper decision making.
Following are the some advantages of “TeleVision Shop”
- To develop the site that will be user friendly.
- To get appropriate services.
- To provide the information regarding Television.
- To save precious time.
- To remove drawback in manual working.
- To design database of different categories.
- To get desired accurate details.
- The balance of good knowledge.
- To get easy quick responses.
- Give some offer to customer.
- Online Users can place their orders by giving their details such as their contact address etc.
- There is a facility of adding new category subcategoty, new product and aslo maintain it.
2.2 User Requirement-
- Easy to maintain television system.
- To keep detail information and accurate record.
- Data can be easily accessed.
- Daily rates of system can be maintained.
- To provide product information.
- Provide all detail information about purchasing product.
- Also, provide service and purchasing details.
3. Analysis Design
3.1 Data Dictionary:
Table Name:-admin
Field Name | Description |
id (Primary) | Admin Id |
Username | Admin Username |
Password | Admin Password |
creationDate | Admin creationDate |
updationDate | Admin updationDate |
Table Name:-category
Field Name | Description |
id (Primary) | Category id |
categoryName | Category Name |
categoryDescription | Category Description |
creationDate | Creation Date |
Table Name:-Subcategory
Field Name | Description |
id (primary) | Subcategory id |
Categoryid | Category id |
Subcategory | Subcategory |
creationDate | Creation Date |
updationDate | Updation Date |
Table Name:-order
Field Name | Description |
id (primary) | Order id |
userId | User id |
productId | Product id |
Quantity | Product Quantity |
orderDate | Order Date |
paymentMethod | Payment Method |
orderStatus | Oerder Status |
Table Name:-productreviews
Field Name | Description |
id (primary) | Id |
productId | Product id |
quality | Product Quality |
price | Product Price |
value | Product value |
name | User Name |
summary | Summary |
review | Product Review |
reviewDate | Review Date |
Table Name:-products
Field Name | Description |
id (primary) | Product id |
Category | Product Category |
Subcategory | Subcategory |
productName | Product Name |
productCompany | Product Company |
productPrice | Product Price |
productPriceBeforeDiscount | Product price before discount |
productDescription | Product Description |
productImage1 | Product image 1 |
productImage2 | Product image 2 |
productImage3 | Product image 3 |
shippingCharge | Shipping Charges |
productAvailability | Product Availability |
postingDate | Posting Date |
updationDate | Updation Date |
Table Name:-Userlog
Field Name | Description |
id (primary) | User login id |
userEmail | User email |
userip | User ip |
loginTime | Login time |
Logout | Logout time |
status | Status |
Table Name:-User
Field Name | Description |
id (primary) | Id |
Name | User name |
User email | |
Contactno | User contact number |
Password | User password |
shippingAddress | Shipping Address |
shippingState | Shipping State |
shippingCity | Shipping City |
shippingPincode | Shipping Pincode |
billingAddress | Billing Address |
billingState | Billing State |
billingCity | Billing City |
billingPincode | Billing Pincode |
regDate | Registration Date |
updationDate | Updation Date |
3.2 Table Specifications (Design)
Table Name:-Admin
Column | Type | Null | Default | Constraint |
id (Primary) | int(11) | No | Primary | |
username | varchar(255) | No | ||
password | varchar(255) | No | ||
creationDate | timestamp | No | CURRENT_TIMESTAMP | |
updationDate | varchar(255) | No |
Table Name:-Category
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
categoryName | varchar(255) | Yes | NULL | |
categoryDescription | longtext | Yes | NULL | |
creationDate | timestamp | No | CURRENT_TIMESTAMP | |
updationDate | varchar(255) | Yes | NULL |
Table Name:-Order
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
userId | int(11) | Yes | NULL | Foreign |
productId | varchar(255) | Yes | NULL | Foreign |
Quantity | int(11) | Yes | NULL | |
orderDate | timestamp | No | CURRENT_TIMESTAMP | |
paymentMethod | varchar(50) | Yes | NULL | |
orderStatus | varchar(55) | Yes | NULL |
Table Name:-Order Track History
Column | Type | Null | Default | Constraint |
id (Primary) | int(11) | No | ||
Ordered | int(11) | Yes | NULL | Foreign |
Status | varchar(255) | Yes | NULL | |
Remark | mediumtext | Yes | NULL | |
postingDate | timestamp | No | CURRENT_TIMESTAMP |
Table Name:-Product Reviews
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
productId | int(11) | Yes | NULL | Foreign |
Quality | int(11) | Yes | NULL | |
Price | int(11) | Yes | NULL | |
Value | int(11) | Yes | NULL | |
Name | varchar(255) | Yes | NULL | |
summary | varchar(255) | Yes | NULL | |
Review | longtext | Yes | NULL | |
reviewDate | timestamp | No | CURRENT_TIMESTAMP |
Table Name:-Subcategory
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
categoryid | int(11) | Yes | NULL | Foreign |
subcategory | varchar(255) | Yes | NULL | |
creationDate | timestamp | Yes | CURRENT_TIMESTAMP | |
updationDate | varchar(255) | Yes | NULL |
Table Name:-Userlog
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
userEmail | varchar(255) | Yes | NULL | |
Userip | binary(16) | Yes | NULL | |
loginTime | timestamp | Yes | CURRENT_TIMESTAMP | |
Logout | varchar(255) | Yes | NULL | |
Status | int(11) | Yes | NULL |
Table Name:-Product
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
Category | int(11) | No | ||
subcategory | int(11) | Yes | NULL | |
productName | varchar(255) | Yes | NULL | |
productCompany | varchar(255) | Yes | NULL | |
productPrice | int(11) | Yes | NULL | |
productPriceBeforeDiscount | int(11) | Yes | NULL | |
productDescription | longtext | Yes | NULL | |
productImage1 | varchar(255) | Yes | NULL | |
productImage2 | varchar(255) | Yes | NULL | |
productImage3 | varchar(255) | Yes | NULL | |
shippingCharge | int(11) | Yes | NULL | |
productAvailability | varchar(255) | Yes | NULL | |
postingDate | timestamp | Yes | CURRENT_TIMESTAMP | |
updationDate | varchar(255) | Yes | NULL |
Table Name:-Userlog
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
userEmail | varchar(255) | Yes | NULL | |
Userip | binary(16) | Yes | NULL | |
loginTime | timestamp | Yes | CURRENT_TIMESTAMP | |
Logout | varchar(255) | Yes | NULL | |
Status | int(11) | Yes | NULL |
Table Name:-Wishlist
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
userId | int(11) | Yes | NULL | Foreign |
productId | int(11) | Yes | NULL | Foreign |
postingDate | timestamp | No | CURRENT_TIMESTAMP |
Table Name:-User
Column | Type | Null | Default | Constraint |
id | int(11) | No | Primary | |
name | varchar(255) | Yes | NULL | |
varchar(255) | Yes | NULL | ||
contactno | bigint(11) | Yes | NULL | |
password | varchar(255) | Yes | NULL | |
shippingAddress | longtext | Yes | NULL | |
shippingState | varchar(255) | Yes | NULL | |
shippingCity | varchar(255) | Yes | NULL | |
shippingPincode | int(11) | Yes | NULL | |
billingAddress | longtext | Yes | NULL | |
billingState | varchar(255) | Yes | NULL | |
billingCity | varchar(255) | Yes | NULL | |
billingPincode | int(11) | Yes | NULL | |
regDate | timestamp | No | CURRENT_TIMESTAMP | |
updationDate | varchar(255) | Yes | NULL |
3.3 Menu Tree (Web Site Map):
(User Menu Tree)
(Admin Menu Tree)
3.4 System Design
Data Flow Diagram (Context Level diagram)
Data Flow Diagram (Admin -1 Level Diagram)
Data