You will need two files - a Word document for steps 1 and 2 and an SQL script file for Step 3. This project needs to be done using Oracle Application Express--the SQL script file is important. Ideally, I would like to pay $20.00--this is a the perfect project for those wanting to gain a good reputation on Freelancer .
1. Convert THE ER MODEL ATTACHED TO THIS ASSIGMNET to a [url removed, login to view] schema has to be an exact representation of the ER model attached here. You can add 2-3 attributes as appropriate to the entities.
2. Critique the ER model attached.
What can you do to improve this model?
Take a look at the report from Assignment 1--see assessmentReport.txt. Are there any items in the report that are not modeled by this ER model? Discuss in a couple of sentences what you can do to improve the model.
Step 3. Build an SQL script that does the following:
drop all tables
create all tables (as designed in step 1)
insert at least 1 record in every table .