Kapalı

Create DataBase

Design the work of the telephone service X. The database should contain information about network subscribers, tariffs and services of the X service. (Telephone service, as well as subscribers, tariffs and services are abstract, you can think up at your discretion). When designing, you need to take into account the requests that I will describe below.

Create queries on the designed database:

1. Find the names of subscribers who have a phone number

ends with the number 7.

2. For the client with the largest number of calls per month, reduce the cost of services by 10%.

3. Create a request that contains: the subscriber code, the cost of the service provided and the total average cost of the service provided per unit.

4. Create a query that results in a list of subscribers holding the position of "manager" and working in this X service.

5. Make all incoming calls for any subscriber

discount in April.

6. Display payroll for Smith for the current month

Cursors and triggers:

1. Create an Explicit Cursor Selecting Some Data

from your database (to create, use any query created earlier).

2. Create a cursor the same as in the previous paragraph, but with a parameter.

3. Create a trigger to consider who and when

entered data into one of your tables.

4. Create triggers on all your tables that allow you to automatically enter data for fields that are the primary key and have a numeric type.

The database must be designed and created in the Oracle DBMS, you must provide:

1. A graphical diagram of the created database, indicating the relationship of entities (one to one, one to many, etc.)

2. SQL code for creating and filling tables, creating queries, triggers and cursors.

We can agree on a budget.

Beceriler: Veritabanı Programlama, SQL, Veritabanı Geliştirme, Oracle

Müşteri Hakkında:
( 0 değerlendirme ) Ishim, Russian Federation

Proje NO: #33788945

Bu iş için 20 freelancer ortalamada $69 teklif veriyor

Sugidev

Hi there, I can create the DB, triggers, cursors, and all the queries required. If interested, please message me. Thanks Sugi

$150 USD in 2 gün içinde
(24 Değerlendirme)
5.0
TEKSCENT

I have around 12+ years of professional experience in sql development in oracle/Db2/mysql/sqlserver. I have worked in more than 300 projects. Lets discuss your requirements

$200 USD in 7 gün içinde
(20 Değerlendirme)
4.3
enterpriseit1

Over 10 years of experience as a Oracle and Mysql database developer. I have completed several similar projects here. Please see my profile for examples. I can design and create the queries, procedures, triggers, etc Daha Fazla

$175 USD in 6 gün içinde
(10 Değerlendirme)
4.5
bizmanas

Hi I have 15 years of experience in sql server and power bi. I would be able to help you with the project. Please ping me offline to discuss further.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)
4.1
robertantoni79

Hello dear customer. I am able to develop the required activities because I have more than 10 years of experience in Oracle Database, applying everything from design, implementation to the creation of queries, procedur Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.2
alambharathkumar

I have good experience in Database development and worked on databases like Oracle, MySQL, Redshift. I have overall 11 plus years of experience in data engineering , will be able to do the task with ease.

$20 USD in 7 gün içinde
(3 Değerlendirme)
2.6
tracygearth

I would create the desired objects in Oracle RDBMS ...

$55 USD in 7 gün içinde
(1 Yorum)
2.3
SultanMahmud3

I have professional experience to work with Web Applications, Mobile Apps and Desktop Software development. My professional skillfulness: • Spring Boot: I have been working Backend and Frontend with single or Multi Daha Fazla

$20 USD in 7 gün içinde
(1 Yorum)
1.9
shamuztab

Hi, I am software engineer with good command over DBMS, I have 5+ years of experience with SQL and have extensive work experience. I have read the query part and trigger part as well. Let's connect and build your DBMS Daha Fazla

$200 USD in 7 gün içinde
(4 Değerlendirme)
2.2
sabribaccar71

Hello , I have seen your job requirements and I am sure that I can do your task efficiently in less timeline as we are a team of engineers of 3 people, each one has an experience of 5+ years we are specialized in web d Daha Fazla

$50 USD in 2 gün içinde
(1 Yorum)
1.2
SuryaGopisetty30

I have been working in a reputed company for past 4 years and have good experience in Oracle SQL and SQL.

$20 USD in 7 gün içinde
(1 Yorum)
0.3
safiaZ20

Hello, I have read your project's description and understood it. I Can help you finish this work. Hope you will accept m'y offer. Have a good day.

$50 USD in 2 gün içinde
(0 Değerlendirme)
0.0
atifhasnie

I have experience in writing queries and procedures and have complete knowledge of database development and designing. It would be an honor for me to work for you and serve you.

$20 USD in 10 gün içinde
(0 Değerlendirme)
0.0
pachhavengamma

I have 5+ years of experience as Oracle PLSqL Developer. Could be able to deliver project with accuracy as soon as possible.

$30 USD in 5 gün içinde
(0 Değerlendirme)
0.0
ganeshdevadhe

My 12 years of experience as an Oracle DBA has made me an expert in every Oracle DBA task and I think this expertise makes me a great fit for your organization. Last 3 yrs working on MySQL and Maria Database. My profe Daha Fazla

$25 USD in 7 gün içinde
(0 Değerlendirme)
0.0
dhiraj515151

Working as Dats engineer from last 2.5 years. I'm good in SQL but new here on freelancer. I want to give my all expertise. Kindly give an opportunity to prove my self through my skills.

$10 USD in 15 gün içinde
(0 Değerlendirme)
0.0
khizersheikh16

Hi, I am software engineer with good command over DBMS, I have 3+ years of experience with SQL, MySql and have extensive work experience. I have read the query part and trigger part as well. Let's connect and build you Daha Fazla

$15 USD in 7 gün içinde
(0 Değerlendirme)
0.0
basemosama100

I have experience in different database ( oracle,postgres,sql server) Create complex queries and functions

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
premreddii

Have overall 11 years development experience on sql and plsql . Whole of my career I worked on telecom domain so I can easily understand and deliver your requirement

$200 USD in 7 gün içinde
(0 Değerlendirme)
0.0
OracleFreelance

Result oriented IT professional with 17+ years of experience as Oracle database architect and Consultant roles with Indian and multinational organizations. Experience includes system analysis and design, project lifec Daha Fazla

$50 USD in 7 gün içinde
(0 Değerlendirme)
0.0