Who should be in charge of designing the database – team members, who understand
ID: 3815093 • Letter: W
Question
Who should be in charge of designing the database – team members, who understand the application requirements, or a database design expert, who may not understand the problem domain issues but does understand good database design? How can the team verify that the solution is correct and, more difficult, that it is efficient? Another interesting combination of both database and integrity is how to design and implement so that the database is secure from injection attacks? What kind of encryption should be used within the database? What data needs to be secure?
Explanation / Answer
The designing of databases and associated applications are very important for the success of the latest projects. The database designer should understand the operational and end user requirements and have the ability to model and realize the requirements using database. The developing of database and information systems carries out using a development lifecycle and it consists of a series of steps.
The most important part of specification is the gathering and compilation of system and end user requirements and this process normally doing in conjunction with managers and end users. The major thing in requirements information gathering is to collect the data used by the organization, identify relationships in the data, identify future data needs and determine how the data is generated and used.
The starting place for data collection is gathering existing forms and reviewing policies and systems, then ask users the meaning of these data and determine their daily processes. These are mostly important that identification of unique fields (keys), data dependencies, relationships and constraints (high-level), and the data sizes and their growth rates. The fact-finding is doing through interviews and questionnaires to collect facts about systems, requirements, and preferences.
The requirement information gathering and specification provides a high-level understanding of the organization, its data, and the processes that must be model in the database. The database design involves constructing a suitable model of this information, since the design process is complicated for large databases and database design is divided into phases as conceptual database design, logical database design and physical database design. The conceptual database design technique involves modeling of the collected information at a high-level of conceptual without using any particular data model or DBMS.
The above stated steps involved during and for the designing of a database, hence the Database Design Expert should be the in-charge and he must capable of, and understanding all the end user requirements through information gathering and fact-finding, and as a Database Design Expert he must be well aware of security and integrity of the database.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.