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.

Skills: Database Programming, SQL, Database Development, Oracle

About the Client:
( 0 reviews ) Ishim, Russian Federation

Project ID: #33788945

20 freelancers are bidding on average $69 for this job


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 days
(24 Reviews)

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 days
(20 Reviews)

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 More

$175 USD in 6 days
(10 Reviews)

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.

$45 USD in 1 day
(9 Reviews)

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 More

$30 USD in 1 day
(8 Reviews)

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 days
(3 Reviews)

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

$55 USD in 7 days
(1 Review)

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 More

$20 USD in 7 days
(1 Review)

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 More

$200 USD in 7 days
(4 Reviews)

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 More

$50 USD in 2 days
(1 Review)

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 days
(1 Review)

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 days
(0 Reviews)

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 days
(0 Reviews)

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 days
(0 Reviews)

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 More

$25 USD in 7 days
(0 Reviews)

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 days
(0 Reviews)

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 More

$15 USD in 7 days
(0 Reviews)

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

$20 USD in 7 days
(0 Reviews)

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 days
(0 Reviews)

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 More

$50 USD in 7 days
(0 Reviews)