1. Define 3 groups for the database from the below dataset with different reasons to access the data.
2. Define who would belong to these groups
3. Create these groups with the permissions you defined above using one of the following:
   1. Use only SQL code
   2. Use PostgreSQL to create the groups and users.

CoursHeroTranscribedText

Transcribed Image Text:

O > public flat_detalle flat_id integer flat type character varying property_type character var ying number_of_levels integer year date seller_buyer character vary ing number_of_units character varying oneroom_flats_sold integer tworoom_flats_sold integer property_id integer threeroom_flats_sold integ er fourroom flats sold integer multi_generationflats sold nteger fiveroom_flats_sold intege r integer executiveroom_flats sold i nteger studioapt sold integer singleroom_rental integer doubleroom_rental integer tripleroom_rental integer multiroom_rental integer available total integer O public hdb property_id integer block_no integer property_type character var ying flat type character varying number_of_levels integer carparking levels boolean town_legend character var ying year date sales person character var ying salesperson name charact er varying Salesperson_reg_num inte O > public ger property_flatdetalle flat_id integer property_type character var ying status_sold_rented charact er varying number_of_units integer flat type character varying number_of_units sold inter ger n number_of_units_rented int eger an residential property boolea commercial property boole property_id integer available total integer + + O public hdb_saleedetalle salesperson_reg_num inte ger transaction_date date salesperson_name charact er varying transaction_type character varying seller_buyer character vary ing town character varying district character varying general_location character varying flat_id integer O > public flat_detalle flat_id integer flat type character varying property_type character var ying number_of_levels integer year date seller_buyer character vary ing number_of_units character varying oneroom_flats_sold integer tworoom_flats_sold integer property_id integer threeroom_flats_sold integ er fourroom flats sold integer multi_generationflats sold nteger fiveroom_flats_sold intege r integer executiveroom_flats sold i nteger studioapt sold integer singleroom_rental integer doubleroom_rental integer tripleroom_rental integer multiroom_rental integer available total integer O public hdb property_id integer block_no integer property_type character var ying flat type character varying number_of_levels integer carparking levels boolean town_legend character var ying year date sales person character var ying salesperson name charact er varying Salesperson_reg_num inte O > public ger property_flatdetalle flat_id integer property_type character var ying status_sold_rented charact er varying number_of_units integer flat type character varying number_of_units sold inter ger n number_of_units_rented int eger an residential property boolea commercial property boole property_id integer available total integer + + O public hdb_saleedetalle salesperson_reg_num inte ger transaction_date date salesperson_name charact er varying transaction_type character varying seller_buyer character vary ing town character varying district character varying general_location character varying flat_id integer