Refer to Problem and Exercise 2-44 in Chapter 2, Part f. Redraw the ERD for your answer to this exercise using appropriate supertypes and subtypes.
In Exercise 2-44 Part f
You may see various additional capabilities for the VC database. However, in the final phase you will consider in this exercise, you are to create an expansion of the ERD you drew for phase three to handle the following:
• Not all sites are public; that is, open for anyone to create an account. A person may create one or more sites as well as groups, and then invite other persons in a group to be part of a site he or she has created. A group has a Group ID, Group Name, Date Created, Date Terminated, Purpose, and Number of Members.
• The person creating a "private" site is then, by default, the site administrator for that site.
• Only the members of a group associated with a private site may then create accounts for that site, post to that site, and perform any other activities for that site.