DATABASE DESIGN FOR COSPLAY MAKING SERVICE OUTLET SELECTION RECOMMENDATION SYSTEMS

This research is a type of action research. Aims to design a database for a costume ordering service outlet recommendation system. The application is built using the flutter framework as the user interface, the PHP language as a data processor that is sent from the application and MySQL as the database.A recommendation system is a system that is able to identify and provide high potential content selected by users based on filtering information that takes preferences from user behavior and history.The final result of the database design shows that the database design consists of 5 tables, namely the User Table, the Orderuser Table, the Outlet Table, the Rating Table, and the Review Table, as well as the Web-based Cosplay Making Service Outlet Selection Recommendation System.

How to search for items recommended to users can be done based on similarities, either in the form of the similarity of an item to another item based on content or the similarity of a user's tastes to other users based on the rating given to the item.
In the mid-1990s there was a lot of research on recommendation systems to find new approaches in overcoming problems arising from the flood of information on the internet (Adomavicisu and Tuzhilin, 2005). The recommendation system approach that is most commonly used in recommendation systems is the content-based filtering and collaborative filtering approaches. Both of these approaches have their respective advantages and disadvantages in recommending items to users, such as in content-based approach which recommends items only based on user history, so that the recommendation results tend to be monotonous, while collbarative filtering has problems when there is a new item. But both of them have the advantage in certain cases concerning the problem of time efficiency, accuracy of rating predictions, etc..
Based on the recommendation method that is often used, the recommendation system is divided into several classifications, namely: content-based recommendation, collaborative-based recommendation and hybrid-based recommendation and some researchers add the knowledge based recommendation method..

Ordering
Ordering is an activity carried out by consumers before buying. To achieve customer satisfaction, the company or place of business must have a good ordering system. According to the Big Indonesian Dictionary, what is meant by ordering is "the process, action, how to order (place, goods, etc.) to other people".
Booking in a general sense is a place reservation agreement between 2 (two) or more parties, the reservation agreement can be in the form of an agreement for the reservation of a room, room, seat, etc., at a certain time and accompanied by its service products. The service product in question is the service offered in the reservation agreement, such as in an airline company or shipping company is the movement of people or objects from one point (city) to another (city)..

Software Requirement Analysis Model
The process of gathering needs is intensified and focused, in particular on software, in order to understand the nature of the program being built, the software engineer (analyst) must understand the information domain, behavior, performance and interface required..

Design
Software design is actually a multi-step process that focuses on four distinct attributes of a program; data structures, software architectures, interface representations, and procedural details (algorithms). D. Design code generation should be translated into machine readable form. In research using the PHP programming language to translate commands to be executed into machine language.

Coding
To be understood by a machine, in this case a computer, the design must be transformed into a form that can be understood by the machine, namely into a programming language through the coding process. This stage is the 805 implementation of the design stage which will be done technically by the programmer. At this stage, the researcher builds an application based on the "blueprint" design that has been made. This application development is carried out from the beginning until the application is ready to run.

Testing
The testing process focuses on the internal logic of the software, ensuring that all statements have been tested and on a functional external, that is, directing testing to find errors and ensuring that the constrained input will give actual results that match the required results..

Maintanance
Software maintenance applies each of the previous program phases and does not create new ones.

PHP
PHP stands for PHP Hypertext Preprocessor. PHP is used as a server-side scripting language in web development that is embedded in HTML documents. The use of PHP allows the web to be dynamic so that website maintenance is easier and more efficient. PHP is written in C language.
PHP has many advantages that are not shared by similar scripting languages. PHP is focused on creating server-side scripts, which can do anything CGI does, such as gathering data from forms, generating dynamic web page content, and the ability to send and receive cookies, even more so than CGI capabilities. PHP is not limited to output HTML (HyperText Markup Language). PHP also has the ability to process images, PDF files, and flash movies. PHP can also generate text like XHTML and other XML files.
One of the features that PHP can rely on is its support for many databases, one of which is MySQL.

MySQL and Database
On its official website at www.mysql.com, MySQL was originally founded and developed in Sweden. Development was undertaken by David Axmark, Allan Larsson, and Michael "Monty" Widenius, who have worked together since the 1980s.
MySQL (My Structured Query Language) is a multiuser database that uses the Structured Query Language (SQL). MySQL in client-server operations involves the MySQL server daemon on the server side and various programs and libraries that run on the client side. MySQL is also capable of handling large amounts of data. The company that developed MySQL, namely TcX, claims to be able to store data for more than 40 databases, 10 000 tables, and about 7 million rows.
SQL is the standard language used to access database servers. This language was originally developed by IBM, but has been adopted and used as an industry standard (Sunarfrihantono, 2002: 65).
MySQL can be run in two ways, namely through DOS and the PhpMyAdmin application. If using DOS, we must know and memorize the query syntax used in the MySQL programming. PhpMyAdmin is a dump program that is made like the web and runs under a database server and by using PhpMyAdmin we don't need to know the query syntax used (Nugroho, 2004: 29-31).
Database or database has the meaning of a file that coordinates data tables that are interconnected and have a common interest to form new information so that it will facilitate processing. The database has several terms, both in structure and command. Some of the terms that often appear are as follows: 1. Table :data sets in records consolidated for a particular interest. 2. Record: groups of fields grouped together in one row. 3. Field: the type or data type of a data item and its value limits.
In SQL, there are 3 sub languages, namely Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). DDL contains commands that are used to build the contents of the database, tasked with creating SQL objects and storing their definitions in tables. DML is used to display, modify, add, and delete rows in a table. DCL is used to help control the security of each database or part of the contents of the database by making certain access rights for each user (Ridwan, 2005: 39 -42).

806
Databases are important in data processing using computers, because they are the main components in information systems and determine the quality of information, namely fast, accurate, and relevant. Data in the database also needs to be compiled to overcome problems in data preparation. According to Supriyanto (2005: 194-195), the benefits, among others: 1. Resolve data duplication (redundant). 2. Avoid data inconsistencies. 3. Overcoming difficulties in accessing data. 4. Construct a standard format of data. 5. Ease in use by many users (multiple user). 6. Protect and secure data, and 7. Develop data integrity and independence.

Unified Modelling Language (UML)
Unified Modeling Language (UML) is a family of graphical notations that help research and design software, especially systems built using object-oriented programming. Unified Modeling Language (UML) is a tool, a modeling language that can be used for object-oriented design. UML can be used for specification, visualization and system documentation during the development phase. Although there are many other object-oriented modeling tools, UML is arguably the standard tool in modeling languages. This is proven by the acceptance of UML as a standard by the Object Management Group (OMG), the largest consortium in the field of business objects, so that UML is widely adopted and used by many software manufacturers.

Database Design Analysis Stage Data Analysis
Based on the analysis of table requirements and the required attributes, database design is as follows: 807 Review Data 1. Id Review 2. Review 3. Rating kualitas produk (Quality Product Review) 4. Rating Pelayanan (Service Rating) The software will be used by end users on a local network basis. From software analysis, it can be estimated that the software and hardware capacity needed so that the software can run properly is a unit of computer equipment which has installed Apache web server applications such as XAMPP and MySQL Database.

Database Analysis
The following is a model and