Question: Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3), Varchar2(25)

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3), Varchar2(25) Date Number(2) Primary Key Default systemdate b. Change datatype of It_No to from Number (3) to Varchar2(4). (1 Mark) c. Insert the following records into the table Shop. (1 Mark) It_No It_Name DOP Quantity P222 Book 20/05/2019 18 P444 Pencil 15/10/2018 20 P666 Ruler 06/06/2020 10 d. Display Item no and Quantity of item with name Book. (1 Mark)

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!

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) | It No It_Name DOP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate...

please answer this question with SQL language and please write your answer thus i can coppy it easly I hope you reply me as fast as you can because i have an exam thank you Q11. Write an SQL query to...

Date Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DOP Quantity Number(3). Varchar2(25) Number(2) Primary Key Default system date b....

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) | It No It_Name DOP Quantity Number(3) Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Qil. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Q11. Write an SQL query to do the following: a. Create table Library with the given details. ID BName Pch Date Varchar2(3). Varchar2(15) Date Primary key (2 Marks) Price Number(5,2). Default 0 (1...

Q11. Write an SQL query to do the following: a. Create table Library with the given details. ID BName Pch Date Varchar2(3), Varchar2(15) Date Primary key (2 Marks) Price Number(5,2), Default 0 (1...

Two individuals, Frank and Sam, form a new corporation. The following transactions are made pursuant to agreement of incorporation. In exchange for 2/3 (66.67 percent) of the stock in the newly...

Write a summary of leadership development.

3. Net investment income $1.39 $1.35

Using the company s activity - based costing system, compute the customer margin of Big Sky Outfitters. Thermal Rising, Incorporated, makes paragliders for sale through specialty sporting goods...

1. What do you think has happened here? Who, and in what way, are the various participants responsible for the outcome?

2. Assuming that, after his reassignment, John might have become more open to suggestions on his behavior, how might you advise him?

3. If you were John and had the benefit of hindsight, how might you have handled the situation differently? How could you use power and organizational politics to gain the respect and cooperation you...