Topic: DATABASE SYSTEM AND INFORMATION RETREVAL

Read the following case study:

you may propose 1 possible database project which you intend to in Local handicrafts in tourism management. Currently there are many local crafters who are in bad shape due to the pandemic and movement restrictions by the government. The local crafters usually sell handicrafts at tourist spots which they have to pay rent for shops and depend on the tourists present at the spots. They produce handicrafts like ceramic, batik, pottery, paintings, souvenirs which are a hit among foreign tourist. However since the border is still closed which means there are no incoming foreign tourist to purchase. What database system that can you suggest to improve the sales of these local handicrafts among local tourist and also foreign tourist in the world?

Draw an Enhanced Entity Relationship (EER) diagram for conceptual data model based on requirements above. Make sure you clearly state the relation name, attribute (at least three), multiplicity, primary key, specialization or generalization and participation constraints. Steps and documentation for the diagram must strictly follow Unified Modelling Language (UML) notation. State any assumptions necessary to support your design.