Assignment-1 Answer all of the following questions. Date of submission:7/11/2020 Create a new database in MS-Access, name it as Hypermarket. Create the Order table with following records. Order Dustomer Items PateofPurchasintofprice Quantity AP123) Salim Apples Jun (5) 2020 S 10.500 15 BA(124 |Ahmed Bananas Sep (23) 2020 S 7105 GR(746 Lala Krapes Oct (12) 2020 S 16325 OR(342 Saleh Oranges May (14) 2020 S 29.748 BA(125Ohood Bananas Aug (21) 2020 $20,210 37 45 Conditions: a) OrderID is primary key. b) Create LookUp Wizard for Items. c) Unit of Price should be >=S5 d) Message "Unit of price must be more than 5" should be displayed when you enter values less than on unit of price. Use SQL to solve the following queries. a) ADD address (with text data type) attribute to order table. b) Display all information items whose unit price