Sample Homework

• Use a <pre><code>...<\pre><\code> block for code and SQL answers. When writing SQL code, capitalize SQL keywords.

  
              SELECT DISTINCT student.ID
              FROM (student JOIN takes USING (ID))
                  JOIN (instructor JOIN teaches USING(ID))
                  USING (course_id, sec_id, semester, year)
              WHERE instructor.name = "Einstein"
          

• Use the same <pre><code>...<\pre><\code> block when writing JSON for MongoDB answers.

            {
                name:    "Jane Doe",
                title:   "CIO",
                address  {
                    street:  "Baltic Ave.",
                    city:    "Atlantic City",
                    State:   "NJ"
                }
            }              
        

• For Relational Algebra solutions you must use HTML symbols for the special characters.
  1. Π_title (σ_{dept_name="Comp.Sci" ∧ credits=3}(course))
  2. Π_ID(σ_{ID="Einstein"}(takes ⋈ ρ_{(IID, course_id, section_id, semester, year)} teaches))