Question 1 |

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

Diamonds with double/bold border | |

Rectangles with double/bold border | |

Ovals with double/bold border | |

Ovals that contain underlined identifiers |

Question 1 Explanation:

Question 2 |

In E-R model, Y is the dominant entity and X is subordinate entity

If X is deleted, then Y is also deleted | |

If Y is deleted, then X is also deleted | |

If Y is deleted, then X is not deleted | |

None of the above |

Question 2 Explanation:

Question 3 |

In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2.

Which one of the following is true about R?

Which one of the following is true about R?

Every entity in E1 is associated with exactly one entity in E2. | |

Some entity in E1 is associated with more than one entity in E2. | |

Every entity in E2 is associated with exactly one entity in E1. | |

Every entity in E2 is associated with at most one entity in E1. |

Question 3 Explanation:

Question 4 |

Which symbol denote derived attributes in ER Model?

Double ellipse | |

Dashed ellipse | |

Squared ellipse | |

Ellipse with attribute name underlined |

Question 4 Explanation:

Question 5 |

An ER model of a database consists of entity types A and B. These are connected by a
relationship R which does not have its own attribute. Under which one of the following
conditions, can the relational table for R be merged with that of A?

Relationship R is one-to-many and the participation of A in R is total | |

Relationship R is one-to-many and the participation of A in R is partial | |

Relationship R is many-to one and the participation of A in R is total | |

Relationship R is many-to one and the participation of A in R is partial |

Question 5 Explanation:

There are 5 questions to complete.