Question: Computer Science Database - ER Diagram I need help with creating an ER diagram under the below condition. Problem: Facebook maintains educational history on each

Computer Science Database - ER Diagram

I need help with creating an ER diagram under the below condition.

Problem:

Facebook maintains educational history on each user, which consists of programs and graduation year. Besides a unique program ID, each program also has a trio of fields: the institution, the major, and the degree (e.g. B.S.); this trio must be unique for every such program. Users may list any number of programs (including 0) in their educational history; and a program may or may not be listed in the educational history of any number of users. Facebook does not prevent users from listing different programs with the same graduation year; however, a user cannot list the same program multiple times with different graduation years.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!