Explain how subtype/supertype relationships are converted to relations
What will be an ideal response?
When we have a supertype/subtype relationship, we need to assign one entity for the supertype and one for each subtype. The supertype has all attributes common to all subtypes as well as a primary key. Each subtype relation has the primary key of the supertype as well as any attributes that are specific to that subtype. Finally, we assign one or more attributes to the supertype to function as subtype discriminators.
You might also like to view...
Which of the following characteristics best defines talkative customers?
A. Customers who have definite ideas about what they want and are unwilling to compromise or accept alternatives. B. Customers exhibiting extroverted behavior and who are very people-oriented. C. Customers who seem to have their own agenda without concern for the feelings of others. D. Customers who take pleasure in being obstinate and contrary when dealing with service providers.
The ________ for a guest paying for a night's stay at a hotel is rest and sleep
A) generic product B) core product C) value-deliverable product D) augmented product E) actual product
If a corporation wants a guarantee that all of its shares of stock will be sold, it should use which of
the following distribution methods? A) privileged subscription with no standby agreement B) competitive bid purchase C) direct sale D) commission or best-efforts contract
Beginning in the 1840s, ________ permitted advertising on a national scale with high-quality reproduction.
A. store signs B. magazines C. newspapers D. handbills E. direct mailings