Concept hierarchy generation based on the number of distinct values per attribute. Suppose the registrar of Business College selects a set of location-oriented attributes for some students of MIS programstreet, country, province or state, and cityfrom the university management information systems database i.e., Academia database, but does not specify the hierarchical ordering among the attributes. Note: Assume some random values for each attribute. Required: 1.How a concept hierarchy for location can be generated from the academia database for the processing students? 2.Sort the attribute in ascending order based on the number of distinct values of each attribute for the students location. 3.Generate the hierarchy from the top down according to the sorted order, with the first attribute at the top level and the last attribute at the bottom level based on attribute values.