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.

Taidot: Tietokantaohjelmointi, SQL, Tietokantakehitys, Oracle

Tietoa asiakkaasta:
( 0 arvostelua ) Ishim, Russian Federation

Projektin tunnus: #33788945

20 freelanceria on tarjonnut keskimäärin $69 tähän työhön


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

$150 USD 2 päivässä
(24 arvostelua)

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 7 päivässä
(20 arvostelua)

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 Lisää

$175 USD 6 päivässä
(10 arvostelua)

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 1 päivässä
(9 arvostelua)

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 Lisää

$30 USD 1 päivässä
(8 arvostelua)

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 7 päivässä
(3 arvostelua)

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

$55 USD 7 päivässä
(1 arvostelu)

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 Lisää

$20 USD 7 päivässä
(1 arvostelu)

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 Lisää

$200 USD 7 päivässä
(4 arvostelua)

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 Lisää

$50 USD 2 päivässä
(1 arvostelu)

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

$20 USD 7 päivässä
(1 arvostelu)

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 2 päivässä
(0 arvostelua)

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 10 päivässä
(0 arvostelua)

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

$30 USD 5 päivässä
(0 arvostelua)

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 Lisää

$25 USD 7 päivässä
(0 arvostelua)

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 15 päivässä
(0 arvostelua)

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 Lisää

$15 USD 7 päivässä
(0 arvostelua)

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

$20 USD 7 päivässä
(0 arvostelua)

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 7 päivässä
(0 arvostelua)

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 Lisää

$50 USD 7 päivässä
(0 arvostelua)