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')
explain participation constraints with examples
What is called a query evaluation plan? A sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query implementation plan.
Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?
The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi
properties of derirable decomposition
Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena
can you create a database for me in oracle/sql
Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people
Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include
What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd