PadhaiBy Astra Cloud
Menu
Search

TU

BSc CSITSyllabusNotesQuestions
BCASyllabusNotesQuestions
BITSyllabusNotesQuestions
BIMSyllabusNotesQuestions
BBASyllabusNotesQuestions
BBSSyllabusNotesQuestions
BBMSyllabusNotesQuestions
BITMSyllabusNotesQuestions

PU

BE Computer (PU)SyllabusNotesQuestions
BBA (PU)SyllabusNotesQuestions

NEB

Class 10SyllabusNotesQuestions
+2 ScienceSyllabusNotesQuestions
+2 ManagementSyllabusNotesQuestions
All universities and programs →

More

Ask a doubtNoticesGPA calculatorMy study

IT220 Database Management System

Database Management SystemTU Board 2021

Consider the following relation database. Author (AID, A Name, Age, Address, country) Publishes (AID, BID, publisheddate) Book (BID, B name, page, price) a. Find the Name of Author who is Not from…

4

Consider the following relation database. Author (AID, A_Name, Age, Address, country) Publishes (AID, BID, publisheddate) Book (BID, B_name, page, price) a. Find the Name of Author who is Not from 'Nepal'. b. Find the number of books written by each author. c. Find the name of Author who has published expensive book. d. Insert the detail of new Author.

A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.

Discussion

Loading…

More Database Management System questions

Define Data abstraction.TU Board 20231Define Candidate key.TU Board 20231Write the advantages of object relational data model.TU Board 20231Write a syntax to rename a table name in SQL.TU Board 20231Write a syntax for ORDER BY clause.TU Board 20231Write down the use of GROUP BY clause.TU Board 20231

All Database Management System old questions