List some of the criteria for making a Good Data Model?

 Posted by Niladri.Biswas on 9/12/2012 | Category: Design Pattern & Practices Interview questions | Views: 4515 | Points: 40
Answer:

Completeness: Does the model support all the necessary data?

Nonredundancy : Does the model specify a database in which the same fact could be recorded more than once?

Enforcement of Business Rules : How accurately does the model reflect and enforce the rules that apply to the business data?

Data Reusability: Will the data stored in the database be reusable for purposes beyond those anticipated in the process model?

Stability and Flexibility: How well will the model cope with possible changes to the business requirements? Can any new data required to support such changes be accommodated in existing tables?

Elegance Does the data model provide a reasonably neat and simple classification of the data?

Integration How will the proposed database fit with the organization’s existing and future databases?


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response