Show simple item record

dc.contributor.authorSuvo, Mohammad Mehedi Hossain
dc.contributor.authorKabir, Ahmed Imran
dc.date.accessioned2022-06-06T04:46:34Z
dc.date.available2022-06-06T04:46:34Z
dc.date.issued2022-06-05
dc.identifier.urihttp://dspace.uiu.ac.bd/handle/52243/2449
dc.description.abstractThis 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.en_US
dc.subjectDatabaseen_US
dc.subjectSQL Serveren_US
dc.subjectSQL Workbenchen_US
dc.subjectRelational Databaseen_US
dc.subjectSQL Queryen_US
dc.titleA Relational data model and database proposal for small firms in the retail sector of Bangladeshen_US
dc.typeProject Reporten_US


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record