1. Write the relational schema and draw the dependency diagram for the 1NF (first normal form) INVOICE table (see below), following the example from the material provided above. - You may use whatever tool you like to create the diagram--draw.io, Word, Excel, etc. 2. Determine the TWO partial dependencies that you can 'pull out' into two new tables. - Technically there are three partial dependencies, but one of them remains in the original table. As usual, we'll discuss in class. 3. Write the relational schemas for both the 1 NF form (single table) and the 2 NF form (three tables). 1. Example relational schema using the Employee table from the slides: 1. EMPLOYEE (EMP NUM, EMP_NAME, JOB_CLASS) 2. The general form is: 1. TABLE_NAME ( [list of attributes, with PK underlined and FKs italicized] )