I need help quickly with these DATABASE mini project?

This is broken down into two (2) tasks. The first is to diagram a database from a description. The second is to take an existing diagram and fix it.

Task 1

You have been presented with a database wish list from your supervisor. The conversation went something like this (this really happened IRL):

Supervisor: I need a database.

You: OK. What kind of database?

Supervisor: It needs to hold some data.

You: OK. What kind of data?

Supervisor: I will give you a spec in a few minutes. However, it needs to be done in PostGreSQL and I want a diagram so that I understand what is being proposed

You: OK?!?

You have to take into account at this point that we are a PostGreSQL shop and that my supervisor has no idea how to read an ERD. When asked why PostGreSQL, he responded apparently it is better. That is what he read in an industry magazine..

You were presented with a stack of notes that outlined the spec. After spending an hour digging through it, you realized that your supervisor wanted a project tracking database. The following items were identified.

Project - Project name, base time estimate, creation date, start date, end date, drop-dead date, description, status

Project status a description of the various project statuses

Users name, username, password, email, access level

Access levels a description of each access level

Project tasks task name, project it is connected to, creation date, last modified date, description, detailed task list, assigned user, priority level (which may need to be created)

Notes and Comments these are supposed to be attachable to any other database object.

Task 1 Deliverables

You will provide a pgModeler diagram exported as a PNG.. You will be graded as follows:

5 Points - Completeness of design (did you cover all the basics)

5 Points - How well normalized is the design (Is the database properly diagrammed)

5 Points - Proper diagramming & structure (naming conventions, etc.)

1 Point - Naming the file correctly. The file should be named: Last Name - First Name - Assignment 1 Task 1.png

Task 2

You have been handed a diagram by a junior developer. Apparently, he wasnt paying attention in his introductory database class and created a diagram that makes you want to cry. Fix the attached diagram and submit an exported diagram. Fix as many issues as possible. Export the fixed diagram as a PNG.

. You will be graded as follows:

5 Points - How well normalized is the design (Is the database properly diagrammed)

5 Points - Proper diagramming & structure (naming conventions, etc.)

1 Point - Naming the file correctly. The file should be named: Last Name - First Name - Assignment 1 Task 2.png