Few beginner questions

After reading over and over the documentation and videos still cannot figure out how basic stuff works so I appreciate a help at least for the questions below. I am not struggling with some advanced stuff I am just trying to create the base setting for the db hierarchy. I have one top level table with the ids of all tables and 10 sub tables out of which 3 of them have relations . My questions at the moment ??

1. How do you create a view? Using sql command or vie explorer/designer?
2. How do I set 1:n or n:m and have the option of lookup ?
3. How do I customize (not styling) the project view in the front end?
4. In 1:n and n:m front end app shorcode is not working is that limitation?
5. Is there any difference when using templates when using one default template for all tables in the project vs different template for every table
6. I have created a project with 5 pages. Each page is related to the other. How do I display them on one page in front end and back end?
7. In the project I have named the project A and inside the project I have create 5 sub pages out of which one is the main table. When I add the project in the front or back via shortcode the dropdown menu lists all the sub pages on the same level. Is it possible or how do I achieve so the sub pages related to the main page show below it. Hope I described it correctly.
8. In 1:n and n:m how do I display rest of the data from the columns other then related columns in the relations?

These are just some question at the moment, but I am sure I will have more ??

Thanks everyone that could help me move a bit forward out of this deadlock.

Alex