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/…

GATE Questions on Transaction Management in DBMS with answers 1997 – 2008 Incoming search terms:gate questions for dbmsquestions on transaction in dbmsdatabase relted gate questiondbms questions for practice topic wisetransactiion sample sloved gate queationstransaction question in dbmstransaction related question in gate

MCQ on File Organization in Database Incoming search terms:file organization gate questionsmcq for file organization in rdbmsapplication questions on file organizationpast questions and answers on file organization in databasemultiple choice questions on file organisation with answersMcq on file organizationmcq of file organigation of dbmsfile organisation DBMS mcqdbms physical organization mcqquestions and answers related to file…

Previous GATE Questions on SQL 1997 – 2008 with Answers Incoming search terms:gate questions on database management systemdbms mcq for gate examgate dbms qustiondbms gate levelsql gate questionsdbms previous gate questionsdbms multiple choice questions with answers for gatedbms mcq for gatedbms gate questions answersdatabase relted questions in gate exam