Mentoring and assistance for database design in Oracle SQL Database Modeler
€100 EUR
Finalizat
Data postării: circa 5 ani în urmă
€100 EUR
Plata la predare
We have an ERD and a conceptual diagram. Entities and attributes are generally correct. We need someone to check if the relationships between entities are correct and/or suggest changes.
After that we need to handle the 1:1, M:N relationships (provide solutions AND EXPLANATION of how you handled these relationships).
When we have the solutions for relationships, we need the design of logical diagram (no datatypes, or foreign keys here, only primary keys).
Next step is normalization to 3NF. In each step 0NF->1NF, 1NF->2NF, 2NF->3NF we need to check all entities and write(comment) what changed needed to be done and design the diagram of 3NF.
Then we determine the constraints and design the final fully attributed and normalized diagram in data modeler.
Project must be done in Oracle Data Modeler.
Dear Sir/Madam,
I have Oracle database design and development experience of 10 years.
I designed and implemented a university database for a national university using the following methodology:
- Requirements gathering
- Functional Design and database design using Entity Relationship Diagrams (ERD)
- Implementation using Oracle SQL, PL/SQL, Stored Procedures and functions, Oracle Reports/Forms
- Testing and verification
I attended the following database related projects either as project manager or as a member of customer technical team:
- Oracle Financials (Oracle EBS) Project
- Cognos BI project
- Oracle Transportation Management (OTM) Project
I am sure that I am good fit for your project.
Hope to hear from you soon.
Best Regards
Huseyin Aygun
€100 EUR în 3 zile
5,0 (6 recenzii)
3,3
3,3
4 freelanceri plasează o ofertă medie de €103 EUR pentru proiect
Can you please provide ERD so that i could look at it and ask questions specific to it.. I will be making keys and constraints along with normalized stuff.
Looking forward to have a chat with you to discuss further.
Hi. I have review your project description.
I have full experiences in Development.
I am very interested in your project and also ready to start work immediately.
Hoping for your soon Reply. Thank You Regard.