NOTE::::::

I do not want you guys to solve it

but can you guys give me academic advise on how to touch this one maybe show me an example.

----------------------------------------

this second phase, you will produce a relational schema from the entity-relationship diagram you came up with in Phase 1, and verify all use cases are being realized. Make sure to address issues (remarks) raised by your instructor in the first phase, if any.

Submit the following:

(1) Complete E/R diagram from Phase 1 (20 points)

On you E/R diagram, clearly describe each entity (including, list of entity attributes, the entity primary key, and any foreign keys) and each relationship with its multiplicities.

(2) Relational Model (20 points)

Using the method for translating an E/R diagram to relations, produce a set of relations for your database design. As usual, please be sure to underline key attributes in your relations.

(3) Complete Database Functionalities and User Interface (20 points)

(a) List all actors (i.e. users) of your database

(b) For each actor, list all use-cases including all the steps. For each entity, you must have use cases that perform at least one aggregate query, one insert operation, one delete operation, and one update operation; For each relationship, you must have use cases that perform at least one joint query.

(c) Specify the web interface if you are required to implement it.

(4) Use Case Realization (20 points)

Provide

(5) Database Prototype (10 points)

(a) Describe platform and any software tools you plan to use to implement your project.

(b) Clearly indicate how you plan to populate your database.

(6) Project Time Table (10 points)

(a) List major tasks to a be completed

(b) For each task, indicate team member responsible for competing task and completion data.