Comment/Recommendation

Question 1: Validation of the propositions

You have understood and validated the propositions by distinguishing the correct answers from the incorrect ones. The explanations on the columns, the primary keys and the integrity constraints are very well formulated.

Question 2: Anomalies in the structure of the employee table

Your analysis of anomalies related to redundancy and updates is precise. The creation of separate tables for functions and recruitment levels is well thought out and allows for an improvement in the structure of the database.

## Question 3: SQL table manipulation

Your SQL commands to create the "GestElections" database and its tables are correct and well structured. The addition of the "Datevote" column, the expansion of the "Appelation" column and the division of the "NomPrenElv" field are well executed.

Proposal for voting statistics by gender

Your proposal to add a "Gender" column and update the data is relevant and well justified. This allows for effective analysis of votes based on gender.

Overall, your answers show a very good command of relational databases and SQL manipulation. They are clear, precise and demonstrate a good understanding of the underlying concepts. underlying.

Total| 8/10