Relational Data Modeling Example – Part 3

The completed relational data model is shown in the previous part and the corresponding data stored in database are shown in separate tables below.

State Lookup:

State CodeState NameDate TimeStamp
NYNew York1/1/2005 11:23:31 AM
FLFlorida1/1/2005 11:23:31 AM
CACalifornia1/1/2005 11:23:31 AM
NJNew Jersey1/1/2005 11:23:31 AM

County Lookup:

County CodeCounty NameDate TimeStamp
NYSHShelby1/1/2005 11:23:31 AM
FLJEJefferson1/1/2005 11:23:31 AM
CAMOMontgomery1/1/2005 11:23:31 AM
NJHUHudson1/1/2005 11:23:31 AM

City Lookup:

City CodeCity NameDate TimeStamp
NYSHMAManhattan1/1/2005 11:23:31 AM
FLJEPCPanama City1/1/2005 11:23:31 AM
CAMOSHSan Hose1/1/2005 11:23:31 AM
NJHUJCJersey City1/1/2005 11:23:31 AM

Employee Lookup:

Emp IdState CodeCounty CodeCity CodeManager IdEmp First NameEmp Last NameEmp Full NameDate TimeStamp
1NYNYSHNYSHMAPaulYoungPaul Young1/1/2005 11:23:31 AM
2FLFLJEFLJEPC1ChrisDavisChris Davis1/1/2005 11:23:31 AM
3CACAMOCAMOSH1LouisJohnsonLouis Johnson1/1/2005 11:23:31 AM
4NJNJHUNJHUJC1SamMathewSam Mathew1/1/2005 11:23:31 AM
5NYNYSHNYSHMA1NancyRobinsonNancy Robinson1/1/2005 11:23:31 AM
6FLFLJEFLJEPC2Sheela ShellumSheela Shellum1/1/2005 11:23:31 AM
7CACAMOCAMOSH3JeffBillJeff Bill1/1/2005 11:23:31 AM
8NJNJHUNJHUJC4JohnBurrellJohn Burrell1/1/2005 11:23:31 AM

Employer Lookup:

Employer IdEmployer NameDateTimeStamp
1001American Bank of NewYork1/1/2005 11:23:31 AM
1002American Bank of Florida1/1/2005 11:23:31 AM
1003American Bank of California1/1/2005 11:23:31 AM
1004American Bank of New Jersey1/1/2005 11:23:31 AM

Employee Employer XREF:

Employee IdEmployer IdDateTimeStamp
110011/1/2005 11:23:31 AM
210021/1/2005 11:23:31 AM
310031/1/2005 11:23:31 AM
410041/1/2005 11:23:31 AM
510011/1/2005 11:23:31 AM
610021/1/2005 11:23:31 AM
710031/1/2005 11:23:31 AM
810041/1/2005 11:23:31 AM

 

(Visited 2,223 times, 2 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *