You will be given a graphic of a form and asked to normalize it into tables using a sentence structure approach as you did in Ch 3 Homework 1) You will be given a form and will be asked to normalize the fields into a sentence structure. Steps to take are as follows: • Take the form and circle the tables (themes) and label each • Then look for a primary key for each different table. o If no key field is obvious, create a surrogate key to use as the primary key field • Create a sentence for each table • Consider where the foreign keys would go to link them together • Create the Sentence Structure to include the Primary key (underlined), the attributes, and any foreign keys (italics)
The post Create the Sentence Structure to include Primary key appeared first on Assignment Freelancers.