Scribd
Upload
14 views1 page

Assignment 4

The assignment requires the development of 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 populate the tables with data, execute queries, and display the join table to demonstrate the 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
14 views1 page

Assignment 4

The assignment requires the development of 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 populate the tables with data, execute queries, and display the join table to demonstrate the 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/ 1

Information Technology Department

‫كلية تكنولوجيا الصناعة والطاقة‬ Second Year ‫جامعه برج العرب التكنولوجيه‬

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

Semester:2nd term 2024/2025 Lecturers: Dr. Nehal El Azaly

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