4th sem Database – BIM Study Notes

IMG-4fb2ff2cedddf11ae7592b2c817a6fd2-V

likedin

Database 2018 (Make up)

August 3, 2021December 3, 2022BIM 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, 2021December 3, 2022BIM 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, 2021February 10, 2023BIM NotesLeave a Comment

error: Content is protected !!

Notice

Tag: 4th sem Database

Database 2018 (Make up)

Database || Old Paper solution 2017

unit 5 || Relational Database Design

Useful Links

Contact US