This question is for the course titled "Modern Database Management, 12th Edition."

This question has four parts a, b, c, and d. Please answer all four parts, and don't forget the diagrams.

3-25. An electronics goods store has electronic devices, such as mobile phones, laptops, televisions, and refrigerators for sale. a. Is it possible to apply supertype/subtype hierarchy to the above situation?How? b. Construct an EER diagram. Which specialization rule (completeness constraint) does it satisfy? c. Can you think of any possible scenario in which the diagram satisfies the other specialization rule? d. Consider that the owner has decided to sell both new and old products for resale. How will you incorporate this into the diagram?