Answered step by step
Verified Expert Solution
Link Copied!

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 in1plemented 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 Nan1e, Date Created, Date Terminated, Purpose, and Nun1ber of Members.
The person creating a "private" site is then, by default, the site administrator for that site.
Only the men1bers of a group associated with a pri- vate site may then create accounts for that site, post to that site, and perfom1 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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems An Application Oriented Approach Complete Version

Authors: Michael Kifer, Arthur Bernstein, Richard Lewis

2nd Edition

0321268458, 978-0321268457

More Books

Students also viewed these Databases questions