When designing a database, one needs to have an understanding of the needs of the data that will be stored. In other words, a designer needs to know how to abstract the real world concepts and qua…