Prime objective of this case study is to explain on Database Design. Database design is the process of to become a detailed data model of a database. This logical data model contains the many needed logical in addition to physical design possibilities and physical storage parameters had to generate a design in a data definition words, which can after that be used to manufacture a database. A fully attributed data model is made up of detailed attributes for each and every entity. This case study briefly descrive transform a normalized logical data model into a physical, relational database schema.