Ditutup

Building a mini oracle Application using macros - repost

Building a mini oracle Application using macros

? identify a simple database problem that requires two entity tables and a relationship set table for its [url removed, login to view] a third entity table may be included that has a one- to- many relationship to one of the other tables.

? Draw an E-R diagram for the application.

create the relevant tables using appropriate constraints.

populate the tables with at least 10 rows of varied data,such s that they can support a range of querries .

develop three macros, each of which has interaction with the user, contains at least two sql querries and produces properly formatted output.

? ? The followings are needed :?

? ? ? ? ? - A brief paragraph outlining the database problem? chosen

? ? ? ? ? - an? e-r diagram

? ? ? ? ? - copies of your create table? statements

? ? ? ? ? - listengs of table data

? ? ? ? ? - Macro listings with accompanying outputs?

? ? ? ? credits will be given for demonstrating good grasp and effective deployment of a range of sql language facilities.

Using ORACLE PLS

## Deliverables

I would love to have:

1. Mini report or docuemntation ? to explain what is done and how is done

2. Instructions on how to install and run the solution

3. other relevant things needed

Kemahiran: Pemasukan Data, Pentadbiran Pangkalan Data, MySQL, SQL

Lihat lebih lanjut: building mini oracle application using macros, building mini oracle database, building mini oracle application, building oracle application using macros, what are problem statements, sql to oracle, problem statements, building oracle using macros, building mini oracle application using macros repost, sql r, r sql, oracle sql with, oracle support, oracle install, oracle data, oracle data entry, entity relationship, e/r diagram, database oracle, database building 2, building a simple, sql database relationship, create sql report, relationship database diagram, create table using

Tentang Majikan:
( 0 ulasan ) Saudi Arabia

ID Projek: #4045025

5 pekerja bebas membida secara purata £100 untuk pekerjaan ini

ielkfarna

dear sir please, see my pm

£150 GBP dalam 3 hari
(12 Ulasan)
5.1
axenicglobal

Please check the personal mesage for details.

£85 GBP dalam 3 hari
(1 Ulasan)
3.4
gadgetmannz

Hi, I am an I.T. professional with over 20 years experience, with the last 10 focused on database solutions, covering Oracle and SQL Server. I have expert knowledge of SQL, including queries, stored procedures and opti Lagi

£90 GBP dalam 5 hari
(1 Ulasan)
3.4
munir13

Hi, im an oracle certified professional (OCP). more than 9 years of experience in Database design,Administration,Oracle Forms,reports,SQL,PL/SQL etc. ER Diagram with MS Visio Pls drop me a line i'will surely respon Lagi

£75 GBP dalam 3 hari
(0 Ulasan)
0.0
mazharadnan

I have more than 10 years enterprise level experience working with oracle based technologies. Please check your message box.

£100 GBP dalam 5 hari
(0 Ulasan)
0.0