Microsoft Office Tutorials and References
In Depth Information
Figure A-24
Employee
EmployeeNum
ClientName
LastName
HealthPlan
2173
Barbara
Hennessey
B
4519
Lee
Noordsy
A
8005
Pat
Amidon
C
8112
Chris
Wandzell
A
Position
PositionID
PositionDes
PayGrade
1
Director
45
2
Manager
40
3
Analyst
30
4
Clerk
20
Employment
EmployeeNum
PositionID
StartDate
2173
2
12/14/2008
4519
1
04/23/2010
4519
11/11/2004
8005
3
06/05/2009
8005
4
07/02/2007
8112
1
12/15/2009
9876
2
10/04/2008
16. The State and City tables, shown in Figure A-4, are described as follows:
State ( StateAbbrev , StateName, EnteredUnionOrder, StateBird,
StatePopulation)
City ( StateAbbrev , CityName , CityPopulation)
Foreign key: StateAbbrev to State table
Add the field named CountyName for the county or counties in a state containing the
city to this database, justify where you placed it (that is, in an existing table or in a
new one), and draw the entity-relationship diagram for all the entities. Counties for
some of the cities shown in Figure A-4 are Travis and Williamson counties for Austin
TX; Hartford county for Hartford CT; Clinton, Eaton, and Ingham counties for Lansing
MI; Davidson county for Nashville TN; Hughes county for Pierre SD; and Nueces and
San Patricio counties for Portland TX.
 
Search JabSto ::




Custom Search