Database Designer

The database designer role defines tables, indexes, views, constraints, triggers, stored procedures, tablespaces, storage parameters, and other database-specific structures required for storing, retrieving, and deleting persistent objects. This information is retained in the deliverables: data model.

System architecture including database and system performance tuning, hardware and network workload balance

Conceptual database design is a difficult task for novice database designers (students, etc.), so it is a particularly challenging task for database educators. In the design of the database design, two common ways of top down and bottom up are often emphasized. In this paper, we examine the performance of students in these two methods empirically in a conceptual data modeling exercise. Our results show that previous database education has a great influence on the quality of design performance, but the selected method is not so. The results of this survey show that database educators need to integrate top-down and bottom-up approaches into database design. This shows the differences and similarities between the two approaches. Keywords: data model, entity relationship diagram, relationship model, normalization

Database design is the process of generating a detailed data model of the database. This data model contains all necessary logical and physical design choices and physical storage parameters necessary to generate the design in the data definition language and can be used to create the database. The full attribute data model contains detailed attributes for each entity. The term database design can be used to describe various parts of the overall database system design. In principle, and most accurately, it can be thought of as the logical design of the underlying data structure used to store the data. In the relational model, these are tables and views. In the object database, entities and relationships are directly mapped to object classes and naming relationships.

In most application development projects, the technology used to persist data is a relational database. Database designers are responsible for defining detailed database designs, including tables, indexes, views, constraints, triggers, stored procedures, and other database-specific structures necessary for storing, retrieving, and deleting persistent objects. This information is retained in the deliverables: data model.