{"id":"https://openalex.org/W4390490888","doi":"https://doi.org/10.1145/3636243.3636254","title":"A Qualitative Study of Novice Experiences with Database Normalisation","display_name":"A Qualitative Study of Novice Experiences with Database Normalisation","publication_year":2024,"publication_date":"2024-01-02","ids":{"openalex":"https://openalex.org/W4390490888","doi":"https://doi.org/10.1145/3636243.3636254"},"language":"en","primary_location":{"id":"doi:10.1145/3636243.3636254","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3636243.3636254","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 26th Australasian Computing Education Conference","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064021166","display_name":"Asanthika Imbulpitiya","orcid":"https://orcid.org/0000-0003-3730-7252"},"institutions":[{"id":"https://openalex.org/I39854758","display_name":"Auckland University of Technology","ror":"https://ror.org/01zvqw119","country_code":"NZ","type":"education","lineage":["https://openalex.org/I39854758"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Asanthika Imbulpitiya","raw_affiliation_strings":["School of Engineering, Computer and Mathematical Sciences, Auckland University of Technology, New Zealand"],"raw_orcid":"https://orcid.org/0000-0003-3730-7252","affiliations":[{"raw_affiliation_string":"School of Engineering, Computer and Mathematical Sciences, Auckland University of Technology, New Zealand","institution_ids":["https://openalex.org/I39854758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007734757","display_name":"Jacqueline Whalley","orcid":"https://orcid.org/0000-0001-7633-5200"},"institutions":[{"id":"https://openalex.org/I39854758","display_name":"Auckland University of Technology","ror":"https://ror.org/01zvqw119","country_code":"NZ","type":"education","lineage":["https://openalex.org/I39854758"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Jacqueline Whalley","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auckland University of Technology, New Zealand"],"raw_orcid":"https://orcid.org/0000-0001-7633-5200","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auckland University of Technology, New Zealand","institution_ids":["https://openalex.org/I39854758"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018698235","display_name":"Mali Senapathi","orcid":"https://orcid.org/0000-0003-3083-8069"},"institutions":[{"id":"https://openalex.org/I39854758","display_name":"Auckland University of Technology","ror":"https://ror.org/01zvqw119","country_code":"NZ","type":"education","lineage":["https://openalex.org/I39854758"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Mali Senapathi","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auckland University of Technology, New Zealand"],"raw_orcid":"https://orcid.org/0000-0003-3083-8069","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auckland University of Technology, New Zealand","institution_ids":["https://openalex.org/I39854758"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4322,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.61784136,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"94","last_page":"103"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11516","display_name":"Visual and Cognitive Learning Processes","score":0.9900000095367432,"subfield":{"id":"https://openalex.org/subfields/3205","display_name":"Experimental and Cognitive Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11516","display_name":"Visual and Cognitive Learning Processes","score":0.9900000095367432,"subfield":{"id":"https://openalex.org/subfields/3205","display_name":"Experimental and Cognitive Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10636","display_name":"Innovative Teaching and Learning Methods","score":0.9855999946594238,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13083","display_name":"Advanced Text Analysis Techniques","score":0.9800999760627747,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/narrative","display_name":"Narrative","score":0.7777119874954224},{"id":"https://openalex.org/keywords/think-aloud-protocol","display_name":"Think aloud protocol","score":0.7534939050674438},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7238286733627319},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.7150193452835083},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5735386610031128},{"id":"https://openalex.org/keywords/protocol","display_name":"Protocol (science)","score":0.5167876482009888},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5010740756988525},{"id":"https://openalex.org/keywords/qualitative-research","display_name":"Qualitative research","score":0.49527278542518616},{"id":"https://openalex.org/keywords/protocol-analysis","display_name":"Protocol analysis","score":0.46255627274513245},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.42473727464675903},{"id":"https://openalex.org/keywords/qualitative-property","display_name":"Qualitative property","score":0.41033902764320374},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.343944251537323},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2754170298576355},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.2599344253540039},{"id":"https://openalex.org/keywords/cognitive-science","display_name":"Cognitive science","score":0.1926441788673401},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08851882815361023},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.08670052886009216}],"concepts":[{"id":"https://openalex.org/C199033989","wikidata":"https://www.wikidata.org/wiki/Q1318295","display_name":"Narrative","level":2,"score":0.7777119874954224},{"id":"https://openalex.org/C78821406","wikidata":"https://www.wikidata.org/wiki/Q391810","display_name":"Think aloud protocol","level":3,"score":0.7534939050674438},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7238286733627319},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.7150193452835083},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5735386610031128},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.5167876482009888},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5010740756988525},{"id":"https://openalex.org/C190248442","wikidata":"https://www.wikidata.org/wiki/Q839486","display_name":"Qualitative research","level":2,"score":0.49527278542518616},{"id":"https://openalex.org/C133112747","wikidata":"https://www.wikidata.org/wiki/Q7251931","display_name":"Protocol analysis","level":2,"score":0.46255627274513245},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42473727464675903},{"id":"https://openalex.org/C87156501","wikidata":"https://www.wikidata.org/wiki/Q7268708","display_name":"Qualitative property","level":2,"score":0.41033902764320374},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.343944251537323},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2754170298576355},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.2599344253540039},{"id":"https://openalex.org/C188147891","wikidata":"https://www.wikidata.org/wiki/Q147638","display_name":"Cognitive science","level":1,"score":0.1926441788673401},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08851882815361023},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.08670052886009216},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C36289849","wikidata":"https://www.wikidata.org/wiki/Q34749","display_name":"Social science","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.0},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3636243.3636254","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3636243.3636254","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 26th Australasian Computing Education Conference","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.8199999928474426,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W634639229","https://openalex.org/W1572092804","https://openalex.org/W1995529329","https://openalex.org/W2008157322","https://openalex.org/W2065276745","https://openalex.org/W2076623634","https://openalex.org/W2081354636","https://openalex.org/W2113666338","https://openalex.org/W2161091367","https://openalex.org/W2170445541","https://openalex.org/W2503030845","https://openalex.org/W2603990219","https://openalex.org/W2794951508","https://openalex.org/W2808963946","https://openalex.org/W2891229712","https://openalex.org/W2905785337","https://openalex.org/W2908434115","https://openalex.org/W3082121050","https://openalex.org/W3091843017","https://openalex.org/W3113028455","https://openalex.org/W3139017437","https://openalex.org/W3166608317","https://openalex.org/W4245652239","https://openalex.org/W4255697435","https://openalex.org/W4377087249"],"related_works":["https://openalex.org/W2188860261","https://openalex.org/W4299529040","https://openalex.org/W3188118552","https://openalex.org/W2125259630","https://openalex.org/W2016587816","https://openalex.org/W1795122992","https://openalex.org/W2108120676","https://openalex.org/W2127784610","https://openalex.org/W2793293581","https://openalex.org/W3120145260"],"abstract_inverted_index":{"This":[0],"research":[1],"paper":[2],"reports":[3],"on":[4,61],"the":[5,36,55,62,88,97,117,133],"experiences":[6],"of":[7,10,78,85,96],"three":[8],"novices,":[9],"different":[11],"capabilities,":[12],"attempting":[13],"to":[14,49,105,129],"solve":[15],"a":[16,32,75,91,107],"relational":[17],"database":[18],"normalisation":[19,37],"problem.":[20,63],"The":[21,64],"problem":[22],"was":[23,47,52],"presented":[24],"in":[25,35,100],"small":[26],"sequential":[27],"chunks,":[28],"each":[29,71],"chunk":[30],"representing":[31],"key":[33],"task":[34],"process.":[38],"A":[39],"think-aloud":[40],"protocol,":[41],"including":[42],"concurrent":[43],"and":[44,67,93,110],"retrospective":[45],"verbalisation":[46],"adopted":[48],"understand":[50],"what":[51],"going":[53],"through":[54,74],"novices\u2019":[56],"minds":[57],"as":[58],"they":[59,103],"worked":[60],"tactics":[65,112],"used":[66],"difficulties":[68],"encountered":[69],"by":[70],"participant":[72],"emerged":[73],"narrative":[76],"analysis":[77],"this":[79],"data.":[80],"We":[81],"found":[82],"that":[83,126],"regardless":[84],"capability":[86],"level":[87],"participants":[89],"lacked":[90],"clear":[92],"consistent":[94],"understanding":[95],"concepts":[98],"involved":[99],"normalisation.":[101],"Moreover,":[102],"tended":[104],"lack":[106],"systematic":[108],"approach":[109],"appropriate":[111],"for":[113],"overcoming":[114],"difficulties.":[115],"While":[116],"two":[118],"higher":[119],"performing":[120],"students":[121],"benefited":[122],"from":[123],"visual":[124],"representations":[125],"are":[127],"intended":[128],"support":[130],"learning":[131],"normalisation,":[132],"weakest":[134],"student":[135],"did":[136],"not.":[137]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-06-16T09:24:06.705377","created_date":"2025-10-10T00:00:00"}