Relational schema / dependency diagram

  • Thread starter Thread starter Firestrider
  • Start date Start date
  • Tags Tags
    Diagram
Click For Summary

Discussion Overview

The discussion focuses on the creation of relational schemas and dependency diagrams from entity-relationship (ER) diagrams. Participants explore the definitions, purposes, and processes involved in these conversions, as well as resources for further assistance.

Discussion Character

  • Technical explanation
  • Conceptual clarification
  • Homework-related

Main Points Raised

  • One participant requests resources for creating relational schemas and dependency diagrams from ER diagrams.
  • Another participant suggests that searching for "ERD" will yield numerous helpful resources, providing specific links to websites that may assist with varying levels of difficulty.
  • A participant questions whether a relational schema and dependency diagram are equivalent to an ERD, indicating a need for clarification on the relationship between these concepts.
  • It is noted that an ERD serves to illustrate the relational schema and dependencies among data entities, emphasizing the importance of understanding how entities interact and the relationships between tables and attributes.

Areas of Agreement / Disagreement

There is no consensus on whether a relational schema and dependency diagram are the same as an ERD, as this question remains open for further clarification.

Contextual Notes

The discussion does not resolve the relationship between relational schemas, dependency diagrams, and ERDs, leaving the definitions and connections somewhat ambiguous.

Firestrider
Messages
104
Reaction score
0
Can someone link me to a website that can show me how to make a relational schema and dependency diagram from a E-R diagram?
 
Physics news on Phys.org
So a relational schema and dependency diagram is the same as a ERD?

Basically I have to convert a ERD to 3NF showing relational schema and dependency diagram.
 
ERD stands for entity-relationship diagram. The purpose of the ERD is to show the relational schema and dependencies between the data entities in a succinct but precise manner.

To make an ERD, one would require how the entities work together, i.e. the relationship between different data, including the tables, the keys, the relationship between the table attributes. For example, a teacher teaches one or more classes, a student attends zero or more classes, a transcript is dependent on zero or more class marks and the student ID, etc.

From established business rules, an ERD displays the characteristics and relationships between the different entities.
 

Similar threads

  • · Replies 12 ·
Replies
12
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 12 ·
Replies
12
Views
3K
  • · Replies 48 ·
2
Replies
48
Views
6K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 31 ·
2
Replies
31
Views
4K
  • · Replies 2 ·
Replies
2
Views
5K
  • · Replies 6 ·
Replies
6
Views
3K