Find Jobs
Hire Freelancers

sql class assignment

$10-30 USD

Käynnissä
Julkaistu lähes 8 vuotta sitten

$10-30 USD

Maksettu toimituksen yhteydessä
When tuning SQL code, use the following tools. The following settings turn on the execution plan output. SET AUTOTRACE ON; SET SERVEROUTPUT ON; SET TIMING ON; Set AUTOTRACE to TRACEONLY for queries with voluminous output. This query lists the current indexes. SELECT c.index_name, c.table_name, c.column_name, i.index_type FROM User_Ind_Columns c, User_Indexes i WHERE c.index_name = i.index_name; The index types are all set to “normal”, the default B-tree; OracleXE doesn’t support bitmapped indexes. You can deactivate/activate the indexes using the following command. ALTER INDEX indexName [INVISIBLE, VISIBLE]; You can create/drop indexes using the following commands. [CREATE, DROP] INDEX IndexName ON Tablename(fieldList); You can execute code multiple times using the following anonymous code block. DECLARE dummy INTEGER; BEGIN FOR i IN 1..1000 LOOP YourSelectCommand; END LOOP; END; / With this rather large database in place and these helpful tools, do the following exercises. Exercise 4.1 Create a view that for the CPDB “birthday czar”, which includes each person’s full name, age (using TRUNC(MONTHS_BETWEEN(SYSDATE, birthdate)/12) ) and birthdate (only), and then try the following. Retrieve the GenX people from the database (i.e., those born from 1961-1975); Update the Person base table to include a GenX birthdate for some person who had a NULL birthdate before and then re-run your query on the view from the previous question. Do the results of the view query change? Why or why not? Try to insert a new person using your new view. If this doesn't work, explain (but do not implement) the modifications you’d have to make to your view so that it does. Be sure that you understand what is required for a view to be updateable and what happens to the fields of the inserted record in the base table not included in the view. DROP your new view - does this affect your base tables in any way? Exercise 4.2 Do the following for the query on which the view in the previous exercises is based. Write an equivalent query in the relational algebra
Projektin tunnus (ID): 10636480

Tietoa projektista

4 ehdotukset
Etäprojekti
Aktiivinen 8 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
hi, I am a DBA and I have 4 years experience in database development and designing . please contact me for discussion , I can complete this in no time. Thanks.
$15 USD 1 päivässä
5,0 (1 arvostelu)
1,5
1,5
4 freelancerit tarjoavat keskimäärin $24 USD tätä projektia
Käyttäjän avatar
Hello, I am interested in your project. I am a software engineer and I have professional experience with Oracle SQL. Could you please send me the database which is the base of this assignment? Thank you, Best regards, David
$29 USD 3 päivässä
5,0 (8 arvostelua)
2,4
2,4
Käyttäjän avatar
I'm Computer Scientist and ready to deal with various projects as technical writing, MySQL, SQL queries, MS SQL SERVER,Dataware, database,Java projects, C#/C++, SignalR based applications, MySQL, MS SQL server, Database schema, Image processing, Matlab, MS visual studio, Eclipse and Aptana studio for python, Good in UML diagrams(Use Case diagram, Class diagram, Activity diagram, ER diagrams) and expert in Software Architecture(Client Server Arch.,Black board arch., Rule based arch., Event driven arch., Publish subscriber arch., Rest Arch) and MVC pattern. I make sure delivery of project on time and exactly according to requirements.
$61 USD 1 päivässä
4,5 (3 arvostelua)
2,2
2,2
Käyttäjän avatar
Highly professional web developer. Always ready to take difficult task to improve my skills and knowledge. Love to find quick and easy way while maintaining efficiency at its peak. It has always been my great desire to provide excellent and satisfying works based on the clients' needs. I am competent, responsible and a good communicator. Other SKILLS - Basic web skills - PHP, Asp .Net, C# , HTML, HTML5, CSS, CSS3, javascript, jQuery, Ajax - CSS Frameworks - Bootstrap 3 - JS Frameworks - Jquery, Ajax , AngularJS - PHP Frameworks - Oop, -MVC Framework- Entity Framework 6 Code First approach - C# - CMS - Wordpress, - Databases - MySQL, MSSQL, SQL I would like to give my prospective employers a professional , responsive and a mutually beneficial relationship.
$25 USD 1 päivässä
4,6 (1 arvostelu)
1,4
1,4
Käyttäjän avatar
A proposal has not yet been provided
$30 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan KENYA lippu
Nairobi, Kenya
5,0
56
Maksutapa vahvistettu
Liittynyt helmik. 7, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.