Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Virtual Campus ( VC ) is a social media firm that spe - cializes in creating virtual meeting places for students, faculty, staff, and others
Virtual Campus VC is a social media firm that spe cializes in creating virtual meeting places for students, faculty, staff, and others associated with different col lege campuses. VC was started as a student project in a database class at Cyber University, an online polytechnic college, with headquarters in a research park in Dayton, Ohio. The following parts of this exercise relate to dif ferent phases in the development of the database VC now provides to client institutions to support a threaded discussion application. Your assignment is to draw an ERD to represent each phase of the development of the VC database and to answer questions that clients ra ised about the capabilities business rules of the da ta base in each phase. The description of each phase will state specific requirements as seen by clients, but other requirements may be implied or possibly should be inplemented in the design slightly differently than the clients might see them, so be careful to not limit yourself
to only the specifics provided.You may see various additional capabilities for the VC database. However, in the final phase you will con sider 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 per sonsinagrouptobepartofasiteheorshehascre ated. A group has a Group ID Group Nane Date Created, Date Terminated, Purpose, and Nunber of Members.
The person creating a "private" site is then, by default, the site administrator for that site.
Only the menbers of a group associated with a pri vate site may then create accounts for that site, post to that site, and perfom any other activities for that site.
Redraw the ERD for your answer to this exercise using
appropriate supertypes and subtypes.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To design the ERD EntityRelationship Diagram for Virtual Campus VC using appropriate supertypes and subtypes we need to address the following key elements Supertypes and Subtypes Person supertype can ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started