So, a total of 3 tables are required for the given entity relational diagram. One shall practice these interview questions to improve their concepts. Here we have 1 to Many relation so we requires two tables.Īttribute B being multi-valued, we need to remove the multi-valued attribute B to convert the given entity-relationship diagram into a relational database.Īs relational database do not allow multi-valued attributes. This section of interview questions and answers focuses on Database Management System. Found 251 Questions for DBMS Difference between Static and Dynamic Hashing What are the differences between HBase and Cassandra What is Hierarchical. But, entity R 1 contains multivalued attribute B, due to which one table for this is also needed. So, two tables are required for two entities. Fully solved examples with detailed answer description, explanation are given and it would be easy to understand. There is one to many relationships between R 1 and R 2. DBMS questions and answers with explanation for interview, competitive examination and entrance test. Rules for finding a minimum number of tables required for an ER diagram:ġ) A strong entity with single or composite attributes requires one table.Ģ) A strong entity with multivalued attributes requires two tables.ģ) In the case of many to many relations between two entities, 3 tables are required.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |