Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Given the following relationsTRAIN (NAME, START, DEST)TICKET (PNRNO., START, DEST, FARE) PASSENGER (NAME, ADDRESS, PNRNO.) Write SQL expressions for the following queries: Note: Assume NAME of Train is a column of Ticket.(i) List the names of passengers who are travelling from the begin to the destination station of the train.(ii) List the names of passengers who have a return journey ticket.(iii) Insert a new Shatabti train from Delhi to Bangalore.(iv) Cancel the ticket of Tintin.
(i) SELECT P.NAME FROM TRAIN T, TICKET I, PASSENGER P WHERE P.PNRNO = I.PNRNO AND T.NAME = I.NAME AND T.START = I.START AND T.DEST = I.DEST (ii) SELECT NAME FROM PASSENGER WHERE PNRNO IN (SELECT DISTINCT A.PNRNO FROM TICKET A, TICKET B WHERE A.PNRNO = B.PNRNO AND A.START = B.DEST AND A.DEST = B.START) (iii) INSERT INTO TRAIN VALUES(‘Shatabdi', ‘Delhi', ‘Banglore' (iv) DELETE FROM TICKET WHERE PNRNO = (SELECT PNRNO FROM PASSENGER WHERE NAME = ‘Tintin')
Example: //REVOKE ALL ON EMP FROM MCA12; (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-
Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update
Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element
Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation. It is an abstraction by which relationships are treated as higher level
What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For
Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:
Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These
Single Valued Normalisation Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati
how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?
Storage Of Database On Hard Disks At this point, it is worthwhile to note the difference among the terms file Organisation and the access method. A file organisation shows to t
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd