an ERD with crowsfoot symbols that depicts a 1:M relationship between SCHOOLS and TEACHERS:

• Assume that any given school will have a minimum of 0 teachers and a maximum of 30 teachers.
• Assume that any given teacher is associated with one and only one school.
• TEACHERS are optional to SCHOOLS (i.e. you might enter a new school in the database before it hires teachers), but SCHOOLS are mandatory to TEACHERS (i.e. no teachers in the table unless they have an associated school).

Include all mandatory/optional and degree of participation symbols in your ERD. Your ERD should indicate all PKs and FKs.

 

2) Create the tables in one of your Orson DBs and submit images to prove you have correctly set the PKs, FKs and NN constraints for each table.

Note: some might consider the relationship to be M:N, but please answer this exercise assuming it is 1:M.