{"id":26697,"date":"2020-12-08T12:31:17","date_gmt":"2020-12-08T12:31:17","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=26697"},"modified":"2020-12-08T12:31:18","modified_gmt":"2020-12-08T12:31:18","slug":"describe-entities-fields-and-relationships","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/","title":{"rendered":"Describe Entities, Fields, and Relationships"},"content":{"rendered":"\n

Effective from November 2020, Common Data Service (CDS) has been renamed to ‘Microsoft Dataverse’. Primarily, Microsoft Dataverse helps to securely store and manage data being used by business applications. Such that the Data within Dataverse is stored within a set of tables consisting of a set of rows (records) and columns (fields\/attributes). Each column in the table has been designed for storing a specific data type including name, age, salary, and more. Moreover, Dataverse consists of a base set of standard tables with typical scenarios, but we can also create custom tables specific to the organization. We can populate these customized tables with data by using Power Query. Some of the terminology in Microsoft Dataverse has been updated including –<\/p>\n\n\n\n

\"Microsoft
Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n

Entities\/Tables<\/strong><\/h3>\n\n\n\n

Tables earlier known as entities are primarily used to model and manage business data. Such that when we develop an app, we can use standard tables, custom tables, or both. By default, Microsoft Dataverse offers standard tables. These standard tables have been designed to capture the most common concepts and scenarios within an organization.<\/p>\n\n\n\n

Fields\/Columns<\/strong><\/h3>\n\n\n\n

Columns define the individual data items that can be used to store information in a table. Create new columns to capture data when existing standard tables don\u2019t have columns that meet your requirements. After you create a new column, be sure to include it on the appropriate forms and views for the table so that they are available in your app.<\/p>\n\n\n\n

Table Relationships<\/strong><\/h3>\n\n\n\n

Table relationships refer to the metadata that is used to make changes to the database. Such that, these relationships allow queries to retrieve related data efficiently. We use table relationships for defining formal relationships used to determine the table or rows that can be used.\u00a0Also, table relationships define the manner in which rows are related to each other in the database. <\/p>\n\n\n\n

Now, adding a lookup column to a table helps to create a new 1:N (one-to-many) relationship between the two tables. And thereby allows us to put that lookup column in a form. With the lookup column, users can associate multiple\u00a0child<\/em>\u00a0rows of that table to a single\u00a0parent<\/em>\u00a0table row. Besides, Tables can also participate in a N:N (many-to-many) relationship where any number of rows for two tables can be associated with each other.<\/p>\n\n\n\n

Types of Table Relationships<\/strong><\/h5>\n\n\n\n
\"Types
Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n

For more visit – Table Relationships<\/a><\/strong><\/p>\n\n\n\n

\"\"\/<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"

Effective from November 2020, Common Data Service (CDS) has been renamed to ‘Microsoft Dataverse’. Primarily, Microsoft Dataverse helps to securely store and manage data being used by business applications. Such that the Data within Dataverse is stored within a set of tables consisting of a set of rows (records) and columns (fields\/attributes). Each column in…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-26697","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nDescribe Entities, Fields, and Relationships - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Describe Entities, Fields, and Relationships - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-08T12:31:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/image-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/\",\"name\":\"Describe Entities, Fields, and Relationships - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-08T12:31:17+00:00\",\"dateModified\":\"2020-12-08T12:31:18+00:00\",\"description\":\"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Describe Entities, Fields, and Relationships\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Describe Entities, Fields, and Relationships - Testprep Training Tutorials","description":"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/","og_locale":"en_US","og_type":"article","og_title":"Describe Entities, Fields, and Relationships - Testprep Training Tutorials","og_description":"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-12-08T12:31:18+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/image-2.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/","name":"Describe Entities, Fields, and Relationships - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-08T12:31:17+00:00","dateModified":"2020-12-08T12:31:18+00:00","description":"Learn more about Tables, Columns and Table Relationships with Online Tutorial. Get ready to qualify Microsoft Exam PL-900. Try Free Test Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/describe-entities-fields-and-relationships\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Describe Entities, Fields, and Relationships"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/26697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=26697"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/26697\/revisions"}],"predecessor-version":[{"id":26701,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/26697\/revisions\/26701"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=26697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=26697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=26697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}