Nia Rahma Kurnianda, International Journal of Computer Science and Mobile Computing, Vol.7 Issue.10, October- 2018, pg. 1-8 © 2018, IJCSMC All Rights Reserved 1 Available Online at www.ijcsmc.com International Journal of Computer Science and Mobile Computing A Monthly Journal of Computer Science and Information Technology ISSN 2320–088X IMPACT FACTOR: 6.017 IJCSMC, Vol. 7, Issue. 10, October 2018, pg.1 – 8 Database Design for Customer Retention and Loyalty Administration Information System Nia Rahma Kurnianda Faculty of Computer Science, Universitas Mercu Buana, Jakarta, Indonesia nia.rahma@mercubuana.ac.id Abstract — In an administrative information system, of course a database will be the main pillar in supporting system operations. However in designing a database for a system there are several stages that become the basis for determining the scope of the database to support optimally and efficiently. in this study, The author tries to explain the steps taken in carrying out database design that is suitable for the business needs of PT XYZ and uses design steps such as ERD, LRS, Normalization, Code design, database specification design in order to support PT XYZ's activities in running customer retention and loyalty administrative operations. Keywords — Database Design, Administration IS, Customer Retention and Loyalty, Normalization, Code Design. I. INTRODUCTION The ability of an information system cannot be separated from the influence of efficiency and optimization of a database. In maintaining the quality of an information system, a database must be carefully designed to fit the needs and business functions of an organization. However, to design an optimal database requires several stage to be taken. Building a database is the first step in making an application. Success in building a database will make the program easier to read, easy to develop and easy to follow the development of software. The following are the components contained in the database, namely: Tables, Fields, Records, Primary Key, Foreign Key and Index [1] . This study aims to explain how to design an appropriate database by using stages such as elaborating ERD, LRS, Normalization, Database Specifications and Code Design in a case study of PT XYZ's customer retention and loyalty information system needs. Then to make it easier for readers to follow the flow of this research, we represent the results of this study into 5 parts, namely I. Introduction, reviewing the background, problems, objectives and systematic of writing. II. Fundamental Theories, reviewing the related theories used in this study, III. Methods, which describes the methods used in the study, IV. Discussion, which is describing the database design conducted and V. Conclusions, describes the conclusions obtained after the implementation of the research