Call for Paper - January 2023 Edition
IJCA solicits original research papers for the January 2023 Edition. Last date of manuscript submission is December 20, 2022. Read More

Build Tool to Generate Relational Database from Class Diagram

Print
PDF
 
Download Full Text
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 181 - Number 31
Year of Publication: 2018
Authors:
Anfal A. Fadhil
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

  1. S. Mohd ,R. Parit, Proposal for Constructing Relational Database from Class Diagram, Vol. 3, No. 2; May 2010
  2. Sparx Systems, Database Models,2017
  3. 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)
  4. E.Rames , FUNDAMENTALS OF Database Systems SIXTH EDITIO,2011
  5. 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.
  6. Alsaadi, A, Checking Data Integrity via the UML Class Diagram,2006, Proceeding of International Conference on Software Engineering Advances (ICSEA 06) , IEEE
  7. 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
  8. 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
  9. T.Connolly ,C. Begg, Database System A Practical Approach to Design, Implementation, and Management, Addison Wesley ,2010
  10. Rob, Peter and Coronel, C ,Database Systems: Design, Implementation, and Management, Eighth Edition. Course Technology, Boston MA,2009
  11. 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
  12. M.Russ , H. Kim, learning uml 2.0, 2015
  13. K. Wilailuk, L.somchai, An Adaptive Translation of Class Diagram to Relational Database, IEEE, 2009

Keywords

Class diagram, XMl, Relational Database ,Relationship C# language