Question

39. (a) Write a Query to create a Table with the following structure:-
Table Patient
Field
PID
PNAME
DISEASE
FEES
Datatype
Char(4)
(Varchar(20)
Varchar(40)
Decimal
1
(b) Consider the following Book_issue table and write the queries :-
Table Book_issue
1
|
Book ID
B001
B002
B003
B004
Date of Issue
20-01-2009
01-04-2015
12-05-2012
15-10-2013
Student Name
Ashish
Subhash
Ankita
Arpita
Returned
Yes
No
No
|
Yes
(i) Write a SQL Query to display all records.
(ü) Write a SQL Query to add a new row with the following details
("B005', '20-06-2014', 'Preeti', 'Yes')
(iii) Write a SQL Query to modify the Name of B003 from Ankita to​

Answer 1

Answer:

Create table Patient (PID Char(4), PNAME Varchar(20), DISEASE Varchar(40), FEES Decimal(1));

.

Select * from Book_issue;

Insert into Book_issue values ('B005', '20-06-2014', 'Preeti', 'Yes');

.

Actually last question is not complete but still it would be like....

if you change it to for eg. Asha then,

Update Book_issue set Student Name='Asha' where Book ID='B003';

Answer 2

Answer:

Explanation:

Are pls batado if this question will come in exam what to write what is the proper answer.