Answered step by step
Verified Expert Solution
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
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 priceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started