Data Modeling and Design_Unit1_DB1

Data Modeling and Design_Unit1_DB1 - Data Modeling and...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Modeling and Design Unit 1 Discussion Board Kregg M. Soltow March 24, 2011 American Intercontinental University One-to-one relationship: Company to CEO, seeing as thou each company has only one CEO. There would be two tables; Company and CEO. There could be CEOkey as an attribute of Company and Company.CEOkey as a foreign key to the CEO table where CEOkey is the primary. Likewise, there could be CEO.Companykey as an attribute of CEO and Companykey is a foreign key to the Company table where Comapanykey is the primary. I will utilize the second option and use it in the following example. One-to-many relationship: Company to Managers because each company has several managers. In the table Manager, there is a column Manager.Companykey that’s a foreign key to the Company table where Companykey is the primary. Multiple rows of the Manager table can point to the same Company table row, but each Manager row utilizes only one Companykey significance. Additionally the Manager table has Managerkey as a primary key.(Inmon,2007)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Data Modeling and Design_Unit1_DB1 - Data Modeling and...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online