Question

1. Given tables math_majors create a view called math_view consisting of all of the data in math_majors PLUS a column called sci_ratio which is computed as sci credits/math credits.
2. Given table sci_majors create a view called sci_view consisting of all of the data in sci_majors PLUS a column called math_ratio which is computed as math credits/sci credits.

Answer 1

Making the following assumptions, since schema is not provided:

- math_majors table has columns named math_credits and sci_credits

- sci_majors has columns named math_credits and sci_credits

If these assumptions are not valid, please share further details via comments so answers can be fine-tuned if necessary. Here are the views:

CREATE VIEW math_view AS

SELECT *, sci_credits / math_credits AS sci_ratio FROM math_majors

CREATE VIEW sci_view AS

SELECT *, math_credits / sci_credits AS math_ratio FROM sci_majors