Problemset

Bina Nusantara Skill Competition
Qualification Round
Sunday, 5 August 2007

Topic : Database - Table and Query

Click Here to download required files to accomplish following instuctions

Instruction :

• Create a database, named OrderDB.mdb
• Protect database with password : Order!@#
• Create some tables with following properties

• Fill table “Products” with data from Products_Data.txt (The first row of this file is field name)
• Fill table “Categories” with data from Categories.xml
• Fill table "Orders". Data for table “Orders” originate from Order_Data.xls worksheet “Orders”
• Fill table "Order Details". Data for table “Order Details” originate from Order_Data.xls worksheet “Order Details”
• Build tables relationship as following

• Build a query named : “AvgOrder per Category” to show information :
  About the average order amount for discount products (not include discontinued products), for every category, as shown: