Data Base design and implementation via Oracle
$14-30 NZD
Pagado a la entrega
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%]
Nº del proyecto: #10985392
Sobre el proyecto
18 freelancers están ofertando un promedio de $131 por este trabajo
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here Más
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Más
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
I have experienced in database design and query language for more than 6 years and I believe I can afford your requirements for 5-6 hours.
I am expert in databases, DB Design and Modeling, and Oracle Certified Professional. Can do the task as per your requirements.
Hi i have more than 3 years of experience in oracle development and willing to do this in a quicker manner, as you mentioned in the site ~Rameez
