1. Write a SQL statement which joins the parts table with the supplier table and lists the part_no, name,description, and the supplier name (the name column from the supplier table) for all parts in the part table. The part_no column in the parts table is the primary key in the parts table, and this key has been exported to the supplier table where it is a foreign key. You should use an inner join for this query.

2. Write a SQL statement which joins the parts table with the supplier table and lists the part_no, name,description, and the supplier name (the name column from the supplier table) for all parts in the part table. You should return all rows from the parts table whether or not there are corresponding rows in the supplier table. You should use an outer join for this query.

3. Write a SQL statement which joins the parts table with the supplier table and lists the part_no, name,description, and the supplier name (the name column from the supplier table). Only return the parts supplied by 'Car Parts Inc.'. You should use an inner join for this query.

4. The faculty table contains faculty information and has a faculty_id as the primary key. The faculty_department table has the department assignments for faculty members and has the faculty_id from the faculty table as an exported key or foreign key. The department table has information about departments and has a department_id column as its primary key. The faculty_department table also has the exported key or foreign key for the department table.

5. Write a SQL statement which joins the faculty table with the faculty_department table with the department table. Use an inner join for this query.