An ERD has m number of entities (strong, weak, parent, child all combined) andn number of relationship types (of all possible kinds). When transformed to the relational schema, Database designer come up with a solution which contained more than m+n relations. What could possibly be the reason? If you think the designer did a mistake then you can say that in your answer. Explain your answer if you think that will help. Answer:

An ERD has m number of entities (strong, weak, parent, child all combined) andn number of relationship types (of all possible kinds). When transformed to the relational schema, Database designer come up with a solution which contained more than m+n relations. What could possibly be the reason? If you think the designer did a mistake then you can say that in your answer. Explain your answer if you think that will help. Answer:

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Attributes from the identifying entity set's main key may be added to a weak entity set to make it strong. Please describe the overlap that will develop as a result of our choice.
Give an SQL schema definition for the employee database of Figure 3.19.Choose an appropriate domain for each attribute and an appropriate primarykey for each relation schema. Include any foreign-key constraints that might beappropriate.
Describe entity integrity constraint in your own words.
List five properties of relations.
Discuss how traceability relations are classified, elicit a brief example that defines the classification context, and draw a diagram if necessary.
What are three signals that a surrogate key should be generated for the primary key of a relation instead of using the main key?
Develop an Entity Relationships Diagram (ERD) based on the relational schemas in the 3NF for the starting relational schema in un-normalized form presented below. UNF:Order(OrderID, OrderDate, CustID, CustName, CustPhone, CCNum, CCExpDate, CCBank, BnkContName, BnkContPhone, CustEmail, OrderIP, SiteRefFrom, ShipStreet, ShipCity, ShipSt, ShipZip, OrderLineNum, ItemID, ItemName, ItemDesc, ItemQtyOrdered,ItemListPrice, ItemSalePrice, ItemQtyShip, ShipCharge, Tax, TotalDue)
Explain the use of the terms relation, tuple, and attribute.
Explain how functional dependencies may be used to indicate: • The entity sets student and teacher have a one-to-one relationship set.• Between entity setsstudent and teacher, there is a many-to-one connection set.
Translate the following ER Diagram into relational model. Show different relations that will result in addition to their attributes, PKs and FKs. Newspaper AK newsPaperID newsPaperName newsPaperAddress Work for Actor Joumalist AK actorID AK journalistID -interview- firstName journalistName lastName dateOFbirth nationality write Edition Article -publishedIN- AK editionID PK articlelD editionDate article Title related To Topic AK topicID topicWording
Answer in Sql - ER diagram in database tables.
What is the link between the main key of a relation and the functional connections between all of its attributes?