B.

Voc Software Development 2023-2026 Urbanea Furniture

INTRODUCTION

St. Mary’sCollege,Thrissur Page2

B.Voc Software Development 2023-2026 Urbanea Furniture

1. INTRODUCTION
1.1 About the project:

The project titled “MEDICARE” is part of the second semester. This is a mini
project undertaken by B.Voc Software Development students, where our group has
chosen to develop a website for a furniture store.

In today's digital age, a strong online presence is crucial for retail businesses
to thrive. To meet this demand, we are developing a website for a Hospital that will
enhance the user about hospital experience and simplify management for the
administrators. The website will feature an extensive product catalog, displaying,
along with an interactive Hospital details. It will also include user accounts for
personalized visiting experiences and an administrative panel for efficient product and
appointment

The MEDICARE website is about ”With Medicare, users can effortlessly

search for doctors, book appointments, and access their medical history, all in one
place.”

St. Mary’sCollege,Thrissur Page3

B.Voc Software Development 2023-2026 Urbanea Furniture

REQUIREMENT
SPECIFICATION

St. Mary’sCollege,Thrissur Page4

B.Voc Software Development 2023-2026 Urbanea Furniture

2.1 SOFTWARE REQUIREMENT SPECIFICATION

Computer and information technology has a major influence on the society and the
society is becoming more and more dependent on technology. Going on is an era of
simplifying almost all complicated works using computers. The last few years have
witnessed a tremendous increase in the capabilities and use of computers. Manual
processing makes the process slow and the other problems such as inconsistency and
ambiguity on operations. The proposed system intends user-friendly operations which
may resolve ambiguity. By considering all this factors, the applications produced,
which performs the social service simply and effectively.

2.2 SYSTEM REQUIREMENT SPECIFICATION

2.2.1 HARDWARE SPECIFICATION

Machine : ASUS
Processor : Intel(R) Core(TM) i3-6100U CPU @2.30GHz
RAM : 4GB

2.2.2 SOFTWARE SPECIFICATION

Front-End :HTML,CSS,JS
Back-End : MySQL, PHP
Designing tools : WAMP

2.2.3 SERVER SPECIFICATION

Localhost

St. Mary’sCollege,Thrissur Page5

B.Voc Software Development 2023-2026 Urbanea Furniture
2.3 FEATURES OF SOFTWARE

2.3.1 FEATURES OF PHP

PHP is an open-source, interpreted, and object-oriented scripting language that can be
executed at the server-side. PHP is well suited for web development. Therefore, it is
used to develop web applications (an application that executes on the server and
generates the dynamic page).

1. Performance
2. Open Source
3. Case Sensitive
4. Embedded
5. Platform Independent
6. Database Support
7. Error Reporting
8. Loosely Typed Language

Performance
PHP script is executed much faster than those scripts which are written in other
languages such as JSP and ASP. PHP uses its own memory, so the server workload and
loading time is automatically reduced, which results in faster processing speed and
better performance.

Open Source

PHP source code and software are freely available on the web. You can develop all the
versions of PHP according to your requirement without paying any cost. All its
components are free to download and use.

Case Sensitive
PHP is case sensitive scripting language at time of variable declaration. In PHP, all
keywords (e.g. if, else, while, echo, etc.), classes, functions, and user-defined functions
are NOT case-sensitive.

St. Mary’sCollege,Thrissur Page6

B.Voc Software Development 2023-2026 Urbanea Furniture
Embedded
PHP code can be easily embedded within HTML tags and script.

Platform Independent

PHP is available for WINDOWS, MAC, LINUX& UNIX operating system. A PHP
application developed in one OS can be easily executed in other OS also .

Database Support
PHP is available for WINDOWS, MAC, LINUX& UNIX operating system. A PHP
application developed in one OS can be easily executed in other OS also.

Error Reporting
PHP has predefined error reporting constants to generate an error notice or warning at
runtime. E.g., E_ERROR, E_WARNING, E_STRICT, E_PARSE.

Loosely Typed Language

PHP supports variable usage without declaring its data type. It will be taken at the time
of the execution based on the type of data it has on its value.

2.3.2 FEATURES OF MYSQL

MySQL is a freely available open-source Relational Database Management System

(RDBMS) that uses Structured Query Language (SQL). SQL is the most
popularlanguage for adding, accessing and managing content in a database. It is most
noted for its quick processing, proven reliability, ease and flexibility of use.

MySQL supports as its database language – as its name suggests – SQL (Structured
Query Language). SQL is a standardized language for querying and updating data and
for the administration of a database.

Stored procedures: Here we are dealing with SQL code that is stored in the database
system. Stored procedures (SPs for short) are generally used to simplify certain steps,
St. Mary’sCollege,Thrissur Page7
B.Voc Software Development 2023-2026 Urbanea Furniture
such as inserting or deleting a data record. For client programmers this has the
advantages that they do not have to process the tables directly, but can rely on SPs.
Like views, SPs help in the administration of large database projects. SPs can also
increase efficiency. MySQL has supported SPs since version 5.0.

Triggers: Triggers are SQL commandsthat are automatically executed by the sever in
certain database operations (INSERT, UPDATE AND DELETE). MySQL has
supported triggers in animatedform from version 5.0, and additional functionality is
promised for version5.1.
• Unicode: MySQL has supported all conceivable character sets since version 4.1,
including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2).
• User interface: There are a number of convenient user interfaces for administering a
MySQL server.
• Full-text search: Full-text search simplifies and accelerates the search for words that
are located within a text field. If you employ MySQL for sorting text (such as in an
Internet discussion group), you can use full-text search to implement simply an
efficient search function.
• Replication: Replication allows the contents of a database to be copied (replicated)
on to a number of computers. In practice, this is done for two reasons: to increase
protection against system failure (so that if one computer goes down, another can be
put into service) and to improve the speed of database queries.
• Transactions: In the context of a database system, a transaction means the execution
of several database operations as a block. The database ensures that either all of the
operations are correctly executed or none of them. This holds even if in the middle of
a transaction there is a power
failure, the computer crashes, or some other disaster occurs. MySQL has supported
transactions for a long time. One should note here that MySQL.

St. Mary’sCollege,Thrissur Page8

B.Voc Software Development 2023-2026 Urbanea Furniture
SYSTEM STUDY AND ANALYSIS

3. SYSTEM STUDY AND ANALYSIS

System analysis is a detailed study of various operation performed by a system and
the relationship within and outside of the system. One aspect of analysis is defining
the boundaries of a system and determining whether or not a candidate system should
consider other related system. Analysis begins when a user begins a study of the
programs using an existing system. System analysis is an application of system
approach to the problem solvingusing,computers.
During analysis data is collected on the various files, decision points and
transactions handled by the present systems. This means that to do system works, one
is to understand the system concepts and how the organizations operate as a system
and the design appropriate computer-based system and that will make the organization
requirements. It is actually customized approach to the use of computer problem
solving.
In brief analysis of the system is mainly to make a clear view of an existing
system and thereby give suggestions for the improvement of the new system
information about the organizations, policies, goals, objectives and structure explain
the kind of environment that promotes the introduction of the computer-based system.

St. Mary’sCollege,Thrissur Page9

B.Voc Software Development 2023-2026 Urbanea Furniture
3.1 Existing Systems

The MEDICARE Website Offers About finding doctors and booking appointments is
manual and inefficient.
Booking appointments requires phone calls or visits to the hospital.
Medical history is scattered across different hospitals and clinics.
Our project, Medicare, aims to address these challenges.
Medicare provides a centralized platform for patients to search for doctors and book
appointments.
Medicare streamlines healthcare management.

For administrators, the admin dashboardenables simple management of Hospital

details and Doctors Of list allowing for smooth business operations. The contact form
is intuitive and provides a quick way for customers to reach out. Overall, the website
enhances customer trust and streamlines store management for a successful online
presence.

3.1.1 Drawbacks of Exiting System

• Limited Customer Engagement: While product descriptions are provided, the

absence of customer reviews reduces the potential for user-generated feedback and
trust-building.

• Basic Shopping Cart: The cart lacks features like real-time order confirmation,
integrated payment gateways, and automated receipts, which could improve the user
experience.

• Manual Client Interactions: Customer inquiries and orders are still handled
manually through email or phone, which can slow down the response time and overall
efficiency.

• Simple Contact Form: The form lacks validation and automated replies, potentially
leading to incomplete information or delayed responses.

St. Mary’sCollege,Thrissur Page10

B.Voc Software Development 2023-2026 Urbanea Furniture
• Admin Panel Constraints: The admin panel is basic, lacking features like inventory
management, sales analytics, and customer feedback tools that could improve busine

3.2 Proposed System

In the proposed Medicare system, patients benefit from a streamlined communication

feature that sets it apart from traditional healthcare systems. Unlike conventional systems
where patients often need to contact hospitals or clinics via phone or email and wait for a
response, this platform allows patients to send real-time inquiries directly to doctors or
healthcare providers. This feature enables patients to ask questions, request additional
information, or book appointments instantly, without having to go through a prolonged
waiting process. By facilitating direct and immediate communication, the system aims to
provide faster and more efficient responses, improving overall patient satisfaction. This
not only enhances the healthcare experience by allowing patients to make informed
decisions more quickly but also reduces the time and effort required for both patients and
healthcare providers to handle inquiries and support.

3.2.1 Functional Requirements

• Patient Module
• Patient Catalog
- View More (Patients Details)
List Of Doctors
- Booking
- View Details
- Checkout
• User Account
- Register/Log In
- Update Profile
- Order History
- Book Appointment
• Contact and Communication
- Contact Form
• Admin Module

St. Mary’sCollege,Thrissur Page11

B.Voc Software Development 2023-2026 Urbanea Furniture
- Product Management
- Add/Update/Delete Products
- Inventory Management
• Appointment Booking
- View Appointment
• Patients Management
- View patient Details

3.2.2 Advantages of Proposed System

- Enhanced Patient Engagement

- Streamlined Appointment Scheduling

- Efficient Patient Management

- User-Friendly Patient Portal

- Reduced Wait Times

- Improved Patient Satisfaction

- Simplified Admin Tasks

- Enhanced Scalability

St. Mary’sCollege,Thrissur Page12

B.Voc Software Development 2023-2026 Urbanea Furniture
FEASIBILITY ANASLYSIS

4.FEASIBILITY ANASLYSIS
Whatever we think need not be feasible.It is wise to think about the feasibility of any
problem we undertake. Feasibility is the study of impact, which happens in the
organization by the development of a system. The impact can be either positive or
negative. When the positives nominate the negatives, then the system is considered
feasible. Here the feasibility study can be performed in two ways such as technical
feasibility and Economical Feasibility

