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. … Read more
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 … Read more
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 … Read more
Differentiate between Database approach v/s Traditional file accessing approach. (RGPV Nobember 2019) Database Approach Traditional File Approach All Application shares a pool … Read more
RGPV 2018Define database management systems (DBMS). What are the major components of this system ? Explain each component. Ans. A DBMS is used for storing, … Read more
RGPV 2019Q. Explain the concepts of Primary key, Foreign key and Integrity constraints ? Ans. If there is relation between table than it must have … Read more
RGPV 2019Q. What do you mean by data modelling ? Compare different data models ? Ans. Data modeling is a way to create data model for … Read more
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 … Read more
RGPV 2019Q. Differentiate between Database approach vs Traditional file accessing approach ? Ans. Database approach Traditional file accessing approach All Application shares a pool of … Read more