We need to create a new database project where we have to describe the enterprise and then we need to draw a ER diagram and then we need to write conceptional view ( primary key, list of foreign keys, and list of functional dependencies ) and then we also have to implement all those tables in Oracle. The queries should consists of all
a ) Joins
b) Usage of advanced SQL features
c) Built-in functions
d) Input from the user
e) The brilliance of your solution
You must also have
f) At least one insert
g) At least one update
h) At least one delete option
i) At least one data obsolescence command.
You must implement your queries using Java/JDBC. You must have at least one
program/subprogram for each user you define.
13 freelancers are bidding on average $51 for this job
Please check my profile and you will see hundreds of work done before like this type of assignment. I am oracle certified developer and dba. Let me know.