4.1.Technical Feasibility:

We can strongly say that it is technically feasible since there will not be much
difficulty in getting already required resources for the development and maintaining
the system as well. All the resources needed for the development of the software as
well as the maintenance of the same are available in the organization here we are
utilizing the resources which are available.

Technical feasibility is all about the hardware and software facilities in

St. Mary’sCollege,Thrissur Page13

B.Voc Software Development 2023-2026 Urbanea Furniture
“MEDICARE” is a website, so it uses only normal hardware devices monitor,
keyboard, mouse, etc. The software WAMP is used for development. So, the
“MEDICARE” is technically feasible.

4.2.EconomicalFeasibility:

Development of this application is highly economically feasible.The

organization needed not spend much money for the development of the system already
available. The only thing is to be done is making an environment for the development
with an effective supervision. If we are doing so, we can attain the maximum usability
of the corresponding resources.Even after the development, the organization will not
be in a condition to invest more in the organization Therefore, the system is
economically feasible.

4.3 Project Planning:

The initial planning of the project has completed within 3 weeks. For the system study
and technical assistance, I met Smt.Ridhin Reji our project guide. According to the
plan, the hardware requirements of this project a are monitor, keyboard, mouse,
Intel(R) Core(TM) i3-6100U CPU @2.30GHz etc. The software used is WAMP, as the
development environment for PHP and MYSQL as the server. The dead line of the
project is March 1st week. In the project,”MEDICARE” the operating system used is
Windows 11, a personal computer operating system developed by Microsoft. Windows
11 was chosen because it‟s the latest version and its features.

St. Mary’sCollege,Thrissur Page14

B.Voc Software Development 2023-2026 Urbanea Furniture

SYSTEM DESIGN

5. SYSTEM DESIGN
5.1 Fundamental Design Concepts
Design is the first step in the development phase for any engineered product or system.
Design is a creative process; a good design is the key to effective system.
The term “Design” is defined as “The process of applying various techniques and
principles for the purpose of defining a device, a process or a system in sufficient detail

St. Mary’sCollege,Thrissur Page15

B.Voc Software Development 2023-2026 Urbanea Furniture
to permit its physical realization”. It may be defined as the process of applying various
techniques and principles for the purpose of defining a device, a process or a system
in sufficient detail to permit its physical realization. Software design sits at the
technical kernel of the software engineering process and is applied regardless of the
development paradigm that is used.
From a project management point of view, software design is conducted in two steps.
Preliminary design is concerned with the transformation of requirements into data and
software architecture. Detail design focuses in on refinement to the architectural
representation that leads to detail algorithm data structure and representation of
software.
In system design high-end decisions are taken regarding the basic system architecture,
platforms and tools to be used the system design transforms a logical representation
of what a given system is required to be in the physical specification. Designs start
with the system requirement specification and convert it to physical reality during the
development. Important design factors such as reliability response time, through put
of the system maintain ability, expand ability etc. should be taken into account.

5.11 Input Design

In the input design for the “MEDICARE” website, user-oriented inputs are transformed
into a format suitable for computer processing. Users interact with the system primarily
through web forms, where input is collected via a graphical user interface (GUI). The
main approaches to input design involve menu and form-based interactions, where user
options are predefined to ensure consistency and ease of use.

Key aspects of the input design include:

- User-Friendly Forms: Forms are designed with intuitive layouts to minimize user
errors and ensure efficient data entry. This includes:
- Admin and User Login Form: Secure authentication for accessing different system
functionalities.
- User Registration Form: For creating and managing user accounts.
- Product Details Entry Form: For admins to add and update product information.
- Error Reduction: Input forms are designed to capture only the necessary data,
reducing the likelihood of errors.

St. Mary’sCollege,Thrissur Page16

B.Voc Software Development 2023-2026 Urbanea Furniture
- Logical Data Flow: Data collected through these forms is organized and processed
logically according to the data flow diagram, which outlines data stores, sources, and
destinations.

The goal of the input design is to make data entry as straightforward, logical, and error-
free as possible, enhancing the overall efficiency of the system.

5.12 Output Design

In the output design for the “MEDICARE “ website, the focus is on presenting
information clearly and effectively, whether on-screen or through printable formats.
The outputs are crucial as they provide the user with actionable information and
feedback from the system.

Key aspects of the output design include:

- Presentation and Layout: Outputs are designed to be clear and easy to interpret,
ensuring that information is presented in a structured and logical manner. This
includes:
- Product Page: Displays detailed patients and Doctor information and patient
feedback
- Order Confirmation Page: Provides a summary of purchase details and order status.
- Output Media: Outputs are optimized for both on-screen display and printable
formats, considering factors like screen resolution and print quality. - Efficiency and
Accuracy: The design ensures that the output is accurate and provided in a timely
manner, supporting user decision-making and improving system interactions.

The aim of the output design is to enhance user experience by delivering clear,
accurate, and actionable information efficiently.

See Appendix B for Screen Shots

St. Mary’sCollege,Thrissur Page17

B.Voc Software Development 2023-2026 Urbanea Furniture

5.2 DATABASE DESIGN

Database design is organized as a standard of management information system and is

available virtually for every computer system. The general theme behind a database is
to integrate all the information. A database is an integrated collection of data and
provides centralized access to the data .A database is a collection of inter-related data
stored with minimum redundancy to serve many users quickly and efficiently. The
general objective of data base design is to make the data access easy, inexpensive and
flexible to the user.

