Create a view my view from equivi join of all 4 tables (School, Stu_info, Department and...

  

Transcribed Image Text:

Create a view my view from equivi join of all 4 tables (School, Stu_info, Department and stu_dep) Retrieve all data from my_view Create index on student table using student name and show index detail Department - Notepad File Edit Format View Help OP_ID,SH_ID D001,SH001 D002,SH002 D003,SH001 D004,SH003 Dees,SH004 Stepl: Each table has primary key Step2: See the data properly and decide primary key and foreign key of those tables Step3; Create these tables in the sql using primary and foreign key (Use above hint to create more than one foreign key in your table) Now answer following question How many departments are there in each school How many school are there in Newark How many students are there in RBHs How many males/females are there in each school Create a view my view from equivi join of all 4 tables (School, Stu_info, Department and stu_dep) Retrieve all data from my_view Create index on student table using student name and show index detail Department - Notepad File Edit Format View Help OP_ID,SH_ID D001,SH001 D002,SH002 D003,SH001 D004,SH003 Dees,SH004 Stepl: Each table has primary key Step2: See the data properly and decide primary key and foreign key of those tables Step3; Create these tables in the sql using primary and foreign key (Use above hint to create more than one foreign key in your table) Now answer following question How many departments are there in each school How many school are there in Newark How many students are there in RBHs How many males/females are there in each school

Answer rating: 100% (QA)

It appears that youre asking for help with a SQLrelated assignment that involves several steps Lets break down the task into these main steps 1 Create ... View the full answer