![]() |
10.5120/ijca2018918095 |
Anfal A Fadhil. Build Tool to Generate Relational Database from Class Diagram. International Journal of Computer Applications 181(31):14-17, December 2018. BibTeX
@article{10.5120/ijca2018918095, author = {Anfal A. Fadhil}, title = {Build Tool to Generate Relational Database from Class Diagram}, journal = {International Journal of Computer Applications}, issue_date = {December 2018}, volume = {181}, number = {31}, month = {Dec}, year = {2018}, issn = {0975-8887}, pages = {14-17}, numpages = {4}, url = {http://www.ijcaonline.org/archives/volume181/number31/30185-2018918095}, doi = {10.5120/ijca2018918095}, publisher = {Foundation of Computer Science (FCS), NY, USA}, address = {New York, USA} }
Abstract
UML has been accepted in both academia and industry as a de facto modeling language to develop software systems. As relational databases are widely used for developing software systems, thus, it is a challenge to derive relational tables from designed models ,In this paper, is building tool in C# language to designing a relational database system based on Object Oriented Analysis and Design that class diagram, by create the document xml that extract from class diagram, based on class name, attributes name , data type the relationships among the classes, multiplicity, Inheritance , And this concepts are not supported in the relational database Therefore , use is algorithm and rules to translate the relational database
References
- S. Mohd ,R. Parit, Proposal for Constructing Relational Database from Class Diagram, Vol. 3, No. 2; May 2010
- Sparx Systems, Database Models,2017
- A. Mohd,A.Nur, TRANSFORMING OBJECT ORIENTED DATA MODEL TO RELATIONAL DATA MODEL, International Journal on New Computer Architectures and Their Applications (IJNCAA) 2(3): 402-409 The Society of Digital Information and Wireless Communications, 2012 (ISSN: 2220-9085)
- E.Rames , FUNDAMENTALS OF Database Systems SIXTH EDITIO,2011
- He, Y.L., Ying, Z.L., and Zhang, Y.W. (2002). The Design and Implementation of a Multimedia Database with Object Oriented Analysis and Design Method. Proceeding of 6th International Conference 9 (ICSP '02). IEEE Press, 1035-1038.
- Alsaadi, A, Checking Data Integrity via the UML Class Diagram,2006, Proceeding of International Conference on Software Engineering Advances (ICSEA 06) , IEEE
- Ali, N.H., Shukur, Z., and Idris, S, A Design of an Assessment System for UML Class Diagram,2007, Proceeding of 5th International Conference Computational Science and its Applications. IEEE
- M. Farzaneh ,R . Vahid,J. Shahram,From Class Diagrams to Relational Tables: A Graph Transformation-based Approach ,2011,PRZEGLĄD ELEKTROTECHNICZNY (Electrical Review), ISSN 0033-2097, R. 87 NR 8/2011
- T.Connolly ,C. Begg, Database System A Practical Approach to Design, Implementation, and Management, Addison Wesley ,2010
- Rob, Peter and Coronel, C ,Database Systems: Design, Implementation, and Management, Eighth Edition. Course Technology, Boston MA,2009
- S. Vipin ,P.Ajay, Transformation of UML Class Diagram for Object Oriented Database System, International Journal of Computer Applications (0975 – 8887) Volume 26– No.10, July 2011
- M.Russ , H. Kim, learning uml 2.0, 2015
- K. Wilailuk, L.somchai, An Adaptive Translation of Class Diagram to Relational Database, IEEE, 2009
Keywords
Class diagram, XMl, Relational Database ,Relationship C# language