{"id":"https://openalex.org/W3021649026","doi":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","title":"Normalization","display_name":"Normalization","alternate_titles":[],"publication_year":2016,"publication_date":"2016-01-01","ids":{"openalex":"https://openalex.org/W3021649026","doi":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","mag":"3021649026"},"language":"en","primary_location":{"id":"doi:10.1016/b978-0-12-804399-8.00007-7","doi":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","is_oa":false,"landing_page_url":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","pdf_url":null,"source":{"id":"https://openalex.org/S4306463230","display_name":"Elsevier eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Relational Database Design and Implementation","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2984654930","display_name":"Relational Database Design and Implementation","relationship":"volume"}],"lineage":["https://openalex.org/W3021649026","https://openalex.org/W2984654930"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"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/A5056391501","display_name":"Jan L. Harrington","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Jan L. Harrington","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5056391501"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"141","last_page":"161"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9804999828338623,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9804999828338623,"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/T13681","display_name":"Engineering and Information Technology","score":0.0024999999441206455,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.0010000000474974513,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/database-normalization","display_name":"database normalization","score":0.9279999732971191},{"id":"https://openalex.org/keywords/relational-database-design","display_name":"relational database design","score":0.7149999737739563},{"id":"https://openalex.org/keywords/normal-forms","display_name":"normal forms","score":0.609000027179718},{"id":"https://openalex.org/keywords/first-normal-form","display_name":"first normal form","score":0.7940000295639038},{"id":"https://openalex.org/keywords/third-normal-form","display_name":"third normal form","score":0.9980000257492065},{"id":"https://openalex.org/keywords/boyce-codd-normal-form","display_name":"Boyce-Codd normal form","score":0.8220000267028809},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.5960000157356262},{"id":"https://openalex.org/keywords/entity-relationship-model","display_name":"entity-relationship model","score":0.6470000147819519}],"concepts":[{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.6739356517791748},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5467154383659363},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.48726168274879456},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.43004217743873596},{"id":"https://openalex.org/C191795146","wikidata":"https://www.wikidata.org/wiki/Q3878446","display_name":"Norm (philosophy)","level":2,"score":0.41119953989982605},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.31682097911834717},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2768102288246155},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.2504144608974457},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.13571089506149292},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.07058930397033691},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.059541553258895874},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/b978-0-12-804399-8.00007-7","doi":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","is_oa":false,"landing_page_url":"https://doi.org/10.1016/b978-0-12-804399-8.00007-7","pdf_url":null,"source":{"id":"https://openalex.org/S4306463230","display_name":"Elsevier eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Relational Database Design and Implementation","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W192682972","https://openalex.org/W1482239099","https://openalex.org/W1507944889","https://openalex.org/W1565714532","https://openalex.org/W2140997005","https://openalex.org/W4214536306","https://openalex.org/W7010591738"],"related_works":["https://openalex.org/W1599865497","https://openalex.org/W2514543912","https://openalex.org/W4206315335","https://openalex.org/W4254541231","https://openalex.org/W2031239874","https://openalex.org/W2356481761","https://openalex.org/W2147530222","https://openalex.org/W1971778345","https://openalex.org/W2359465177","https://openalex.org/W1963792873"],"abstract_inverted_index":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3021649026","counts_by_year":[],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2020-05-13T00:00:00"}
