Generate an ERD with three tables

ERD in Powerpoint

Microsoftonline

Sign in to your account

sdow3 About 6 years ago

Choice of Keys

ERD File located at https://parkland1-my.sharepoint.com/:p:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7Bb4f8d1d4-82c9-47fb-a2ea-193a5f3298d0%7D&action=edit&uid=%7BB4F8D1D4-82C9-47FB-A2EA-193A5F3298D0%7D&ListItemId=2&ListId=%7BF74DF069-8ADF-42EE-9B41-0E92AAE30508%7D&odsp=1&env=prod

Chose keys of fields which are common between the tables such as Name or grade .

sdow3 About 6 years ago

Posted Image

sdow3 About 6 years ago

Posted Image

mangai Over 6 years ago

Posted Image

mpurnell1 Almost 7 years ago

Posted Image

rvargas8 About 7 years ago

I chose these keys because they are easy to relate and understand. Since I'm just starting out with SQL I wanted to do one that I could easily understand and look back at as reference.

rvargas8 About 7 years ago

Posted Image

jmfisher About 7 years ago

I chose 3 tables representing entities to be used in a SignEstimator app I am developing for CSC-212. Signs, Materials, Finishes

I chose 3 tables representing entities to be used in a SignEstimator app I am developing for CSC-212. A table for the signs themselves with various attributes, a table for the available material the signs can be printed on and the cost of each, and a table for the available finishing touches and their cost. Each table has an integer based id as its primary key. The foreign keys in the Sign table point to the primary keys of the Material and Finishes tables because each Sign can have one of many available materials/finishes from those tables

jmfisher About 7 years ago