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:questions and answerts on transaction porocessing in dbmsquestions on transaction in dbmstransaction gate questionstransaction gate quespractice question on transaction on databasegate dbms topic wisedbms numerical of transactiontransaction processing gate questions dbmstransaction related question in gatetransactions processing gate question

Previous GATE Questions on SQL 1997 – 2008 with Answers Incoming search terms:gate questions on database management systemgate dbms qustiondbms gate levelall sql query questions in Gate examsgate mcqs on dbmsGate problems solved dbmsgate questions on dbms with answersgate sql questuonsobjective question ask in gate from dbmsq asked in gate for database with solution