Database Design Methodology and Database Management System for Computer-Aided Structural Design Optimization.

Author(s):  
T. S. Murthy ◽  
J. S. Arora
Author(s):  
Dolores Cuadra ◽  
Paloma Martinez ◽  
Elena Castro

Database modelling is a complex task that involves conceiving, understanding, structuring and describing real universes of discourse (UD) through the definition of schemata using abstraction processes and data models. Traditionally, three phases are identified in database design: conceptual, logical and physical design. The conceptual modelling phase represents the most abstract level since it is independent of any database management system (DBMS) and, consequently, it is very close to the user and allows him/her to collect almost completely the semantics of the real world to be modelled.


2020 ◽  
Vol 2 (1) ◽  
pp. 61-68
Author(s):  
R Bagus Bambang Sumantri ◽  
Fajar Mahardika

Data processing to produce a computerized information is a tool that needed at this time in various types of business because the information capable presented within quickly and accurately time. Information which capable of quickly and accurately presented can produce quickly and effective decision but the database design that applied in a database management system is no less important Good database design will facilitate the implementation of aplications and optimize the performance of the database manajemen system itself.


Author(s):  
Marina Makhmutova ◽  
Novik Novik

The article discusses the possibilities of using modeling tools at the stages of database design. Database design is one of the most complex and crucial tasks associated with the creation of an automated information system. As a result of solving this problem, the content of the database should be determined, an effective way for organizing data for all its future users, and data management tools. The main goal of this stage is to develop such a database scheme that it includes the necessary and sufficient data on information objects, their properties and relationships in accordance with the objects of the subject area and the processes of their transformation. The authors present the results of using modeling tools to solve the problems of the database design stage. Creating models is considered from the point of view of three-circuit architecture, the main principle of which is abstraction. To display the levels of data presentation, three related models have been developed: an external data model that displays the representations of each type of user existing in the organization (description of the subject area); a conceptual data model that displays a logical (or generalized) idea of data, independent of the type of database management system selected; an internal data model that displays the conceptual diagram in a specific way that is understandable to the selected target database management system. As an example of a subject area, the activity of a school of foreign languages is considered, namely, the registration of students in a school. The main problem is the large amount of information that is processed manually: paper forms of clients are drawn up, reports on the implementation of work are manually generated and filled out. It is necessary to develop a draft database for the registration of students of a school of foreign languages and to further implement it in the environment of the selected database management system.


Sign in / Sign up

Export Citation Format

Share Document