Closed

database design and code using oracle database management.

This project has been awarded to frankoke16 for £20 GBP.

Get free quotes for a project like this
Project Budget
£10 - £20 GBP
Total Bids
28
Project Description

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.)

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online