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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!