Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A project report titled 'CASA DECOR' submitted towards the partial fulfilment of the requirements for the Integrated Master of Computer Applications (MCA) degree from APJ Abdul Kalam Technological University. The report focuses on system design using MySQL, the most popular Open Source SQL database management system developed by Oracle Corporation.
Typology: Thesis
1 / 99
This page cannot be seen from the preview
Don't miss anything!
[Affiliated to APJ Abdul Kalam Technological University, Kerala. Approved by AICTE, Accredited by NAAC with ‘A’ grade. Koovappally, Kanjirappally, Kottayam, Kerala – 686518]
Dr. BIJIMOL TK Ms. MEERA ROSE MATHEW Internal Guide Coordinator Rev. Fr. Dr. Rubin Thottupurathu Jose External Examiner Head of the Department
First and foremost, I thank God almighty for his eternal love and protection throughout the project. I take this opportunity to express my gratitude to all who helped me in completing this project successfully. It has been said that gratitude is the memory of the heart. I wish to express my sincere gratitude to our manager Rev. Fr. Dr. Mathew Paikatt and Principal Dr. Lillykutty Jacob for providing good faculty for guidance. I owe a great depth of gratitude towards our Head of the Department Rev. Fr. Dr. Rubin Thottupurathu Jose (Head of Department) for helping us. I extend my whole hearted thanks to the project coordinator Ms. Meera Rose Mathew (Assistant Professor) for her valuable suggestions and for overwhelming concern and guidance from the beginning to the end of the project. I would also like to express sincere gratitude to my guide , Dr. Bijimol T K (Assistant Professor) for her inspiration and helping hand. I thank our beloved teachers for their cooperation and suggestions that helped me throughout the project. I express my thanks to all my friends and classmates for their interest, dedication, and encouragement shown towards the project. I convey my hearty thanks to my family for the moral support, suggestions, and encouragement to make this venture a success. MEKHA RAMLAL
CASA DÉCOR is a web application to purchase Home Decoration items from anywhere and anytime. The Internet has become an essential part of our daily life, and companies realize that the Internet can be a shopping avenue to reach existing and potential consumers of any business. Online shopping has been known as a rapidly growing business, and although online shopping has not followed these same growth patterns in the past, it is now being recognized for its potential. Now consumers approach and attitudes towards online shopping is rapidly increased. Now people prefer online shopping rather than offline shopping, because it is very easy, time consuming, will get brand products, have return opportunity and can order product from anywhere, anytime. In this project, the main aim is to demonstrate that with better interaction features in decoration websites could improve sales over the internet in Casa Décor. The CASA DÉCOR presents an online display of an order and an associated delivery window for items selected by the customers. An online platform for buying decoration items & accessories for your interior, which is most important segment in setting the complete ambience of your home. The system consists of decoration items such as plants, tables, mirrors, lamps etc.” In this contemporary society, bounded by the search of constant technological advances and innovations, consumers are becoming less and less loyal to any specific brand or retail format and increasingly focus on the satisfaction of immediate goals and needs. Consequently, online shopping has become a highly profitable retail format, achieving high sales values across much of the developed world.
MANAGEMENT SYSTEM 6.2.2 TRAINING ON APPLICATION SOFTWARE
IDE - Integrated Development Environment HTML - Hyper Text Markup Language. CSS - Cascading Style Sheet SQL - Structured Query Language UML - Unified Modeling Language
CASA DECOR^2 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications
CASA DÉCOR is a web application to purchase Home Decoration items from anywhere and anytime. This is meant to help the customers to make purchase home decoration items. The customer can also reduce the time, effort and cost in searching items by using this system. Customer can easily find decoration items which is suitable according to many factors. The proposed system includes two users they are administrator and customer. Registered customers can login to the site and can search the items he wants to purchase and can also make the payment through online. 1.2 PROJECT SPECIFICATION The proposed system is a website in which user can book online for servicing. Also that the customers how come to service center also have access to the web were he/she can view all the service history of their vehicle. The system includes 3 modules. They are:
1. Admin Module Admin must have a login into this system. He has the overall control of the system. Admin can add or update service details, manage user data etc. Admin can View all the registered users, orders, shop details and also manage all his data. Admin can add shop and send login details to each shop where added. 2. Customer Module Customer can register and they can book for service and also view also information about His/her purchase. 3. Shop Module Shop can add product and if any customer purchase product from that shop, the shop Will get the amount of the product and deduct site charge from the customer.
CASA DECOR^3 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications CHAPTER 2 SYSTEM STUDY
CASA DECOR^5 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications
Existing system is not a fully automated system. Customer can register and they can book for service. Each customer can create their own profile .The proposed system rectify the drawbacks of the present system. It is necessary to modify the existing system in order to include additional information and make the system efficient, flexible and secure. Using the new system customers can view all information about his order, bill etc. 2.3 DRAWBACKS OF EXISTING SYSTEM No proper online management of system Human effort is needed. It is difficult to maintain important information in books. More manual hours need to generate required reports. 2.4 PROPOSED SYSTEM The proposed system is defined to meets all the disadvantages of the existing system. It is necessary to have a system that is more user friendly and user attractive for growth of service center; on such consideration the system is proposed. In our proposed system there is admin who can view all the customers. It allows customers to make their service booking and do their transactions by using online payment method .Users of this proposed system are admin and customer. The software application which avoids more manual hours that needs to spend in record keeping and generating reports. This application keeps the data in a centralized way which is available to all the users simultaneously. It is very easy to manage historical data in database. No specific training is required for the distributors to use this application. They can easily use the tool that decreases manual hours spending for normal things and hence increases the performance. It is very easy to record the information of online sales and purchases in the databases
CASA DECOR^6 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications
The system is very simple in design and to implement. The system requires very low system resources, and the system will work in almost all configurations. It has got following features: Better security: - For data to remain secure measures must be taken to prevent unauthorized access. Security means that data are protected from various forms of destruction. The system security problem can be divided into four related issues: security, integrity, privacy and confidentiality. Username and password requirement to sign in ensures security. It will also provide data security as we are using the secured databases for maintaining the documents. Ensure data accuracy: - The proposed system eliminates the manual errors while entering the details of the users during the registration. Better service: - The product will avoid the burden of hard copy storage. We can also conserve the time and human resources for doing the same task. The data can be maintained for longer period with no loss of data.
CASA DECOR^8 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications
Feasibility study is made to see if the project on completion will serve the purpose of the organization for the amount of work, effort and the time that spend on it. Feasibility study lets the developer foresee the future of the project and the usefulness. A feasibility study of a system proposal is according to its workability, which is the impact on the organization, ability to meet their user needs and effective use of resources. Thus, when a new application is proposed it normally goes through a feasibility study before it is approved for development. The document provides the feasibility of the project that is being designed and lists various areas that were considered very carefully during the feasibility study of this project such as Technical, Economic and Operational feasibilities. The following are its features: - 3.1.1 Economical Feasibility The developing system must be justified by cost and benefit. Criteria to ensure that effort is concentrated on project, which will give best, return at the earliest. One of the factors, which affect the development of a new system, is the cost it would require. The following are some of the important financial questions asked during preliminary investigation: The costs conduct a full system investigation. The cost of the hardware and software. The benefits in the form of reduced costs or fewer costly errors. The proposed system is developed as part of project work, there is no manual cost to spend for the proposed system. Also all the resources are already available, it give an indication of the system is economically possible for development. The cost of project, DREAMS was divided according to the system used, its development cost and cost for hosting the project. According to all the calculations the project was developed in a low cost. As it is completely developed using open source software.
CASA DECOR^9 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications 3.1.2 Technical Feasibility The system must be evaluated from the technical point of view first. The assessment of this feasibility must be based on an outline design of the system requirement in the terms of input, output, programs and procedures. Having identified an outline system, the investigation must go on to suggest the type of equipment, required method developing the system, of running the system once it has been designed. Technical issues raised during the investigation are: Does the existing technology sufficient for the suggested one? Can the system expand if developed? The project should be developed such that the necessary functions and performance are achieved within the constraints. The project requires High Resolution Scanning device and utilizes Cryptographic techniques. Through the technology may become obsolete after some period of time, due to the fact that newer version of same software supports older versions, the system may still be used. So there are minimal constraints involved with this project. The system has been developed using PHP in front end and MySQL in server in back end, the project is technically feasible for development. The system has been developed using PHP in front end and MySQL in server in back end, the project is technically feasible for development. The System used was also of good performance of Processor Intel i core; RAM 4GB and, Hard disk 1TB 3.1.3 Behavioral Feasibility The proposed system includes the following questions: Is there sufficient support for the users? Will the proposed system cause harm? The project would be beneficial because it satisfies the objectives when developed and installed. All behavioral aspects are considered carefully and conclude that the project is behaviorally feasible.
CASA DECOR^11 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications 3.3.2 MySQL MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL Web site provides the latest information about MySQL software.
CASA DECOR^12 Amal Jyothi College of Engineering, Kanjirapally Department of Computer Applications
