In: Computer Science
Indicate if the following statements are true or false. For false statements, explain why the statement is false or give the correct answer.(1 point each)
6. A simple attribute can be broken down into smaller components.
7. The relationship between a weak and strong entity is called a multiple relationship.
8. An identifier is a combination of two or more attributes from two tables.
9. A unary relationship must have mandatory many cardinality on both sides.
10. If two entities are related many to many, we take the primary key of each entity and make it a foreign key in the other.
11. Compare and contrast overlap rule and disjoint rule. Compare and contrast total and partial specialization. (2.5+2.5=5 points total)
Q6:false
It is false because the Composite attribute can be broken down in to simpler components.simple attributes can't be divided.
Q7:false
False because the relation between the strong entity and weak entity is called identifying relationship
Q8:false
False because identifier is the name of objects,it is the name given by database designer or system users to data base objects such as tables, views etc
Q9:false
The Unary relationship is when both participants in relationship are same. So not mandatory and not have many cardinality
Q10:True
The primary keys in each entities and make foreign in key in many to many.
Q11:a)disjoint rules states that an entity instance of an super type can only be a member of one sub type. The overlap rules states an entity instance of a supertype can be a member of multiple subtypes
Disjoint events are events that don't have any outcomes in common. and overlap have outcome in common.
B) total specialization rule demands that every entity in the super class. Symbolized with a double line
Partial specialization exist when every instance of a super type does not have to be an instance of a subtype