Database Systems MYSQL

GunShin Impact GunShin Impact is a new game developed by MiZoyo. GunShin Impact has features where user can get character with gacha by paying some primogems and get some primogems by topup with real money. In order to track all player activities, MiZoyo has created a database system that stores player data such as gacha and topup. The database data has following procedures which are: - Every player data must have name, gender, email, date of birth (DOB), and phone number. They also need ID for identification with following format - Player can buy primogems bundle from shop. - The shop needs to have a name an identification number with the following format: - Every Topup header made by with the shop have all information about the player, shop, topup date, and an identification number with the following format: - Every Topup header can have one or more than one Topup detail. - Every Topup detail has all the information about the primogems bundle. - Every primogems bundle purchased from the shop have data of how many primogems in it, the bundle price, and an identification number with the following format: - Player who wants to gacha to get character has to choose a gacha bundle. - Every gacha bundle have data of how many gacha count it contains, the price, and an identification number with the following format: - Player who wants to gacha to get character has to choose a gacha bundle. - Every gacha bundle have data of how many gacha count it contains, the price, and an identification number with the following format: - Every Gacha header made by players have all information about the player, the gacha bundle, the gacha date, and an identification number with the following format: - Every Gacha header can have one or more than one gacha detail. - Every Gacha detail have all the information about the characters obtained. - Characters in GunShin Impact have information such as name, level that indicated by the number of stars, element type, and an identification number with the following format: - Element Type have information about its name and an identification number with the following format: Notes: - Player gender must be either 'Male' or 'Female' (without quote). - Player email must end with '@gemzhin.com' (without quote). - Player phone number must start with Indonesia phone number code (+62). - Player phone number length must between 11 and 16. - Character star must between 4 and 5. - Each Gacha transaction and Topup transaction year must occurred in 2000 or later