You are here: Home Data Modeling Relational(OLTP) Data Modeling continued...

---

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

State Lookup

State Code	State Name	DateTimeStamp
NY	New York	1/1/2005 11:23:31 AM
FL	Florida	1/1/2005 11:23:31 AM
CA	California	1/1/2005 11:23:31 AM
NJ	New Jersey	1/1/2005 11:23:31 AM

County Lookup

County Code	County Name	DateTimeStamp
NYSH	Shelby	1/1/2005 11:23:31 AM
FLJE	Jefferson	1/1/2005 11:23:31 AM
CAMO	Montgomery	1/1/2005 11:23:31 AM
NJHU	Hudson	1/1/2005 11:23:31 AM

City Lookup

City Code	City Name	DateTimeStamp
NYSHMA	Manhattan	1/1/2005 11:23:31 AM
FLJEPC	Panama City	1/1/2005 11:23:31 AM
CAMOSH	San Hose	1/1/2005 11:23:31 AM
NJHUJC	Jersey City	1/1/2005 11:23:31 AM

Employee

Emp Id	State Code	County Code	City Code	Manager Id	Emp First Name	Emp Last Name	Emp Full Name	DateTimeStamp
1	NY	NYSH	NYSHMA		Paul	Young	Paul Young	1/1/2005 11:23:31 AM
2	FL	FLJE	FLJEPC	1	Chris	Davis	Chris Davis	1/1/2005 11:23:31 AM
3	CA	CAMO	CAMOSH	<1/td>	Louis	Johnson	Louis Johnson	1/1/2005 11:23:31 AM
4	NJ	NJHU	NJHUJC	1	Sam	Mathew	Sam Mathew	1/1/2005 11:23:31 AM
5	NY	NYSH	NYSHMA	1	Nancy	Robinson	Nancy Robinson	1/1/2005 11:23:31 AM
6	FL	FLJE	FLJEPC	2	Sheela	Shellum	Sheela Shellum	1/1/2005 11:23:31 AM
7	CA	CAMO	CAMOSH	3	Jeff	Bill	Jeff Bill	1/1/2005 11:23:31 AM
8	NJ	NJHU	NJHUJC	4	John	Burrell	John Burrell	1/1/2005 11:23:31 AM

Employer Lookup

Employer Id	Employer Name	DateTimeStamp
1001	American Bank of NewYork	1/1/2005 11:23:31 AM
1002	American Bank of Florida	1/1/2005 11:23:31 AM
1003	American Bank of California	1/1/2005 11:23:31 AM
1004	American Bank of New Jersey	1/1/2005 11:23:31 AM

Employee Employer XREF

Employee Id	Employer Id	DateTimeStamp
1	1001	1/1/2005 11:23:31 AM
2	1002	1/1/2005 11:23:31 AM
3	1003	1/1/2005 11:23:31 AM
4	1004	1/1/2005 11:23:31 AM
5	1001	1/1/2005 11:23:31 AM
6	1002	1/1/2005 11:23:31 AM
7	1003	1/1/2005 11:23:31 AM
8	1004	1/1/2005 11:23:31 AM

---

Relational Data Modeling Example       Dimensional Data Modeling

---