TOPIC : Collect one example for Mapping fro ER Model to Relational model.

SOCIAL NETWORKING SITE :

The given ER diagram consists of 5 entities namely, user, friend, account, media, and location.

  1. The user is identified by the id and contains name and password.
  2. The friend has its own user id and name.
  3. Each account has a name, password and site.
  4. A user can have several friends and accounts.
  5. The media uploaded by user has its id, name, date and size.
  6. Each location of the media consists of IP and drive.

__________________________________________________________________________________________________________________

        ER DIAGRAM :

Image

__________________________________________________________________________________________________________________

  RELATIONAL MODEL :

ENTITIES :

Image

RELATIONSHIPS :

Image

Advertisements