Creating relationships using primary and foreign keys
A relationship in a data model is a connection between two entities. Entities are objects that represent real-world things, such as people, places, or things. Relationships can be one-to-one, one-to-many, or many-to-many.
A one-to-one relationship means that each entity in one table is related to exactly one entity in another table. For example, a customer table might have a one-to-one relationship with an address table. Each customer would have exactly one address.
A one-to-many relationship means that each entity in one table can be related to multiple entities in another table. For example, a product table might have a one-to-many relationship with an order table. Each product can be ordered multiple times.
A many-to-many relationship means that each entity in one table can be related to multiple entities in another table and vice versa. For example, a student table might have a many-to-many relationship with a course...
