Tag: DBMS
Database 2018 (Make up)
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 […]
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 ReadingUnit 4: Integrity Constraints
Integrity Constraints Integrity constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other processes have to be performed in such a way that data integrity is not affected. Thus, integrity constraint is used to guard against accidental damage to […]
Continue Reading