Relationships Between Tables

Tables in ACME are connected by primary/foreign key relationships (as in any relational database). The database is normalized to a certain degree (see Appendix C for relational database design basics and Normalization rules). Figure B-1 shows ACME tables and relationships between them.

click to expand
Figure B-1: ACME database schema




SQL Bible
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net