Overview and Comparison of Several elational Database Modelling Metodologies and Notations

Puja, I.; Poščić, Patrizia; Jakšić, Danijela

doi:10.23919/mipro.2019.8756667

Cited by 2 publications

(2 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The model is still popular and widely used for conceptual modelling of databases as well as teaching and learning the database design process. (some recent examples for its use, in practice and research, are: [18][19][20]).…”

Section: A Significance Of the Researchmentioning

confidence: 99%

ER Model Partitioning: Towards Trustworthy Automated Systems Development

Pieris¹,

Wijegunesekera²,

Dias³

2020

IJACSA

View full text Add to dashboard Cite

In database development, a conceptual model is created, in the form of an Entityrelationship(ER) model, and transformed to a relational database schema (RDS) to create the database. However, some important information represented on the ER model may not be transformed and represented on the RDS. This situation causes a loss of information during the transformation process. With a view to preserving information, in our previous study, we standardized the transformation process as a one-to-one and onto mapping from the ER model to the RDS. For this purpose, we modified the ER model and the transformation algorithm resolving some deficiencies existed in them. Since the mapping was established using a few real-world cases as a basis and for verification purposes, a formal-proof is necessary to validate the work. Thus, the ongoing research aiming to create a proof will show how a given ER model can be partitioned into a unique set of segments and use it to represent the ER model itself. How the findings can be used to complete the proof in the future will also be explained. Significance of the research on automating database development, teaching conceptual modeling, and using formal methods will also be discussed.

show abstract

Section: A Significance Of the Researchmentioning

confidence: 99%

ER Model Partitioning: Towards Trustworthy Automated Systems Development

Pieris¹,

Wijegunesekera²,

Dias³

2020

IJACSA

View full text Add to dashboard Cite

show abstract

“…A conceptual data model is a data model that is very close to the business domain. A conceptual data model is generally represented in the form of ERD (Entity Relationship Diagram) with Peter Chen notation excelling in support and intuitiveness [10], [11]. Meanwhile, a logical data model is a fully normalized data model and closely related to the physical data model.…”

Section: Introductionmentioning

confidence: 99%

Relational Data Model on The University Website with Search Engine Optimization

Alifi

Hayati²,

Wonoseto³

2022

IJID

View full text Add to dashboard Cite

The visibility of a university’s website on the search engine becomes an essential factor to reach a wider audience. One way to improve the visibility of a website is through Search Engine Optimization (SEO). University’s website development with SEO is inseparable from the data model because SEO supporting factors are parts of the consideration in the components and structure of the data model. This study aims to build a data model for a university website accompanied by SEO. The relational data model is used in this study based on the performance and maturity in defining schema-based design. This study was conducted through four sequential stages: literature review, planning, implementation, and evaluation. The resulting relational data model is one that has accommodated four supporting factors for SEO, namely Meta description, Meta keywords, URL structure, and image description. This study has succeeded in building a relational data model at the abstraction level of conceptual and logical. In the conceptual data model, one entity and 11 attributes are formed. The logical data model was implemented in independent work environments using RelaX and operational requirements can be fulfilled by representing each table or relationship in the schema using relational algebra.

show abstract

Overview and Comparison of Several elational Database Modelling Metodologies and Notations

Cited by 2 publications

References 0 publications

ER Model Partitioning: Towards Trustworthy Automated Systems Development

ER Model Partitioning: Towards Trustworthy Automated Systems Development

Relational Data Model on The University Website with Search Engine Optimization

Contact Info

Product

Resources

About