As part of project for course in Advanced Database Modeling in Masters in Science (IT) from Lindner College of Business, University of Cincinnati under Prof. Umanath
Course required us to develop an industry driven case on database modeling. The idea was to design and implement business model of any fictitious organization. The project offered first-hand experience developing concepts like ER modeling, physical database design, representation of business using conceptual model etc.
We developed a fictitious story. The story involved gathering requirements and then developing a database model for a FMCG company (fast moving consumer goods). In a gist, the company planned to integrate its sales, marketing, research and manufacturing departments under one single system. Building a single database was one of the challenges towards this goal.