Using create command design three specific table and the table structure is given below.
Table name- Book with Columns for ISBN / TITLE / PUB_YEAR / UNIT_PRICE / AUTHOR_NAME / PUB_NAME
Table name- Author with Columns for AUTHOR_NAME / COUNTRY
Table name- Publisher with Columns for PUB_NAME / PUB_ADD1
<See the Syllabus PDF above for Actual Data to be filled>
Write the SQL query to find the name of all publisher from Book relation.
Write the SQL query to display the name of all publisher using distinct clause.
Write the SQL query to find the names of author from the author table where the first two characters of names are ‘ba’.
Write the SQL query to display title of books published in year 2004.
Write the SQL query to display title of books having price between 300 to 400.
Write the SQL query to display title of books having price between 300 to 400 using operators.
Write the SQL query to display title of books with author_name and country published in year 2004.
Write the SQL query to display all title and (unit_price*10) as an attribute from book table using arithmetic expression.
Write the SQL query to add the new column in all three tables.
Study the concept of Views and their utility in DBMS, write the SQL query to design a view.
Write the SQL query to make the attribute ISBN as a primary key in Book relation.
Write the SQL query to display the all the titles of Books with price and year in descending order.
Write the SQL query to study the use of Delete and Drop command in DBMS
Study the concept of Triggers, cursors and stored procedures in DBMS.
Last updated 19 days ago
