Question: Write the query statements for all the questions(Question 5 -7). 5. Sales department of SAMA Mobile Shop wants to store their item details. The shop
Write the query statements for all the questions(Question 5 -7). 5. Sales department of SAMA Mobile Shop wants to store their item details. The shop Manager asked the DBA to create ITEM table in Oracle using appropriate SQL statements required for this database. ITEM table has many to one relationship with CUSTOMER table. Make sure you include appropriate constraints and sensible types for the fields. [6 Marks) Name Null/KEY Type of data Item ID Primary key Numbers only Item name Not Null Appropriate name Company Appropriate name Item prod date Date format Customer id Foreign key Numbers only Price Decimal values Table 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
