Find Jobs
Hire Freelancers

Data Base design and implementation via Oracle

$14-30 NZD

Completed
Posted almost 8 years ago

$14-30 NZD

Paid on delivery
Main tasks given. More details would be shared with selected bidder. Please only bid if you can do the mentioned tasks in 6-7 hours. Strict deadline. TASKS: 1. Transform the EER model (Appendix A) to Relational tables, making sure you show all the steps. The final set of tables should contain necessary information such as table names, attribute names, primary keys (underlined) and foreign keys (in italics). [40%] 2. a) Implement the tables in the ORACLE 12c Relational DBMS. When creating tables make sure you choose appropriate data types for the attributes and specify any null/not null or other constraints whenever applicable. b) Write one insert statement for each of your tables using realistic data. Make sure you take into consideration all the necessary constraints. [40%] 3. Apply Normalization Techniques (Bottom-Up approach) on Appendices A, B, C and D from Assignment 1 Part 1 to come up with BCNF tables. [15%] 4. Discuss the differences between the result of the top-down approach from question 1 above and the result of the bottom up approach from question 3 above. Provide some analysis on why they are similar or different for this particular problem.[5%]
Project ID: 10343021

About the project

5 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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:
User Avatar
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
$40 NZD in 0 day
4.3 (24 reviews)
3.9
3.9
5 freelancers are bidding on average $68 NZD for this job
User Avatar
I have 5 yrs of experience in SQL development
$80 NZD in 2 days
4.7 (13 reviews)
4.8
4.8
User Avatar
i can do your work......................................................................................................................................................................................................
$28 NZD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a DB guru and can write what your are looking for in a day. Code will be clear and concise with proper indentation and commented wherever its required.
$40 NZD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Milton Keynes, United Kingdom
5.0
14
Member since Sep 13, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.