Je recherche une personne pour effectuer les tâches suivantes :
Step 1: create your own database on the subject you like.
“Movies”. Tables could be films, actors, directors, audience...
“Sports”: Tables could be players, teams, matches...
“Music”: Artist, albums, songs….
Anything you like...
Draw E/R diagram
Step 2: Fill your database, choose a good DBMS (PosgtreSQL, Oracle, etc.)
The best is if it’s real data.
But even 20 random lines per table will be enough.
Give sql queries to fill it.
Step 3: Find interesting queries on your database
You must find queries that returned interesting results about your database
The queries must use triggers, PL/SQL (functions and/or procedures), Cursors, complex queries, embedded queries etc.
There should be more than 10 queries.
Draw some graph, diagram with the results (for example, with Excel).
1. A report with an introduction of the subject, the conceptual model and the relational logical model of the database, the queries, and their explanations for the most complex ones
2. A commented code file ".sql" with tables, data, queries and procedures.