{"id":"https://openalex.org/W2236723285","doi":"https://doi.org/10.5555/2831432.2831462","title":"Creating a database from \"scratch\"","display_name":"Creating a database from \"scratch\"","alternate_titles":[],"publication_year":2015,"publication_date":"2015-12-01","ids":{"openalex":"https://openalex.org/W2236723285","doi":"https://doi.org/10.5555/2831432.2831462","mag":"2236723285"},"language":"en","primary_location":{"id":"mag:2236723285","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=2831432.2831462","pdf_url":null,"source":{"id":"https://openalex.org/S56112914","display_name":"Journal of computing sciences in colleges","issn_l":"1937-4763","issn":["1937-4763","1937-4771"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4361727485","host_organization_name":"Consortium for Computing Sciences in Colleges","host_organization_lineage":["https://openalex.org/P4361727485"],"host_organization_lineage_names":["Consortium for Computing Sciences in Colleges"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing sciences in colleges","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2236723285"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5066652576","display_name":"N. Faye Angel","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I152372855","display_name":"Ferrum College","ror":"https://ror.org/0128ckf82","country_code":"US","type":"education","lineage":["https://openalex.org/I152372855"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"N. Faye Angel","raw_affiliation_strings":["Ferrum College, Ferrum, VA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ferrum College, Ferrum, VA#TAB#","institution_ids":["https://openalex.org/I152372855"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046972368","display_name":"Nichole Young","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I152372855","display_name":"Ferrum College","ror":"https://ror.org/0128ckf82","country_code":"US","type":"education","lineage":["https://openalex.org/I152372855"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nichole Young","raw_affiliation_strings":["Ferrum College"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ferrum College","institution_ids":["https://openalex.org/I152372855"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049538821","display_name":"Amanda Dollman","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I152372855","display_name":"Ferrum College","ror":"https://ror.org/0128ckf82","country_code":"US","type":"education","lineage":["https://openalex.org/I152372855"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Amanda Dollman","raw_affiliation_strings":["Ferrum College"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ferrum College","institution_ids":["https://openalex.org/I152372855"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I152372855"],"apc_list":null,"apc_paid":null,"fwci":0.8049,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.78544011,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":93},"biblio":{"volume":"31","issue":"2","first_page":"185","last_page":"187"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.8676999807357788,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.8676999807357788,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11299","display_name":"Problem and Project Based Learning","score":0.09309999644756317,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.012900000438094139,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/database-design","display_name":"database design","score":0.9240000247955322},{"id":"https://openalex.org/keywords/database-construction","display_name":"database construction","score":0.5260000228881836},{"id":"https://openalex.org/keywords/relational-tables","display_name":"relational tables","score":0.5360000133514404},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.5870000123977661},{"id":"https://openalex.org/keywords/database-reports","display_name":"database reports","score":0.7710000276565552},{"id":"https://openalex.org/keywords/user-interface-design","display_name":"user interface design","score":0.7179999947547913},{"id":"https://openalex.org/keywords/data-dictionary","display_name":"data dictionary","score":0.9929999709129333},{"id":"https://openalex.org/keywords/missing-data","display_name":"missing data","score":0.6240000128746033},{"id":"https://openalex.org/keywords/requirements-gathering","display_name":"requirements gathering","score":0.4440000057220459},{"id":"https://openalex.org/keywords/case-studies","display_name":"case studies","score":0.5419999957084656},{"id":"https://openalex.org/keywords/computer-information-systems-education","display_name":"computer information systems education","score":0.6660000085830688}],"concepts":[{"id":"https://openalex.org/C2781235140","wikidata":"https://www.wikidata.org/wiki/Q275131","display_name":"Scratch","level":2,"score":0.9293652176856995},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8295813798904419},{"id":"https://openalex.org/C183469790","wikidata":"https://www.wikidata.org/wiki/Q333501","display_name":"Crash","level":2,"score":0.5241230130195618},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49228182435035706},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.4898645579814911},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4888407588005066},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.46146777272224426},{"id":"https://openalex.org/C162189203","wikidata":"https://www.wikidata.org/wiki/Q6044092","display_name":"Intelligent database","level":5,"score":0.41512900590896606},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3974408805370331},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2510684132575989},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.16699716448783875},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15843993425369263},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10423344373703003},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:2236723285","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=2831432.2831462","pdf_url":null,"source":{"id":"https://openalex.org/S56112914","display_name":"Journal of computing sciences in colleges","issn_l":"1937-4763","issn":["1937-4763","1937-4771"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4361727485","host_organization_name":"Consortium for Computing Sciences in Colleges","host_organization_lineage":["https://openalex.org/P4361727485"],"host_organization_lineage_names":["Consortium for Computing Sciences in Colleges"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing sciences in colleges","raw_type":null},{"id":"mag:3005486150","doi":"https://doi.org/10.5555/2831432.2831462","is_oa":false,"landing_page_url":"https://dl.acm.org/doi/10.5555/2831432.2831462","pdf_url":null,"source":{"id":"https://openalex.org/S56112914","display_name":"Journal of computing sciences in colleges","issn_l":"1937-4763","issn":["1937-4763","1937-4771"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4361727485","host_organization_name":"Consortium for Computing Sciences in Colleges","host_organization_lineage":["https://openalex.org/P4361727485"],"host_organization_lineage_names":["Consortium for Computing Sciences in Colleges"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing sciences in colleges","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W332412657","https://openalex.org/W2373033641","https://openalex.org/W2184155958","https://openalex.org/W203619751","https://openalex.org/W2295188342","https://openalex.org/W7135809781","https://openalex.org/W1547159678","https://openalex.org/W2888541632","https://openalex.org/W4256245246"],"abstract_inverted_index":{"The":[0],"Smarter":[1],"Solutions":[2],"case":[3],"study":[4],"was":[5],"written":[6],"for":[7,13],"an":[8,39],"advanced":[9],"computer":[10,17],"applications":[11],"course":[12],"students":[14,44,70],"majoring":[15],"in":[16,75],"information":[18],"systems":[19],"and":[20,38,73,79],"business":[21],"administration.":[22],"It":[23],"involves":[24],"developing":[25],"a":[26,47,55,112],"database":[27,115],"program":[28],"from":[29],"scratch,":[30],"including":[31],"designing":[32],"the":[33,43,60,69,81,101,118],"tables,":[34],"forms,":[35],"queries,":[36],"reports,":[37],"interface.":[40],"In":[41],"addition,":[42],"must":[45,71],"create":[46,111],"data":[48,67,107],"dictionary":[49],"to":[50,77,100,103,110],"document":[51],"their":[52],"programs":[53],"should":[54],"crash":[56],"occur.":[57],"To":[58],"make":[59],"project":[61],"more":[62],"realistic,":[63],"there":[64],"are":[65,108],"missing":[66],"that":[68,116],"discover":[72],"request":[74],"order":[76],"complete":[78],"implement":[80],"database.":[82],"As":[83],"is":[84,98],"commonly":[85],"known,":[86],"most":[87],"users":[88],"do":[89],"not":[90],"know":[91],"exactly":[92],"what":[93,106],"they":[94],"want":[95],"so":[96],"it":[97],"up":[99],"developer":[102],"search":[104],"out":[105],"needed":[109],"transparent,":[113],"user-friending":[114],"serves":[117],"end-user.":[119]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2236723285","counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
