Cha pter 4 Logical Database Design and the Relational Model 127 FIGURE 4-4 Instance of a relational schema (Pine Valley Furniture Company) 1 Contemporary Casuals 2 Value Furniture 3 Home Furnishings 4 Eastern Furniture 5 Impressions 6 Furniture Gallery 7 Period Furniture 1355 S Hines Blvd 15145 5.W. 17th St. Plano 1900 Allard Ave. Albany 1925 Beltline Rd. Carteret 5585 Westoott Ct. Sacramento CA 825 Flatiron Dr. Boulderc 394 Rainbow Dr. Seattle 32601-2871 75094-7743 12209-1125 07008-3188 Gainesville FL 8 Calfornia Classics 816 Peach Rd. Santa Clara C 9 M and H Casual Furniture 370 10 Seminole Interiors 97954-5589 96915-7754 2314 11 American Euro Lifestyles 242 12 Battle Creek Furniture 345 13 Heritage Furnishings 66 14 Kaneohe Homes 15 Mountain Scenes 4 508-5621 015-3401 2 013-8834 1 744-2537 5 103-4432 1001 7 1001 002 1003 1004 413 Record: K 1 of 15 NNo Fite Search nlOrderiD-1 OrderDate , lCustomerio- 1001 10/21/2010 1002 10/21/2010 1003 10/22/2010 1004 10/22/2010 1005 10/24/2010 1006 10/24/2010 1007 10/27/2010 1008 10/30/2010 1009 11/5/2010 1010 11/5/2010 1 of 10HNe 15 1006 1007 1007 1008 1010 Record l Product J Cherry Natural Ash Natural Ash 1End Table 2 Coffe Table 3 Computer Desk 4 Entertainment Center Natural 5 Writers Desk 6 8-Drawer Desk 7 Dining Table 8 Comput 5375.00 $650.00 $325.00 White Ash Natural Ash Walnut $800.00 Record 1 of8