Database Management SystemTU Board 2021
a) Design an ER diagram of your choice. The ER diagram should contain at least five entities. Out of those entities, one should be weak entity. Your entities should have appropriate attributes…
10a) Design an ER diagram of your choice. The ER diagram should contain at least five entities. Out of those entities, one should be weak entity. Your entities should have appropriate attributes including primary key attributes, if any. There should be presence of one to one relationship, one to many relationship and many to many relationships in your ER diagram. b) Convert the ER diagram in Q. 19. a. into equivalent relational tables.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define transaction. Describe ACID properties with example. [1+4]TU Board 20265Explain physical data independence and logical data independence. [2.5+2.5]TU Board 20265What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]TU Board 20265Define schedule and serializability with example. How can you test the serializability? [2+3]TU Board 20265What is data model? What are its types? [1+4]TU Board 20265Define query processing and steps in query processing. [1+4]TU Board 20265