A good data base design does the following:

1. Provides minimum search times when locating specific records.

2. Stores the data in the most different manner possible to keep the
database from growing large.
3. Make data updates as easy as possible.
4. Is flexible enough to allow inclusion of new functions required of
program.

The DBMS is responsible for enforcing the database structure, including

1. Maintaining the relationships between data in the database
2. Ensuring that data is stored connately, and that the rules defining thus
Relationships are not violated.
3. Recovering all data to point of known constancy in case of system.
5.2.1Overall Description
The project titled “MEDICARE” facilitates the users and admin to store data. The users
can view the cases available. There is more security and save the valuable time.

St. Mary’sCollege,Thrissur Page18

B.Voc Software Development 2023-2026 Urbanea Furniture
1.Product Perspective
The project titled “MEDICARE” is a web application. Here we are computerizing the
standards.

2.System Interface
The user acclimates with the system through the GravidLier Interface which is the
active.

3.User Section
Software “MEDICARE” contains 2 main modules based on the services provided.
These are the following modules:
• Admin
• User
Admin login
In proposed system there is different login for User and Admin, They have certain
special credentials for accessing the system. The admin can login using the password
and id . They can directly enter to their own home page and can add products and
observe the system.
1. Stores the data in the most efficient manner possible to keep the database from
growing large.
2. Make data updates as easy as possible.
3. Is flexible enough to allow inclusion of new functions required of program.

User login:
Registered user can enter in to their own home page, can see the cases that are inserted
by the admin. User information's are stored in register table. They can view doctor details
and book appointment.

4.Communication interface
The user can communicate with the system through Graphical UserInterface

5.Memory constraints
Intel(R) Core(TM) i3-6100U CPU @2.30GHz 4GB RAM of hard disk space will be
required so that the software performs its functions in an optimum manner.

St. Mary’sCollege,Thrissur Page19

B.Voc Software Development 2023-2026 Urbanea Furniture
6.Operations
The operations of general user are limited, but the registered users can view the cases
and message.

7.Adaptation requirements

8.The user must careful when they provide personal details such as username,
password, email id etc.

5.3 NORMALIZATION

5.3.1 DATA NORMALIZATION

Normalization is the term obtained from the Latin word “NORMA” which means that
square used by the carpenter. Normalization is the process of simplifying the

St. Mary’sCollege,Thrissur Page20

B.Voc Software Development 2023-2026 Urbanea Furniture
relationship between data elements in a record. Through normalization a collection of
data in a record structure is replaced by successive record structures that are simpler
and can be managed efficiently. While designing the data base, we have to implement
the concept of normalization to avoid redundancy in database.
Normalization is being carried out for four reasons:
• To structure the data so that any pertinent relationship between entities can be
represented.
• To permit simple retrieval of data in response to query and reports required.
• To simplify data maintenance procedure such as insertion, deletion and updating.
• To reduce the need to be structured or recognized data with new application
requirements arise.
The major normalization strategies:
• First Normal Form
• Second Normal Form

First Normal Form

First Normal Form is achieved when all repeating groups in a record are removed, so
that record is of fixed length. A repeating group, reoccurrence of a data item or group
of data item within a record indicates another relation.

Second Normal Form

It is achieved when a recovered is in first normal form and each item in the record is
functionally dependency. A data item is functionally dependent of its value is uniquely
associated with a specific item. To achieve second normal form every column in a
table that is not dependent on the primary key of the record should be removed and
used to form a separate relation.

Secure URBANEA FURNITURE system uses a database in second normalized form

since all non-key attributes of each table is depend on the key attribute of that table.
Database in the web server is managed by MySQL Server.

By normalizing the database into 2NF we could remove data redundancy in the tables
Normalization also improved the performance of the application since the complexity

St. Mary’sCollege,Thrissur Page21

B.Voc Software Development 2023-2026 Urbanea Furniture
of handling a normalized database from the front end always less. Integrity constraints
are implemented in the database by specifying the primary key in tables. Also,
validations are performed at the front-end code.

See Appendix A for Table design

The database contains eight tables and they are:

• admin
• user
• products
• wishlist
• cart
• cart_items
• orders
• addresses

SYSTEM TESTING

St. Mary’sCollege,Thrissur Page22

B.Voc Software Development 2023-2026 Urbanea Furniture

6.SYSTEM TESTING
Testing is a process of executing a program with the intention of finding error. If testing
is conducted successfully, it uncovers error in software. Also testing demonstrates the
software functions appear to be working according to the specification that behavioral
and performance requirements appear to have been met.

6.1Testing Objectives:
• Good tests can one that has a high probability of finding a yet undiscovered error.
• A successful test is one that uncovers a yet undiscovered error.

6.2Type of System Testing:

UNIT TESTING
Unit testing focuses verification effort in the smallest unit of software design, the
software component or module. The unit test is box oriented, and the step can be
performed in parallel for multiple components.
We tested the module interface to ensure that information properly flows into and out of
program unit under test. The local data structure was examined to ensure that data store
temporarily maintained its integrity during all steps. All independent paths through the
control structure exercise to ensure that all statements in a module have beenexercised
at least once.

• BOTTOM-UP INTEGRATION TESTING

