database design and code using oracle database management.

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 [url removed, login to view] 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.)

Skills: Database Administration, Oracle, SQL

See more: freelance design code database, using html code database, inventory management software using source code, code hospital management system using database, source code hospital management system using sql database, hospital management system using source code, software write mq4, software write chip epson, useful software write book, software write web specs, programming stock management software using sql server database, free software write user guide, software write edid, free software write company profile, design implement document management system using oracle sql, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, using callable statement oracle using javascript code, inventory management application using visual basic oracle books, design filter using matlab code example, export data database excelcsv using cfm code

About the Employer:
( 5 reviews ) Stoke-on-Trent, United Kingdom

Project ID: #13765370

Awarded to:


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
(68 Reviews)

24 freelancers are bidding on average £39 for this job


Hello there, i'm expert on database designing also implementation on Oracle, let me help you with this. Waiting for your response if interested. Thank you!!

£100 GBP in 3 days
(156 Reviews)
£18 GBP in 1 day
(13 Reviews)

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 Rel More

£55 GBP in 1 day
(41 Reviews)

Bid Summary I have more than 8 years of experience in IT industry.I have worked on .net(c#net,,asp,,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Project More

£50 GBP in 2 days
(25 Reviews)

we have expertise in sql,dba,data [url removed, login to view] satisfaction is our main motto for long term relationship.

£38 GBP in 1 day
(16 Reviews)

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 Requi More

£43 GBP in 1 day
(33 Reviews)

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 cha More

£50 GBP in 1 day
(12 Reviews)

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 da More

£33 GBP in 2 days
(7 Reviews)

Hello, My name is Abdul Rehman. I have much experience to design and develop the Database with using SQL server and ORACLE. i also design ERD in both SQL and ORACLE. Kindly inbox me for further queries. Thanks

£40 GBP in 3 days
(7 Reviews)

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 fifte More

£25 GBP in 7 days
(1 Review)

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 Reviews)
£18 GBP in 1 day
(0 Reviews)

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

£23 GBP in 3 days
(0 Reviews)

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 Reviews)
£18 GBP in 1 day
(0 Reviews)
£166 GBP in 1 day
(0 Reviews)

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 relation More

£14 GBP in 3 days
(1 Review)
£18 GBP in 1 day
(0 Reviews)
£50 GBP in 3 days
(0 Reviews)
£19 GBP in 5 days
(0 Reviews)