Databases QUICKLY PLEASE PLEASE

FACULTY OF ENGINKAN INFORMATION TECHNOLOGY DEPARTMENT OF GEOGRAPGCOORMARLON SYNTEM QUESTION NO. 21 MB A) Use Postgresql to create the following tables for a pharmacy with specifying the primary keys for each table: Hint: add all required data type for tables attributes. Medicine ID, mname, m cost Buyers ID, B_name, billid Bills: [ID. byer id, med_id, cost B) Insert data for each table (just 3 rows) c) Create a Query showing the name of the medicine name, the name of the buyer, and the cost of the bill Tables: ID 1 2 a Medicine table m name Paramal Trufen Zero cost 5 10 30 10 1 2 3 Buyers B_name bill_id Ahmad 2 All 1 Salma 3 ID byer ld 1 2 2 1 3 Bills med id 2 1 2 cast 25 18 25