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
Step: 1
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