Home
Introduction
_Intro
_Team Members
Design a DBMS
_Identify of Entities
_Identify of Attributes
_Identify of Relationships
_ER Diagram
Requirements to develop a software
_Actors in the sytem
_Business Processers
_Functional Requirement
_Non-Functional Requirement
Programming with SQL
_Normalization & Relational Schema
_create & insert statement
_SELECT, UPDATE & DELETE queries
Conclusion
Home
Programming with SQL
Select, Update and delete queries
Select, Update and delete queries
K. Sahan srimal
April 18, 2022
Removal of passenger's last name as Rajapaksa No. 40004444.
UPDATE Passenger SET LastName = null WHERE PassengerID = 40004444;
Flight F444, scheduled for May 22 in Sydney, was canceled that day.
DELETE FROM Flight WHERE DestinationAirport = "Sidney";
View Currently aviation information.
SELECT * FROM Flight;
Programming with SQL
Post a Comment
0 Comments
Social Plugin
Team Mates
G.I.T.S.Gammanpila
G.T.T. Dilhani
K. Sahan srimal
Uvindu Apsara
W.M.D.K.Wanigasekara
W.S.gavindya
Most Popular
Tags
conclusion
Design a DBMS
Introduction
Normalization & Relational Schema
Programming with SQL
Requirement to develop software solution
Contact form
0 Comments