Search & Filtering
ii) Write an SQL query that returns the titles of articles authored by 'Robert Tarjan'.
b) Consider the relations Authors(auID,name) and Authoring(articleID,authorID), containing
information on names of authors, and who is authoring which papers, respectively.
i) Write an SQL query that returns for each article, its ID, title and the number of authors.
ii) Write an SQL query that returns the titles of articles authored by 'Robert Tarjan'.
iii) Write an SQL query that returns the number of co-authors of 'Robert Tarjan'. (I.e., the number of
authors who have written at least one article together with him.)
b) Consider the relations Authors(auID,name) and Authoring(articleID,authorID), containing
information on names of authors, and who is authoring which papers, respectively.
i) Write an SQL query that returns for each article, its ID, title and the number of authors.
ii) Write an SQL query that returns the titles of articles authored by 'Robert Tarjan'.
iii) Write an SQL query that returns the number of co-authors of 'Robert Tarjan'. (I.e., the number of
authors who have written at least one article together with him.)
Create algorithms for the following idea:
1. Development of technical and specialist professional skills- this can be arrived at by reinvigorating role in producing the specialist technical skills that are essential to fulfill its core functions and provide appropriate career paths for technical specialists.
a) Write SQL commands
1. To create the above table structure with proper constraints.
2. Select all the PROG type published by BPB from Library.
3. Display a list of all books with Price more than 130 and sorted by Qty.
4. Display all the books sorted by Price in Ascending Order.
5. Display a report. Listing Book No. current value and misplacement charges for each book in the above
table. Calculate the misplacement charges for all books Price*1.25
6. Count the number of books published by PHI
7. Insert a new book in the library.
8. Count the no of books in each Type.
9. Add one more attribute “No_of_copies” in the above table.
10. Update the new attribute value with 2 for each book.
11. Count the total number of Publishers.
Create algorithms for the following idea:
1. Stabilized political-administrative interface- this can be achieved through a focus on skills and professionalism by clarified political-administrative which ensures a clear separation between roles.
Create algorithm for the following idea:
1.The increase in life expectancy can be attributed to the constant improvement in the implementation of comprehensive strategies to combat the quadruple burden of diseases inclusive of communicable disease, primarily HIV and AIDS and Tuberculosis, and the reduction in infant and child mortality rates
Create algorithms for the following three ideas:
1. Stabilized political-administrative interface- this can be achieved through a focus on skills and professionalism by clarified political-administrative which ensures a clear separation between roles.
Create algorithms for the following three ideas:
1. Stabilized political-administrative interface- this can be achieved through a focus on skills and professionalism by clarified political-administrative which ensures a clear separation between roles.
#Write a program using two-dimensional arrays that lists the odd numbers and even numbers separately in a given 12 input values.
Sample input/ output dialogue:
enter twelve numbers
13 15 20 13 35 40 16 18 20 18 20 19
odds
13 15 13 35 19
Even
20 40 16 18 20 18 20