Integration testing is a systematic technique for constructing the program structure
while at the same time conducting test to uncover errors associated with interfaces. The
objectives are to take unit tested components and build a program structure that has
been dictated by designing.
We conducted the Bottom-up Integration Testing and as the name imply construction
and testing began with the atomic modules. Since components were integrated from
bottom up, processing required for components subordinate to a given level where
always available and so the need for stubs was eliminated.

St. Mary’sCollege,Thrissur Page23

B.Voc Software Development 2023-2026 Urbanea Furniture
• VALIDATION TESTING
A quality assurance process carried out before the software is ready for release is
known as validation testing. Its goals are to validate and be confident about the
software product or system, that it fulfills the requirements given by the customer.
The acceptance of the software from the end customer is also its part. Validation
succeeds when the software function in a manner t hat can be reasonably expected by
the customer.
During validation tests, we designed both plan and procedures to ensure that all
functional requirements were satisfied, all performance required were attained,
documentation was corrected and human engineered requirements were met.

User registration form validation :

St. Mary’sCollege,Thrissur Page24

B.Voc Software Development 2023-2026 Urbanea Furniture

SYSTEM IMPLEMENTATION

7.1. SYSTEM IMPLEMENTATION

Implementation is the process of converting a new system in to an operational one. It
is a key stage in achieving a successful new system it involves a lot of upheaval in the
St. Mary’sCollege,Thrissur Page25
B.Voc Software Development 2023-2026 Urbanea Furniture
user department. It must therefore be carefully planned and controlled.
Implementation is mainly concerned with the following,

• User training
• Documentation

7.2.USER TRAINING:
After the system is implemented carefully, training of the user is one of the important
subtasks of the developer.

7.3.DOCUMENTATION:
The whole system is documented and presented in a readable manner. The
documentation is useful for future use.

SYSTEM MAINTENANCE AND

SECURITY MEASURES

St. Mary’sCollege,Thrissur Page26

B.Voc Software Development 2023-2026 Urbanea Furniture

8. SYSTEM MAINTENANCE AND SECURITY

MEASURES
8.1 SYSTEM MAINTENANCE
Software maintenance is the process of modifying a software system of component
after its delivery in order to correct faults, improve the performance and the other
attributes, or to adapt to the changed environment Maintenance covers a wide range
of activities including correcting the coding and design errors, updating the
documentation and test data, and upgrading the user support. There is an aging process
that calls for periodic maintenance of hardware and software. Maintenance is always
necessary to keep the software usable and useful. Hardware also requires periodic
maintenance activities can be classified into

• Corrective Maintenance

• Perceptive Maintenance

• Adaptive Maintenance

Corrective maintenance removes software faults. Perceptive maintenance improves

the system without changing its functionality. The objective of perceptive maintenance
should be to prevent failures and optimize the software. Adaptive maintenance
modifies the software to keep it up-to-date with its operative environment.

8.2 SECURITY MEASURES

Any software developed should be secured and protected against possible hazards.
Security measures are provided to prevent unauthorized access of the database from
various levels.
Software is heart of an organization‟s computer operation. Therefore, it is essential
that software function correctly and be protected from corruption. Closely related to
software support is configured management-the process of keeping track of changes

St. Mary’sCollege,Thrissur Page27

B.Voc Software Development 2023-2026 Urbanea Furniture
to the system and if needed, approving them. Configuration management normally
addresses hardware, software, networking and other changes; it can be formal

or informal. The primary security goal of configuration management is to ensuring that

changes to the system do not unintentionally or unknowingly diminish security. A
second security goal of configuration management is to ensuring that changes to the
system do not unintentionally or unknowingly diminish security. A second security
goal of configuration management is ensuring that changes to the system are reflected
in other documentation, such as contingency plan. If the change is major, it may be
necessary to reanalyze some or all of the security of the system.

Backups
Usually support and operation personnel backup software and data. This function
is critical to contingency planning. Frequency of backups will depend on how
often data changes and how important those changes are.

St. Mary’sCollege,Thrissur Page28

B.Voc Software Development 2023-2026 Urbanea Furniture

CONCLUSION

9.CONCLUSION
URBANEA FURNITURE system is highly secure solution that enables the activities
of data standardization. It helps to make the process easier it facilitates the registered
users to view cases and communicate.

It was completed successfully within the time span allotted. It has been great
pleasure for me to work on this exciting and challenging project. This project is
developed by using MySQL and PHPas it is very flexible with user friendly screens,
the user can use without inconvenience. This provides a better system and avoids
existing system problems. It also satisfies present requirements. All the knowledge I
gained is full applied in the design of the mentioned system application package is
developer. All the suggestions forwarded in the software proposal have been
completed. This system is developed in such a way that the modules developed in the
future can be linked easily to the system, without affecting the existing system, since
it provides a hierarchical structure.

St. Mary’sCollege,Thrissur Page29

B.Voc Software Development 2023-2026 Urbanea Furniture
Top-down programming approach has been adopted while developing the
project, each task is divided into separate modules. Hence modification and
enhancement can be easily made without affecting any other part of the program. The
performance of the system is provided efficiently. The system was tested with all
possible sample data and was found to have an affective planning of the functions or
process with a high degree of accuracy and user friendliness.

Sruthy Subash

SCOPE FOR FUTURE ENHANCEMENT

St. Mary’sCollege,Thrissur Page30

B.Voc Software Development 2023-2026 Urbanea Furniture

10.SCOPE FOR FUTURE ENHANCEMENT

As Urbanea Furniture continues to grow and evolve, several enhancements can be

considered to improve user experience, streamline administrative functions, and
expand the platform's capabilities. One significant enhancement is the
implementation of a robust recommendation system. By utilizing machine learning
algorithms, the application could analyze user behavior and preferences, suggesting
products that align with their interests. This personalized shopping experience could
increase user engagement and drive sales.

Another potential improvement is the integration of a multi-vendor marketplace

feature. This would allow third-party sellers to list their furniture products on the
Urbanea platform, broadening the product range and attracting a larger customer
base. This enhancement would require additional modules for vendor management,
product approvals, and revenue-sharing mechanisms, ultimately fostering a diverse
marketplace.

To further elevate customer service, incorporating a live chat support system would
enable real-time assistance for users. This feature could facilitate quick resolutions to
inquiries and enhance overall customer satisfaction. Coupled with a comprehensive
FAQ section and AI-driven chatbots, the support system could significantly reduce
response times and improve the user experience.

In terms of administrative capabilities, enhancing the reporting and analytics module

could provide deeper insights into sales trends, user behavior, and inventory
management. By integrating advanced analytics tools, administrators would gain
valuable information to inform strategic decisions, optimize stock levels, and identify
popular product categories, thereby maximizing operational efficiency.

Additionally, expanding the payment options available on the platform would cater to
a wider audience. Incorporating various payment gateways, including digital wallets
and buy-now-pay-later options, could facilitate seamless transactions and improve
conversion rates. Security enhancements should also be prioritized, ensuring that all
payment processes adhere to the latest compliance standards.

Finally, developing a mobile application could extend the reach of Urbanea Furniture,
allowing users to browse and shop on-the-go. A mobile-friendly interface would cater
to the increasing number of consumers who prefer shopping through their
smartphones, making the platform more accessible and convenient. With these
enhancements, Urbanea Furniture can position itself as a leading online furniture
store while continually adapting to the evolving needs of its users.

St. Mary’sCollege,Thrissur Page31

B.Voc Software Development 2023-2026 Urbanea Furniture

APPENDIX

St. Mary’sCollege,Thrissur Page32

B.Voc Software Development 2023-2026 Urbanea Furniture

11.1 . DATA FLOW DIAGRAM (DFD )

DFD 0th Level

St. Mary’sCollege,Thrissur Page33

B.Voc Software Development 2023-2026 Urbanea Furniture

DFD 1st Level (Admin Side)

St. Mary’sCollege,Thrissur Page34

B.Voc Software Development 2023-2026 Urbanea Furniture

DFD 2nd Level (Admin Side)

St. Mary’sCollege,Thrissur Page35

B.Voc Software Development 2023-2026 Urbanea Furniture

DFD 1st Level (User side)

St. Mary’sCollege,Thrissur Page36

B.Voc Software Development 2023-2026 Urbanea Furniture

DFD 2nd Level (User side)

St. Mary’sCollege,Thrissur Page37

B.Voc Software Development 2023-2026 Urbanea Furniture

11.2 . APPENDIX A: TABLE DESIG N

This project use tables are:

Admin
User
Products
Wishlist
Cart
Cart_items
Orders
Addresses

Table No: 1

Table Name: admin

Table Description: admin details

Table No: 2
Table Name: user

St. Mary’sCollege,Thrissur Page38

B.Voc Software Development 2023-2026 Urbanea Furniture

Table Description: userdetails

St. Mary’sCollege,Thrissur Page39

B.Voc Software Development 2023-2026 Urbanea Furniture

Table No: 3
Table Name: products
Table Description: products details

St. Mary’sCollege,Thrissur Page40

B.Voc Software Development 2023-2026 Urbanea Furniture

Table No: 4
Table Name: wishlist
Table Description: wishlist details

Table No: 5
Table Name: cart
Table Description: cart details

St. Mary’sCollege,Thrissur Page41

B.Voc Software Development 2023-2026 Urbanea Furniture

Table No: 6
Table Name: cart_item s
Table Description: cart_items details

Table No: 7
Table Name: orders
Table Description: order details

St. Mary’sCollege,Thrissur Page42

B.Voc Software Development 2023-2026 Urbanea Furniture

Table No: 8
Table Name: addresses
Table Description: address details

St. Mary’sCollege,Thrissur Page43

B.Voc Software Development 2023-2026 Urbanea Furniture

11.3. CODE

Index.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport"
content="width=device-width, initialscale=1.0">
<title>Furniture Website</title>

<!-- Link to your CSS file -->

<link rel="stylesheet" href="style2.css">

<!-- Font Awesome CDN --> <link rel="stylesheet"

href="https://cdnjs.cloudflare.com/ajax/libs/fontawesome/6.4.0/css/all.min.css">
</head>
<body>

<!-- Header Start -->

<div class="header">
<nav>
<input type="checkbox" id="show-search">
<input type="checkbox" id="show-menu">
<label for="show-menu" class="menu-icon"><i class="fas fabars"></i></label>
<div class="content">
<div class="logo"><a href="index.html"><img src="./images/logo.png"
alt=""></a></div>
<!-- Navigation Links -->
<ul class="links">
<li><a href="#" id="first">Home</a></li>
<li><a href="#about">About</a></li>
<li><a href="login_form.php?redirect=product.php">Products</a></li>
<li><a href="#contact">Contact</a></li>
<li><a href="login_form.php?redirect=wishlist.php">My Wishlist</a></li

St. Mary’sCollege,Thrissur Page44

