E-resources
Peer reviewed
Open access
-
Mladenović, Monika; Vicković, Tina
Politehnika, 06/2023, Volume: 7, Issue: 1Journal Article, Paper
Modeliranje podataka je najvažniji dio dizajniranja baze podataka ali i cijelog informacijskog sustava. U procesu izrade relacijske baze podataka kreiranje modela podataka je ključno jer naknadne promjene na bazi podataka nisu poželjne. U prvoj fazi izrade uzimaju se specifikacije od korisnika koje služe za modeliranje podataka. Iz definiranih specifikacija izrađuje se model podataka koji se kreira u tri osnovne faze: izrada konceptualnog, logičkog i na kraju relacijskog, odnosno fizičkog modela. Dok se konceptualni model radi „na papiru“, odnosno skiciraju se osnovni entiteti, atributi i veze, izrada logičkog modela u često uključuje korištenje nekog alata za modeliranje podataka. Ovisno o alatu, iz logičkog modela se može napraviti i relacijski model koji se već smatra dijelom fizičke izrade baze podataka. Pri podučavanju baza podataka i modeliranja kao prve faze iznimno je važno odabrati alat koji je dovoljno jednostavan za studente ali i dovoljno složen da se lako može preslikati na realne sustave u praksi. U ovom radu se kroz izradu modela podataka za bazu podataka o zaposlenicima prikazuje proces izrade modela pomoću različitih alata. Prikazana je usporedba u mogućnostima i opcijama različitih alata za modeliranje, kako besplatnih tako i onih koji su dostupni uz plaćanje pri izradi baze podataka. Data modeling is the most important part of designing a database and an entire information system. In the process of creating a relational database, data modeling is crucial because making subsequent changes to the database is undesirable. In the first phase of development, user specifications are gathered to serve as a basis for data modeling. The defined specifications are used to create a data model, which is developed in three basic stages: conceptual, logical, and finally, relational or physical model. While the conceptual model is created "on paper," meaning that the basic entities, attributes, and relationships are sketched out, the creation of the logical model often involves the use of a data modeling tool. Depending on the tool, the logical model can be transformed into a relational model, which is considered part of the physical implementation of the database. When teaching databases and modeling, it is extremely important to choose a tool that is simple enough for students to understand, yet complex enough to be easily applied to real-world systems in practice. This paper presents the process of creating a data model for an employee database using different tools. A comparison of the capabilities and options of various modeling tools is shown, including both free tools and those available for purchase when building a database.
![loading ... loading ...](themes/default/img/ajax-loading.gif)
Shelf entry
Permalink
- URL:
Impact factor
Access to the JCR database is permitted only to users from Slovenia. Your current IP address is not on the list of IP addresses with access permission, and authentication with the relevant AAI accout is required.
Year | Impact factor | Edition | Category | Classification | ||||
---|---|---|---|---|---|---|---|---|
JCR | SNIP | JCR | SNIP | JCR | SNIP | JCR | SNIP |
Select the library membership card:
If the library membership card is not in the list,
add a new one.
DRS, in which the journal is indexed
Database name | Field | Year |
---|
Links to authors' personal bibliographies | Links to information on researchers in the SICRIS system |
---|
Source: Personal bibliographies
and: SICRIS
The material is available in full text. If you wish to order the material anyway, click the Continue button.