4th sem Database – BIM Study Notes

Database 2018 (Make up)

August 3, 2021BIM NotesLeave a Comment

Group A 1. What is the advantage of Database Management System over File Management System?  The advantage of Data Management System over File Management System are: i. Data independence ii. Data integrity and security iii. Efficient data access 2. What is data independence?  Data independence is an ability to modify a schema definition […]

Database || Old Paper solution 2017

August 3, 2021BIM NotesLeave a Comment

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 […]

unit 5 || Relational Database Design

March 20, 2021BIM NotesLeave a Comment