B.Voc Software Development 2023-2026 Urbanea Furniture

St. Mary’sCollege,Thrissur Page45

B.Voc Software Development 2023-2026 Urbanea Furniture

<li><a href="login_form.php?redirect=cart.php">My
Cart</a></li>
<li><a
href="login_form.php?redirect=userdashboard.php">Profile</a></li>
<li><a href="adminlogin.php">Admin</a></li>
</ul>
</div>
<label for="show-search" class="search-icon"><i class="fas
fa-search"></i></label>
<form action="#" class="search-box">
<input type="text" placeholder="Search" required>
<button type="submit" class="go-icon"><i class="fas fa-long-arrow-alt-
right"></i></button>
</form>
</nav>
</div>
<!-- Header End -->

<!-- Home Section Start -->

<div class="home">
<div class="main-text">
<h1>Urbanea furniture</h1>
<p>Designed To Bring Life Into Balance!</p>
</div>
</div>
<!-- Home Section End -->

<!-- Top Section Card Start -->

<section class="offers">
<div class="offer-content">
<div class="row">
<i class="fa-solid fa-headset"></i>
<h3>Call Support </h3>
<p>Monday - Saturday , 10:00 AM - 10:00 PM</p>
</div>
<div class="row">
<i class="fa-solid fa-rotate-left"></i>
<h3>Return Policy</h3>
<p>Within 3 weeks</p>
</div>
<div class="row">
<i class="fa-solid fa-cart-shopping"></i>
<h3>Secure Shopping</h3>
<p>Protected purchase process.</p>
</div>

St. Mary’sCollege,Thrissur Page46

B.Voc Software Development 2023-2026 Urbanea Furniture

St. Mary’sCollege,Thrissur Page47

B.Voc Software Development 2023-2026 Urbanea Furniture

</div>
</section>
<!-- Top Section Card End -->

<!-- About Section Start -->

<section class="about" id="about"><div class="about-img">

<img src="./images/about-img.png" alt="">
</div>
<div class="about-text">
<h3>Furniture service About us</h3>
<p>Welcome to our furniture shop, where we combine a
passion for craftsmanship with contemporary design. Our curated
collection features pieces that blend minimalist elegance with
functional simplicity, perfect for creating inviting and stylish
living spaces. Whether you're updating a single room or renovating
your entire home, our team is here to help you find furniture that
fits your lifestyle and inspires your personal style. Discover
quality,comfort,and modernity all in one place at our furniture
shop.</p>
<button id="about-btn">Read More...</button>
</div>
</section>
<!-- About Section End -->

<!-- Our Gallary Start -->

<div class="gallary">
<h3>Our Gallary</h3>
<div class="gallary-img">
<div class="img1">
<img src="./images/g1.png" alt="">
</div>
<div class="img1">
<img src="./images/g2.png" alt="">
<img src="./images/g3.png" alt="">
</div>
</div>
</div>
<!-- Our Gallary End -->

<!-- Contact Section Start -->

<section class="contact" id="contact">
<div class="content-text">
<h2>Get In <span>Touch</span></h2>

St. Mary’sCollege,Thrissur Page48

B.Voc Software Development 2023-2026 Urbanea Furniture

<p>Contact us today to discover our exquisite collection of

furniture.Whether you're seeking design advice,require assistance with
measurements, or have inquiries about our products, our friendly team
is here to assist you.</p>
<p>Reach out now to begin transforming your space with our
stylish and functional pieces.</p>

<div class="list">
<li><a href="#">phone no:9853539482</a></li>
<li><a href="#">urbaneafurniture@gmail.com</a></li>
<li><a href="#">Nellayi PO, Ulumbathukunnu</a></li>
<li><a href="#">Pin code:680305</a></li>
</div>
</div>

</section>
<!-- Contact Section End -->

register_form.php

St. Mary’sCollege,Thrissur Page49

B.Voc Software Development 2023-2026 Urbanea Furniture
<?php include 'connection.php'; // Adjust this if you use a
different name for your connection file
if (isset($_POST['submit']))
{
$name = mysqli_real_escape_string($conn, $_POST['name']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
$user_type = $_POST['user_type'];

// Check if passwords match

if ($password !== $cpassword) {
$error[] = 'Passwords do not match!';
} else {
// Check if email already exists
$select = "SELECT * FROM user WHERE email = ?";
if ($stmt = $conn->prepare($select)) {
$stmt->bind_param('s', $email);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
$error[] = 'User already exists!';

St. Mary’sCollege,Thrissur Page50

B.Voc Software Development 2023-2026 Urbanea Furniture

} else {
// Hash the password
$hashed_password = password_hash($password,
PASSWORD_DEFAULT);

// Insert new user

$insert = "INSERT INTO user (name, email,

password, user_type) VALUES (?, ?, ?, ?)"; if
($stmt = $conn->prepare($insert)) {
$stmt->bind_param('ssss', $name, $email,
$hashed_password, $user_type);
$stmt->execute();
header('Location: login_form.php');
exit(); } else {
die("Error: " . $conn->error);
}
} } else {
die("Error: " . $conn->error);
}
}
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,
initialscale=1.0">
<title>Register Form</title>
<link rel="stylesheet" href="user_style.css">
</head>
<body>
<div class="form-container">
<form action="" method="post">
<h3>Register Now</h3>
<?php if (isset($error)): ?>
<?php foreach ($error as $err): ?>
<span class="error-msg"><?php echo
htmlspecialchars($err); ?></span>
<?php endforeach; ?>
<?php endif; ?>

