Relational Algebra Queries Examples Question 1 : Consider the following relational Schema and give the answers of following : Dealer(Dealer_no, Dealer_name, Address) Part(Part_no, Part_Name, Color) Assigned_To(Dealer_no, Part_no, cost) a) Find names of dealers that supply red parts. Answer b) Find names of dealers that supply whole red parts. Answer c) Find names of dealers that…

Theoretical  Questions and Answers on DBMS Question 1: List four significant differences between a file-processing system and a DBMS Answer: A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the data A DBMS reduces the amount of data duplication A DBMS is designed to allow…

Database Index For GATE Students URLs OF The Topics Links : DBMS Introduction : http://www.edugrabs.com/database-and-dbms-introduction/ http://www.edugrabs.com/dbms-vs-file-system/ http://www.edugrabs.com/advantages-and-disadvantage-of-dbms/ http://www.edugrabs.com/components-of-database-and-functions-of-dba/ http://www.edugrabs.com/execution-steps-of-dbms/ http://www.edugrabs.com/components-of-dbms/ http://www.edugrabs.com/architecture-of-dbms/ ER Model : http://www.edugrabs.com/er-model-entity-relationship-model/ http://www.edugrabs.com/type-of-attributes-in-dbms/ http://www.edugrabs.com/types-of-relationships-in-er-diagram/ http://www.edugrabs.com/relationship-constraints-in-dbms/ http://www.edugrabs.com/entity-and-its-types/ http://www.edugrabs.com/composite-entity-example/ http://www.edugrabs.com/supertype-and-subtype/ http://www.edugrabs.com/identifying-and-non-identifying-relationships/ http://www.edugrabs.com/generalization-specialization-and-aggregation-in-dbms/ http://www.edugrabs.com/how-to-make-er-diagram/ http://www.edugrabs.com/er-diagram-questions-with-solutions/ DATA Models : http://www.edugrabs.com/data-models/ http://www.edugrabs.com/hierarchical-model/ http://www.edugrabs.com/the-network-model/ http://www.edugrabs.com/relational-database-or-relational-model/ http://www.edugrabs.com/schema-and-instance-in-database/ http://www.edugrabs.com/relational-database-or-relational-model-part-3/ DATABASE KEYS http://www.edugrabs.com/database-keys-in-dbms/ http://www.edugrabs.com/questions-on-super-keys/ CONSTRAINTS IN DBMS : http://www.edugrabs.com/types-of-constraints-in-dbms-or-relational-constraints/ http://www.edugrabs.com/database-operations-and-constraint-violations/ http://www.edugrabs.com/database-operations-and-dealing-with-constraint-violations/…

Previous GATE Questions on SQL 1997 – 2008 with Answers Incoming search terms:dbms multiple choice questions with answers for gatedbms previous gate questionsexam gate in database related questions and answersgate question on sql query videosprevious kerala university sql dbms solved questionsql gate question 2007sql multiple choice questions with answers for gate questionvideos on gate sql…