MAX 506: Fundamentals of Database Management Systems

Assignments 5

Dr. Dinakar Jayarajan

Submit your work in a single PDF file. Make sure to properly refer to the question numbers in your submission. Properly organize and format your submission to improve readability. Upload your submission to blackboard and submit a hardcopy in class on the due date. Each question carries 5 points for a total of 45 points.

Use the Zagi Store database (db_jukicfirsted_zagimore) on TUN to attempt these questions. When you first use the DBMS, check the table definitions to see what the exact field names are for the DBMS you are using.

Use a JOIN to list TID, CustomerName, Region and Store Zipcode for each Sales Transaction

Use a JOIN to list the Category Name, Product Name, Price, VendorName for each product

Use a JOIN to list the Store ID, Product ID, Name and Price of products that are sold by the store.

Use a JOIN to compute the number of transactions for each store in Indiana.

List the StoreID, Zipcode and RegionName for each store in the database.

Compute the Total Revenue for each store in Indiana.

List the Total Revenue for each store.

List the Total Revenue for each Region.

List the category names of products sold by each vendor