St. Mary’sCollege,Thrissur Page51

B.Voc Software Development 2023-2026 Urbanea Furniture

<input type="text" name="name" required placeholder="Enter

your name">
<input type="email" name="email" required placeholder="Enter
your email">
<input type="password" name="password" required
placeholder="Enter your password">

<input type="password" name="cpassword" required

placeholder="Confirm your password">
<select name="user_type">
<option value="user">User</option>
<option value="admin">Admin</option>
</select>
<input type="submit" name="submit" value="Register Now"
class="form-btn">
<p>Already have an account? <a
href="login_form.php">Login now</a></p> </form>
</div>
</body>
</html>

Login_form.php

St. Mary’sCollege,Thrissur Page52

B.Voc Software Development 2023-2026 Urbanea Furniture
<?php include 'connection.php'; // Ensure this file contains the
correct database connection code session_start();

// Default redirect locations

$default_redirect = 'userdashboard.php';

// Handle login form submission

if (isset($_POST['submit'])) {
$email = mysqli_real_escape_string($conn, $_POST['email']);
$password = $_POST['password'];

$select = "SELECT * FROM user WHERE email = ?";

if ($stmt = $conn->prepare($select)) {
$stmt->bind_param('s', $email);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
$row = $result->fetch_assoc();

St. Mary’sCollege,Thrissur Page53

B.Voc Software Development 2023-2026 Urbanea Furniture

// Verify the hashed password if

(password_verify($password, $row['password'])) {
$_SESSION['user_id'] = $row['Id'];
$_SESSION['user_name'] = $row['name'];
$_SESSION['user_type'] = $row['user_type'];

// Determine the redirect URL

$redirect = isset($_GET['redirect']) ?
urldecode($_GET['redirect']) : $default_redirect;

// Clear the redirect query parameter

header('Location: ' . htmlspecialchars($redirect));
exit();
} else {
// Incorrect password
$_SESSION['error'] = 'Incorrect email or
password!'; header('Location: ' .
htmlspecialchars($_SERVER['PHP_SELF'])); exit();
}
} else {
// No user found
$_SESSION['error'] = 'Incorrect email or password!';
header('Location: ' .
htmlspecialchars($_SERVER['PHP_SELF']));
exit();
}
} else {
die("Error: " . $conn->error);
}
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,
initialscale=1.0">
<title>Login Form</title>
<link rel="stylesheet" href="user_style.css">
</head>
<body>
<div class="form-container">
<form action="" method="post">

St. Mary’sCollege,Thrissur Page54

B.Voc Software Development 2023-2026 Urbanea Furniture

<h3>Login Now</h3>
<?php if (isset($_SESSION['error'])): ?>
<span class="error-msg"><?php echo
htmlspecialchars($_SESSION['error']); ?></span>
<?php unset($_SESSION['error']); // Clear error message
after displaying ?>

<?php endif; ?>

<input type="email" name="email" required placeholder="Enter
your email">
<input type="password" name="password" required
placeholder="Enter your password">
<input type="submit" name="submit" value="Login Now"
class="form-btn">
<p>Don't have an account? <a href="register_form.php">Register
now</a></p> </form>
</div>
</body>
</html>

St. Mary’sCollege,Thrissur Page55

B.Voc Software Development 2023-2026 Urbanea Furniture

St. Mary’sCollege,Thrissur Page56

B.Voc Software Development 2023-2026 Urbanea Furniture

11.4 . APPENDIX B: SCREEN LAYOUTS

Index page :

St. Mary’sCollege,Thrissur Page57

B.Voc Software Development 2023-2026 Urbanea Furniture

St. Mary’sCollege,Thrissur Page58

B.Voc Software Development 2023-2026 Urbanea Furniture

User Registration page:

User login page:

St. Mary’sCollege,Thrissur Page59

B.Voc Software Development 2023-2026 Urbanea Furniture

Admin login page :

Products page:

St. Mary’sCollege,Thrissur Page60

B.Voc Software Development 2023-2026 Urbanea Furniture

Viewmore page:

Cart Page:

St. Mary’sCollege,Thrissur Page61

B.Voc Software Development 2023-2026 Urbanea Furniture

Admin dashboard page:

User dashboard page :

St. Mary’sCollege,Thrissur Page62

B.Voc Software Development 2023-2026 Urbanea Furniture

BIBLIOGRAPHY

St. Mary’sCollege,Thrissur Page63

B.Voc Software Development 2023-2026 Urbanea Furniture
12.BIBLIOGRAPHY Websites
● https://www.javatpoint.com
● https://www.tutorialspoints.com
● https://fontawesome.com
● https://www.colorlib.com
● https://stackoverflow.com Books
● Professional PHP Programming Author:Sascha Schumann

St. Mary’sCollege,Thrissur Page64

B.Voc Software Development 2023-2026 Urbanea Furniture

● PHP and MySQL Training Guide Author:Ramesh Bangia

St. Mary’sCollege,Thrissur Page65

B.Voc Software Development 2023-2026 Urbanea Furniture
●SoftwareEngineering:APractitionersApproach,Author:R.
S Pressmans

St. Mary’sCollege,Thrissur Page66

B.Voc Software Development 2023-2026 Urbanea Furniture

St. Mary’sCollege,Thrissur Page67