Computer Science · Database Management Systems

A teacher uses problem-based learning while teaching database management. Students are given messy data from a school survey and asked to design a system that can store, filter, and retrieve information. Before writing SQL queries, groups brainstorm how many tables are needed, relationships among them, and potential anomalies. They also justify why certain attributes should be primary keys. After planning, they start implementing the schema and test their sample queries. The phase where students justify primary key selection best reflects which cognitive process?