Database Design for Customer Retention and Loyalty Administration Information System

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.