Category: RGPV DBMS PYQ

Consider the following employee database

Consider the following employee database. (RGPV 2019) Employee (empname,street, city)  work (empname,companyname,salary)  company (companyname,city)  manages (empname,management).  Give an expression in the SQL for each request. i) Find the names of all employees who work for first Bank corporation. select employee.empname from employee, works  where employee.empname=works.empname  and companyname = ‘First bank corporation’. ii) Find the names, street […]

Explain select, project and division operations with examples.

Explain select, project and division operations with examples. (RGPV 2019) Ans. Select operations : Select operation displays the records for the condition. Select operation is denoted by sigma (σ). Syntax:  σcondition(TableName) Example: RollNo Name Brach 012 Jayesh CSE 013 Kunal ME 015 Dipali EC Input: σName=Jayesh(Student) Output: RollNo Name Brach 012 Jayesh CSE Project operation : Project operations displays […]

Explain the concepts of Generalization and Aggregation with appropriate examples.

Explain the concepts of Generalization and Aggregation with appropriate examples. (RGPV 2019) Ans. Generalization: Entities with common attributes can be merged into a generic or super type entity by generalisation.  For example, the entity EMPLOYEE is a super type of Professor, Conductor, and Engineer. The “IS-A” relationship between the subtype and the super type can be used […]

DBMS definition and major components | RGPV PYQ

RGPV 2018Define database management systems (DBMS). What are the major components of this system ? Explain each component. Ans. A DBMS is used for storing, manipulating, and managing data. Some examples of DBMSs:  MySQL,  Microsoft SQL Server,  Microsoft Access,  Oracle In DBMS an organized collection of structured information, or data, typically stored electronically in a […]

RGPV DBMS Explain the concepts of generalization and aggregation with appropriate examples

RGPV 2019Q. Explain the concepts of generalization and aggregation with appropriate examples ? Ans. Generalization: It is a bottom-up approach in which two lower level entities combine to form higher entity. In generalization, the higher level entity can also combine with other lower level entity to make further higher level entity. Generalization proceeds from the […]

RGPV solved Database approach vs Traditional file accessing approach

RGPV 2019Q. Differentiate between Database approach vs Traditional file accessing approach ? Ans.  Database approach Traditional file accessing approach All Application shares a pool of related and integrated data. Use separate data file for each application Minimal data redundancy – Separate data files are integrated in to a single, logical structure. Data redundancy – independent […]