Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Find the answers in SQL 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

image text in transcribed

Find the answers in SQL

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. OrderID Customer Items PateofPurchaseUnitofprice Quantity AP(123) Salim Apples Jun (5) 2020 S 10.500 15 BA(124)Ahmed Bananas Sep (23) 2020 $ 7.105 GR(746 Liala Krapes Oct (12) 2020 $ 16.525 12 OR(342/Saleh 23 Oranges May (14) 2020 S 29.748 Bananas Aug (21) 2020 S 20.210 BA(125 Ohood 37 Conditions: a) OrderID is primary key. b) Create LookUp Wizard for Items. c) Unit of Price should be >= $ 5 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 with AI-Powered 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

Students also viewed these Databases questions