database design and code using oracle database management.

£10-20 GBP

Cancelled

Posted

about 7 years ago

£10-20 GBP

Paid on delivery

complete scinario will be explained a fictional scinario will be provided about a fictional company. the freelancer is Identify the main entity types, their relationships, and various constraints or enterprise rules. they should then construct a conceptual Entity Relationship Diagram (ERD) and the corresponding logical ERD for this database system using the extended UML [login to view URL] that they show all multiplicity constraints clearly and make sure that all the important attributes are represented and Map the ERD constructed in (1) above onto a relational database schema using the Oracle SQL full details will be provided once contact has been made Define all primary and foreign keys clearly. Normalisation is NOT required for this project. You should then use Oracle SQL*Plus to populate the database with sufficient sample records in order to enable various queries to be performed. It is advisable to use a .sql script to save all the statements that are relevant for this exercise not only as proof of your work but also as a means of simplifying debugging or applying changes to the database schema without the need for re-typing the whole set of SQL statements over and over again (please note code will need to be provided in .txt for me to input in to own system.)

Database Administration

Oracle

SQL

Project ID: 13765370

About the project

21 proposals

Remote project

Active 7 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:

@it2051229

Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.

£25 GBP in 1 day

5.0

(81 reviews)

5.5

21 freelancers are bidding on average £37 GBP for this job

@msalahii

Hello, My Name 's Muhammad Salah and I'm a Database Administrator and I can do your project and deliver it as fast as possible, I'm available and ready to start working on your project immediately just send me on chat and let's start working Thanks

£50 GBP in 1 day

4.9

(16 reviews)

4.7

@point5nyble

Bid Summary Hello I have ~6 years of experience in the database field and completed multiple projects based on the same concept. I would like to work on your project as well & deliver the best solution. Project Requirements This project basically require to analyse the give case study and then identify entities , attributes & relationship between entities. Post identification of entities , attributes & relationship it requires to create conceptual & logical ERD which should fulfill all the operation for the given case study. Once ERD is build map the ERD relational database model & create required tables in the oracle data. insert dummy data in the tables . Relevant Skills and Experience I have very vast knowledge in this area. Expert level knowledge in Designing conceptual & logical ERD for a given scenario. Expert level knowledge in Oracle database. Proposed Milestones £43 GBP - Database

£43 GBP in 1 day

4.8

(36 reviews)

4.9

@jagdishbhatt38

Bid Summary I have more than 8 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Project Requirements I have more than 8 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Relevant Skills and Experience I have more than 8 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Proposed Milestones £50 GBP - Project fee

£50 GBP in 2 days

4.9

(30 reviews)

4.8

@vinaysinghh

Bid Summary I am oracle dba having more then 10 yrs of experince.. i have great experience on RDMS system Project Requirements i can make qperfect ERD incliude all entities inculsing all as you mention in project Relevant Skills and Experience Oracle, sql , PlSQL , RDBMS , Proposed Milestones £55 GBP - ERD

£55 GBP in 1 day

4.5

(53 reviews)

5.2

@enterpriseit1

Bid Summary expert in database modeling, schema creation, ddl, sql, plsql, stored procedures, functions in oracle and mysql. Project Requirements Creation of ERD, representation of primary, foreign keys,. Some test data also needs to be provided which can be inserted using sql plus. Relevant Skills and Experience i have over 7 years of experience as a oracle database developer specializing in database modeling, sql, plsql, er data model development. Proposed Milestones £33 GBP - Overall project delivery Additional Services Offered £105 GBP - User interface developer, integration with the database, representation of data on the UI

£33 GBP in 2 days

5.0

(9 reviews)

3.7

@kbilalsalim

Bid Summary Implementation of Relational data model in oracle based on the scenario given Project Requirements An ER model, A working database schema with sample data. Relevant Skills and Experience I have over fifteen years of database design, development and administration experience using oracle database. Have been involved in many database projects as designer and developer. Proposed Milestones £5 GBP - Requirement understanding and analysis £5 GBP - ER Model preparation £15 GBP - Implementation and approval Additional Services Offered £10 GBP - Debugging of actual system

£25 GBP in 7 days

5.0

(1 review)

1.3

@msdevelopersl

Hi, I have more than 8 years of development experience. Also, worked on database design in many projects. I can immediately start working on your assignment. Please provide more details about it. thanks,

£20 GBP in 1 day

0.0

(0 reviews)

0.0

@sabreenis35

I have excellent experience in SQL database and Oracle forms and reports and I working Oracle developer and administration from four years and I can build database and determine primary key and foreign key and relationships between tables and draw ER diagram and write any SQL statements in sql plus

£14 GBP in 3 days

5.0

(1 review)

0.0

@manascitane

Hi , I have an experience of 6 years on database design /ER modelling .Please check my CV and let me know .

£55 GBP in 2 days

0.0

(0 reviews)

0.0

@consultkasyap

Hello, I am interested in this assignment, I have created ER Diagrams using ERWin, SQL Data Modeler, Lucidcharts. I am good at Oracle database programming and certified Oracle PL/SQL Developer. Regards,

£25 GBP in 2 days

0.0

(0 reviews)

0.0

@erfanmallick

Bid Summary Hi I have extensive experience in ERD and database design. I have completed many work like this in the past. If you are interested then do invite me. Thanks Erfan Project Requirements I can complete the: ERD logical ERD using extended UML notation Map the ERD in (1) above onto a relational database schema using the Oracle SQL use Oracle SQL*Plus to populate the database with sufficient sample records Relevant Skills and Experience I have sample work if required to see. Proposed Milestones £23 GBP - Complete work If you are interested then do invite me and accept my proposal.

£23 GBP in 3 days