Tag: database
Database || Old Paper solution 2017
13. a. select pname from parts as p, suppliers as s, catalog as c where p.pid = c.pid and c.sid = s.sid GROUP by s.sid having count(p.pid) = 1; b. select sname from suppliers as s, catalog as c, parts as p where c.sid = s.sid and p.color = ‘red’; c. update catalog set cost […]
Continue ReadingDatabase Notes || BIM
Question paper Solution Pre- board Paper SYLLABUS YEAR2023 Syllabus Here 1st Reference Notes Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 2nd Reference Notes Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6
Continue ReadingDatabase || Old paper solution 2016
16. a) insert into users(‘Ram’, ‘12345’, ‘[email protected]’, ‘2002-01-01’, ‘m’, curdate()); b)SELECT * from users where dateOfBirth < ‘2000-01-01’; c) select categoryName from categories where categoryID not in (select categoryID from expenses)); d)select username from users where in(select userID from expenses where amount < (select amount from expenses where userID = 405)));
Continue Reading