Q1: Create an ER Diagram and Relational Schema and 2 tables with Data to show participations.

Two entities:

Manufacturer with two attributes Unique ManufacturerID and ManufacturerName

Model with two attributes Unique ModelID and Color

Each Manufacturer can have zero to many models and each product can have either zero or 1 brand

Q2: Create an ER Diagram and Relational Schema and 2 tables with Data to show participations.

Two entities:

Student with two attributes StudentID, StudentName

Degree with two attributes DegreeID, NameofDegree

Student must have at least one degree and each degree can have zero to many students