RELATIONAL DATABASE STUCTURE AND OPERATIONS CONSTRUCTION USING CLASS DIAGRAM DAN ACTIVITY DIAGRAM

• Main Author: Hakim - NIM: 23515045 , Lukman
• Format: Theses
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/28654
• Institution: Institut Teknologi Bandung

<p align="justify">The software system plays an important role especially for processing large amounts of data. Currently the operation of a data is mostly done on the application layer, so the DBMS only serves to store data processing results. Data processing on the DBMS layer will result in better performance, as it is closer to the physical data. Application of constraints as well as data access rights at the DBMS level will apply consistently to the system as a whole so as to maintain data integrity. In this research, UML-based approach is proposed to map the structure and operation in a domain model into the structure and operation of relational database. A software will be built using a driven architecture model (MDA) to automate the transformation from UML to SQL script. Class Diagrams that describe the domain structure of the model will be mapped into the table structure on the relational database, while the Activity Diagram that describes the behavioral aspects of a domain model will be mapped into procedure and function. It is expected that this research can simplify the process of database schema development, increase data processing speed and maintain data integrity.<p align="justify"> <br />