Data Modeling and Design_Unit1_IP1

Data Modeling and Design_Unit1_IP1 - CountyName and...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Modeling and Design Unit 1 Individual Project Kregg M. Soltow March 24, 2011 American Intercontinental University In order to explain where I would add the attribute CountyName for the county or counties containing the state capital in this scenario, I believe the feature should first and foremost be included into a supplementary table, preferably named something like Capitals county table. This table would of course contain two columns; CapitalName and CountyName. Within this new table the primary keys would need to be set as
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CountyName and CapitalName, the combination is necessary given the chances of similar county names for different capital names. This explanation also goes hand in hand with the reasoning for a detached table to specifically enclose the county name data simply again because one the listed capitals could include many county names related with them. Following this explanation I have included a sketch of the ER diagram;...
View Full Document

This note was uploaded on 02/17/2012 for the course ITCO 101 taught by Professor Gugenhiem during the Spring '12 term at AIU Online.

Ask a homework question - tutors are online