Mentoring and assistance for database design in Oracle SQL Database Modeler

€100 EUR

Completed

Posted

about 5 years ago

€100 EUR

Paid on delivery

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.

Database Administration

Project ID: 18816830

About the project

4 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@huseyinaygun

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 in 3 days

5.0

(6 reviews)

3.3

4 freelancers are bidding on average €103 EUR for this job

@customizedata

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.

€100 EUR in 10 days

5.0

(117 reviews)

6.7

@itwonder1

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.

€100 EUR in 10 days