I need help with number 3,4,7,8,10, and 11.

If you don't know the language that is fine, I just need help with the written out logic of them.

Your assignment: Consider the JSON database in the file sampleUnivDB.jsonencodes in JSON the following tables: Department (dcode, dname, chair) Course (dcode, cno, title, units) Prereq (dcode, cno, pcode, pno) Class (class, dcode, cno, instr) Faculty (ssn, name, dcode, rank) Student (ssn, name, major, status) Enrollment (class, ssn) Transcript (ssn, dcode, cno, grade) Note that the The primary keys are underlined. The meaning of the primary key is that there cannot be two different tuples in the relation with identical values for the primary key. Some explanations of attributes (variable names) are as follows. Chair in Department refers to SSN in Faculty table. Instr refers to Ssn in Faculty table, and ssn in Transcript refers to Ssn in Student table. Class is a unique ID for each offering of a course. For example, a class with class 21may be an offering of CS 330, in which case, we may have a tuple like in the Class table. in Prereq table refers to in the Course table, i.e., they refer to courses. A example row in Prereq table is , which means that CS 450 needs CS 330 as a prerequisite course. Other foreign keys and meanings of the tables should be obvious Consider each of these table names (Department, Course, etc.) as predicates, with the interpretation that the predicate returns TRUE for a tuple if and only if this tuple is in the database table. For example, Enrollment(class, ssn) will now represent a predicate that evaluates to TRUE if the pair (class, ssn) is in the corresponding relation, and FALSE otherwise