Scribd
Upload
9 views2 pages

Assignment 4

The assignment requires students to develop a many-to-many relationship in a MySQL database named 'Store'. It involves creating two tables: 'professors' with four fields and 'courses' with two fields, along with a join table 'professors_courses' that connects the two. Students must fill in data, display individual tables, and use join commands to illustrate the many-to-many relationship.

Uploaded by

Alaa Hawary Mohamed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

Assignment 4

The assignment requires students to develop a many-to-many relationship in a MySQL database named 'Store'. It involves creating two tables: 'professors' with four fields and 'courses' with two fields, along with a join table 'professors_courses' that connects the two. Students must fill in data, display individual tables, and use join commands to illustrate the many-to-many relationship.

Uploaded by

Alaa Hawary Mohamed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

‫ كلية تكنولوجيا الصناعة‬Information Technology DepartmentSecond Year ‫جامعه برج العرب التكنولوجيه‬

‫والطاقة‬

Course: Introduction to Database Assignment (4) Many to many

Lecturers: Dr. Nehal El Azaly


nd
Semester:2 term 2024/2025

Q1: Develop many-to-many relationship using My sql


database and set its name as Store that database file
has two tables: the first table is professors table has
four fields
a- Professor_id b-
Professor _name c-
Email d- Address
Also,the second table is courses table has two fields

a- Course_id
b- Course_name
Moreover the Join table is professors_courses table has
four fields

a- Professor_id
b- Course_id
Fill the demanded data and display the individual tables
with determined queries and use join command to make
the many to many relation in addition to display the
join table.

Page 1 of 1

You might also like