Member Avatar for wwwmadeasy

hi i need to undresdatn the relation which mention in that table which i attached plzzz.... any one.


thanks inadvance...

mysql.jpg 249.36 KB
  • 2 Contributors
  • 3 Replies
  • 77 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by Salem

Dani AI

Generated

asked for help with the attached diagram and noted five relationships. Interpreting each connection is best done with a simple checklist applied to every line: identify the two entities and their primary keys; decide which side is "many" (look for a crow's foot or the table that carries the foreign key); decide if the relationship is optional (FK allows NULL or the diagram shows 0..1) or mandatory (FK NOT NULL or 1); and check whether the link has attributes (if it does, treat it as an associative entity and model it as a separate table).

Common implementation patterns to map diagram lines to MySQL tables:

  • One-to-many: place the foreign key on the "many" side.
  • One-to-one: use a unique foreign key or share the primary key.
  • Many-to-many: introduce a junction table that holds the two foreign keys and any relationship attributes.

Example DDL fragments:

CREATE TABLE parent (
  id INT PRIMARY KEY
);

CREATE TABLE child (
  id INT PRIMARY KEY,
  parent_id INT,
  FOREIGN KEY (parent_id) REFERENCES parent(id)
);

CREATE TABLE student (
  id INT PRIMARY KEY
);

CREATE TABLE course (
  id INT PRIMARY KEY
);

CREATE TABLE enrollment (
  student_id INT,
  course_id INT,
  grade CHAR(2),
  PRIMARY KEY (student_id, course_id),
  FOREIGN KEY (student_id) REFERENCES student(id),
  FOREIGN KEY (course_id) REFERENCES course(id)
);

Quick troubleshooting and cautions: both FK and referenced columns must have compatible types and signedness; the referenced column must be indexed (PRIMARY or UNIQUE); use InnoDB for foreign keys in MySQL; be careful with ON DELETE CASCADE as it can remove more rows than intended. To follow up on 's comment, make a short mapping sheet (left table, right table, FK side, cardinality, nullable, notes). Posting that mapping will let others correct assumptions quickly.

Recommended Answers

All 3 Replies

Member Avatar for wwwmadeasy

plz if u can explain all the relations i will be thanks full to u

Member Avatar for Salem

Can't you post what you think you understand about them, then we can correct and inform you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.