In Southy, every employee have a task to serve a customer who wants to buy a medicine and purchase medicines from vendor. Every employee must be following the procedures to become a employee, which are: Every employee hired must have a personal information like name, email, phone number, address, date of birth, gender, and salary. Every employee has an identification number with the following format: "EMXXX" X=> number between 0-9 Employee can purchase medicines from a vendor. . Every purchase transaction made with the vendor must have all the information about employee, vendor, transaction date, medicines purchased, and the quantity of each medicine. Every purchase transaction has an identification number with the following format: "PCXXX" X=> number between 0-9 Every medicine purchased from vendor must have some information about the medicine which are name, price, description, and stock. Every medicine has an identification number with the following format: "MDXXX" X=> number between 0-9 Every medicine has its own category data, and the category data has name and identification id with the following format: xxx X => number between 0 - 9 Employee can also serve a customer who wants to buy a medicine. Every sales transaction made by the customer have all the information about employee, customer, transaction date, medicines sold, and the quantity of each medicine. Every sales transaction has an identification number with the following format: "SLXXX X=> number between 0-9 Every medicine sold by Santhy must have some information about the medicine which are name, price, description, and stock Every medicine has an identification number with the following format "MDXXX" X=> number between 0-9 Every customer that wants to buy medicine at Southy must be following the sales transaction procedures, those are: Every customer that wants to purchase a product must already completed personal information like name, phone number, address, gender, email, password, and date of birth. Every customer has an identification number with the following format: "CUXXX" X=> number between 0-9 Customer can purchase more than one product in every transaction. Every vendor that wants to sell their medicine must be following the purchase transaction procedures, those are: . Every vendor that wants to sell their ingredient must already completed personal information like name, phone, address, email, and established year. Every vendor has an identification number with the following format: -VNXXX" X=> number between 0-9 vendor can sell more than one medicine in every transaction. Notes: Vendor name must be more than 3 characters. Customer email must ends with "@hallo.com" (without quote). . Employee email must ends with "Challo.com" (without quote). Vendor email must ends with ".com" (without quote). Customer gender must be either "Male" or "Female" (without quote). Employee gender must be either "Male" or "Female (without quote). Medicine price must be between 5000 and 100000. Category name must not be either "Amidopyrine", "Phenacetin", or "Methaqualone" (without quote)
