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 dbmsquestions and answerts on transaction porocessing in dbmspractice question on transaction on databasetransaction gate questionstransaction related question in gatetransaction question in dbmstransaction management dbms gatetransactiion sample sloved gate queationsbest gate solve problem on recoverability…

MCQ on File Organization in Database Incoming search terms:objective questions on file organisationfile organization gate questionsmcq for file organization in rdbmsapplication questions on file organizationmultiple choice questions on file organisation with answersmcw on file organisationmcq of file organigation of dbmsMcq of filedbms physical organization mcqTeam and organisational dynamics on mcq file