A Relational data model and database proposal for small firms in the retail sector of Bangladesh

Abstract

This project paper attempts on analyzing through market research and digital trends to create a data model and corresponding database for small firms in the retail sector of Bangladesh. In order to create a sustainable data model alongside its corresponding database, a relational data model was used in order to create an acceptable and sustainable database that in return will serve the small firms that cannot purchase and maintain an expensive and complex database. The key tables that were used to create a relational database are “city”, “address”, “staff”, “store”, “customer”, “payment”, “products”, “product_category”, “inventory”, and finally a supporting table named “category” to support the “product_category” table. The data model was created in way which will support expandability according a firm’s choice. Each of table consists of supporting attributes and one or multiple primary attribute keys are used to connect the relational data model. The software used to create data model and deploy the model to evolve into a database system is “MYSQL” software. “MYSQL Workbench” can the primary workbench used to retrieve, update, remove and/or enter data in the deployed database to sustain and/or manipulate the database. “MYSQL” uses a specific type of coding language, also called as ‘query’, that can be used to manipulate data according to the individual in charge of the database. The relational database created will have a forward engineering codebase as well as the relational model which can be used by any organization, big or small. With the use of MySQL package (workbench, server, shell) the organization can create a database and data server of their business and use the workbench to alter the tables, create, update and delete data according to the organization’s preference.