Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions