A key element to the usability of data is the design of the database it resides in. Correctly designed, one…