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!
Consider the relations given below Borrower (id_no, name)Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptions about the kind of the fields. Define the primary keys and the foreign keys. (b) For the above relations answer the subsequent queries in SQL What are the titles of the books borrowed through the borrower whose id-no in 365.(i) Find out the numbers and names of borrowers who have borrowed books on DBMS in ascending order in id_no.(ii) List the names of borrowers who have borrowed at least two books.
a) Create table Book (Accno int Primary Key, title char(30), author char(30), borrow-idno int references Borrower_id.no ); Create table borrower (id-no int Primary Key, name char(30) ); b) (i) Select title from Book, Borrower where Borrower.id_no =Book.borrower-idno and borrower.id_no = 365 (ii) Select id_no, name from Borrower, Book where Borrower.id_no= Book.borrower_idno and title= ‘DBMS' order by id_no asc; (iii) Select name from Borrower, Book where Borrower.id_no = book.borrower_id_no having count (*) > 2
Why does a DBMS query language is designed? A DBMS query language is designed to support end users who use English-like commands. support in the development of complex applicat
What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an
Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG
Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.
Example :; transfers transfer_amount from x's account to y's account ; Supposes x&y both accounts exist TRANSACTION (x, y, transfer_amount) Start transaction IF X AND Y
Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru
sir, could anybody help me in getting complete information about the mentioned topic
Which operator is used to compare a value to a list of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h
Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t
Before defines the second type of integrity constraint, viz., Entity Integrity, we should be well-known with the concept of NULL. Mostly, NULL is intended as a basis for dealing
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