Can someone help me with the following question.

I have the following ER diagram and now need to apply the following exceptions

1) We wish to add the attribute main skill to the Droid table, and every droid of the same type has the same main skill.

2) We wish to add the attribute hyperspace capability to the Vehicle table; this attribute will be true or false depending on whether the vehicle has hyperspace capability. All vehicles of the same type have the same hyperspace capability.

3)Only Jedi/Sith can use lightsabers.

4) Only Jedi/Sith can hold a position in the Jedi Council (political unit).

5)We wish to know the starting year and final year for the positions held by characters in political units. Obviously, the final year must be no earlier than the starting year.

6)Similarly, in any mentorship, the final year must be no earlier than the starting year.

Question 1.

Provide an ER model for the above database. All attributes of each entity set and relationship set must be shown. All keys must be shown for each entity set. All key and participation constraints must be shown for each relationship set. In addition, write a paragraph specifying any necessary overlap and covering constraints and Based on the ER model, specify a relational schema for the database.

Weapon wcolour UsesW lias Character Home Planet gender sociatedWi UsesV name vtype evel JediSith Droid Vehicle VUsedIn Battle vear dtype IoldsPosition apprentice mentor Mentorship Winner om to pprovedBy PoliticalUnit utype Weapon wcolour UsesW lias Character Home Planet gender sociatedWi UsesV name vtype evel JediSith Droid Vehicle VUsedIn Battle vear dtype IoldsPosition apprentice mentor Mentorship Winner om to pprovedBy PoliticalUnit utype