Create three tables in databse of Student,Course and Student Course .Write down the fields of your choice but meaningful

[answerhappygod]

Create three tables in databse of Student,Course and Student
Course .Write down the fields of your choice but meaningful. You
have to apply subqueries and set operations on it. So attributes
should be matching in some of the tables to apply set operation.
Write at lease 5 rows in each table and apply nested queries with
set operations. Also show the output of the queries .
SQL has directly incorporated some set operations
• There is a union operation (UNION), and in some versions of SQL
there are set
difference (MINUS) and intersection (INTERSECT) operations
• The resulting relations of these set operations are sets of
tuples; duplicate tuples are
eliminated from the result
• The set operations apply only to union compatible relations
;
– the two relations must have the same attributes and
– the attributes must appear in the same order