Analysis and Design Complex and Large Data Base using MySQL Workbench

This study will be demonstrated on how to conduct analysis and design in building a large and complex data base. The data in this study originated from the Attachment to the Decree of the Minister of Manpower and Transmigration (Kepmenakertrans) No. 250/MEN/XII/2008, namely the attachment of AF, which consists of 800 tables of data. Due to the large data base which will be formed because so many tables involved then the process is required - the normalization process (functional dependence, Normal Normal First, Second, Third and Boyce-Codd) in forming a good database that can later be used for purposes further, for example, form a management information system and so forth.In the process DBMS MySQL and MySQL Workbench is a tool used to facilitate this process in shaping the Entity relational diagram. By utilizing these tools will help data base engineer in designing a good and normal data base. It is expected that the formulation of the data base will be used as a standard in designing applications of manpower information systems across the provinces in Indonesia.