Who should be in charge of designing the database – team members, who understand

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

Answer)The incharge of designing the database should always be the database design expert. Being an expert, he/she knows the right way to design a particular database. What are the things which needs to be included in the database and what are not to be included. The responsibilty of the team members is to follow the instruction provided by the design expert. If the team members are given te power to design than there will be a lot of collisions in between the ideas of each individuals and may lead to delay in the overall progress. Thus a database design expert is the only one who should be incharge of the whole project. On using various test cases and running different queries in different scenarios on the provided database design, they can check whether the database is responding properly or not, if not what are the things that need to be changed or updated to run it smoothly. The database should use various encryption schemes for storing the data so that no unauthorised users or third party can have access to the provided data. One should use the procedure of providing usernames and passwords for the users without which no one can login to the database tp access the stored data. The whole of the data needs to be secured as it may contain a lot of personal stuff which when get leaked may lead to some serious damage to an individual or a firm. Therefore proper security measures should be taken to make it secure.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.