QUERY TOOLS it 200 database Database- CiMUsersVaniceDownloadsit 200 database.acc

Question

QUERY TOOLS it 200 database Database- CiMUsersVaniceDownloadsit 200 database.accdb (Access 2007-2013 file format) -Ac.. FILE HOME CREATE EXTERNAL DATA DATABASE TOOLS DESIGN nsert Rows ut sert Columns property sheet Union EX Delete Rows X Delete columns Pass-Through Table Names View Run Select Make Append Update Crosstab Delete Show Totals Parameters t Data Definition Table A Builder eturn: Al Table Result Query ype Query Setup Show/Hide UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps Update now Q clothing Products clothing Manufacturers Retail stores Retail Purchases All Access Obje Clothing Manufacturers Clothing Products Retail Stores ables EE clothing Manufacturers clothing item Retail Store Name Manufacturer Name clothing Products Street Address Street Address Colo City Manufacturer Name City EE Retail Stores State Wholesale Price State Zip Code Price Zip Code Retail Purchases Clothing Item Field Betal Store Name State Manufacturer Name Clothing ltem Retail Price Clothing Products Table Retail Stores Clothing Manufactur Retail Stores Sort Ascending Show: Criteria Form View NUM LOCK Mills, Vanice

Explanation / Answer

The three tables in the database are

where underlined attributes are primary keys and italicized attributes are foreign keys.

Primary keys in the table are unique and not null.

foreign keys are used to make relationships between tables .

So if we want to extract data from multiple tables we can make use of foreign keys.

Query (using inner join)

Select RetailStores.RetailStoreName, RetailStores.State, ClothingManufacturer.ManufacturerName, RetailStores.ClothingItem,ClothingProduct.RetailPrice from ClothingManufacturers inner join ClothingProducts on ClothingManufacturers.ManufacturerName = ClothingProducts.ManufacturerName inner join RetailStores on ClothingProducts.ClothingItem = RetailStores.ClothingItem order by RetailStores.RetailStoreName;

The query is selecting the attributes of the three tables based on foreign keys and displaying data in ascending order of RetailStoreName.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.