d. Draw the dependency diagram. Show the partial and transitive dependencies if applicable

e. Identify possible entities and draw E-R diagram

f. Suppose that you want to design your database using two tables. Identify the primary keys for each table and show the outline of this database

Q4-2. College online system A college uses an online system to post homework for a given course. Imagine that for this course, we already have a flat database that stores all the different homework, along with their description, posting date, due date, and number of problems it consists of. Two homework cannot have the same description but can be posted and/or due on the same dates. The database looks like this. HWNumn Description PostDate DueDate NumProblems 09/08/2014 09/15/2014 2 Basics of the Simplex Method 09/08/2014 09/15/2014 3 Simplex Method Advanced 09/15/2014 09/22/2014 Sensitivity Analysis09/22/2014 09/27/2014 Intro to LP