{"id":3102,"date":"2019-12-23T16:40:11","date_gmt":"2019-12-23T16:40:11","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3102"},"modified":"2024-05-17T00:24:19","modified_gmt":"2024-05-17T00:24:19","slug":"types-of-table-relationships","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/types-of-table-relationships\/","title":{"raw":"Types of Table Relationships","rendered":"Types of Table Relationships"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Define one-to-one relationships<\/li>\r\n \t<li>Define one-to-many relationships<\/li>\r\n \t<li>Define many-to-many relationships<\/li>\r\n<\/ul>\r\n<\/div>\r\nThere are three types of relationships in Access between tables:\r\n<ul>\r\n \t<li>One-to-one<\/li>\r\n \t<li>One-to-many<\/li>\r\n \t<li>Many-to-many<\/li>\r\n<\/ul>\r\n<img class=\"aligncenter wp-image-3425 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07200307\/Figure13_1.png\" alt=\"Screenshot of Microsoft Access showing one-to-one, one-to-many, and many-to-many relationships between tables.\" width=\"974\" height=\"608\" \/>\r\n<h2>One-to-One Relationships<\/h2>\r\nA one-to-one relationship means that a record in the first table can have one and only one record related to it in a second table. For example, a product listed in a products table would have only one country of origin record in a operations table.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/d65c67bc-4049-4d56-ab64-badc5297a581\r\n\r\n<\/div>\r\n<h2>One-to-Many Relationships<\/h2>\r\nOne of the most common relationships between tables is the one-to-many relationship. In a one-to-many relationship, a record in the first table is related to multiple records in the second table. For example, an employee table could have relationships with a payroll table that contains multiple records of paychecks.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/61214426-7eec-4a25-b15e-408d4e0aa5c8\r\n\r\n<\/div>\r\n<h2>Many-to-Many Relationships<\/h2>\r\nMany-to-many relationships are defined as a record in the first table having multiple relationships in the second table and those records in the second table also having multiple relationships within the first table. For example, a streaming service would have TV series that are selected to view by multiple customers while each customer of the service would watch multiple TV series.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/6fb164a0-a8fd-41b2-90a9-763982989521\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Define one-to-one relationships<\/li>\n<li>Define one-to-many relationships<\/li>\n<li>Define many-to-many relationships<\/li>\n<\/ul>\n<\/div>\n<p>There are three types of relationships in Access between tables:<\/p>\n<ul>\n<li>One-to-one<\/li>\n<li>One-to-many<\/li>\n<li>Many-to-many<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3425 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07200307\/Figure13_1.png\" alt=\"Screenshot of Microsoft Access showing one-to-one, one-to-many, and many-to-many relationships between tables.\" width=\"974\" height=\"608\" \/><\/p>\n<h2>One-to-One Relationships<\/h2>\n<p>A one-to-one relationship means that a record in the first table can have one and only one record related to it in a second table. For example, a product listed in a products table would have only one country of origin record in a operations table.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_d65c67bc-4049-4d56-ab64-badc5297a581\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/d65c67bc-4049-4d56-ab64-badc5297a581?iframe_resize_id=assessment_practice_id_d65c67bc-4049-4d56-ab64-badc5297a581\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>One-to-Many Relationships<\/h2>\n<p>One of the most common relationships between tables is the one-to-many relationship. In a one-to-many relationship, a record in the first table is related to multiple records in the second table. For example, an employee table could have relationships with a payroll table that contains multiple records of paychecks.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_61214426-7eec-4a25-b15e-408d4e0aa5c8\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/61214426-7eec-4a25-b15e-408d4e0aa5c8?iframe_resize_id=assessment_practice_id_61214426-7eec-4a25-b15e-408d4e0aa5c8\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Many-to-Many Relationships<\/h2>\n<p>Many-to-many relationships are defined as a record in the first table having multiple relationships in the second table and those records in the second table also having multiple relationships within the first table. For example, a streaming service would have TV series that are selected to view by multiple customers while each customer of the service would watch multiple TV series.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_6fb164a0-a8fd-41b2-90a9-763982989521\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/6fb164a0-a8fd-41b2-90a9-763982989521?iframe_resize_id=assessment_practice_id_6fb164a0-a8fd-41b2-90a9-763982989521\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3102\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Types of Table Relationships. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":5,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Types of Table Relationships\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"64ef7b0c-1db0-4484-92d6-ac23d6c09407, 0a7a4555-fa5e-4312-aa9a-a08c1b10fb3d, 08290e0e-04a3-41cf-9cba-47bd03bc06a9, d2469cc7-69bc-4707-9824-ed5f672ac6b1","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3102","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":11,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3102\/revisions"}],"predecessor-version":[{"id":5954,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3102\/revisions\/5954"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2774"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3102\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3102"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3102"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3102"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}