How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ATLProg Your Own Question

ATLProg
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 8649
Experience:  Expert in Java C++ C C# VB Javascript Design SQL HTML
44910485
Type Your Homework Question Here...
ATLProg is online now
A new question is answered every 9 seconds

1.List the SQL commands you will use to create your database

Customer Question

1.List the SQL commands you will use to create your database tables
2.Implement the tables in Oracle’s 11g relational database management system
3. Provide the SQL code (and screen shots) based on the following criteria:
You must deliver five (5) queries in total for this assignment.
One of your five queries must select from three (3) different tables.
Four of your queries must select from two (2) tables.
Include comments on how you are using the optimization rules you described
Submitted: 1 year ago.
Category: Homework
Expert:  ATLProg replied 1 year ago.
Hello Welcome. Thank you for your question, I’m ATLProg and I’ll try to help you.

How soon do you need this answer ?

Customer: replied 1 year ago.

I could use the answer anytime

Customer: replied 1 year ago.

Did u send me any answer?

Expert:  ATLProg replied 1 year ago.
I have sent a Underpriced report on this to your registered email id, please confirm if the price looks ok to you. Please let me know so I can start working on this accordingly.
Customer: replied 1 year ago.

i changed the price

Expert:  ATLProg replied 1 year ago.
Underpric3ed report has a price of 65$
Customer: replied 1 year ago.

opsss. My bank will deny.I am just a poor school boy trying to make it. Its ok. I'll come back next time. Thanks for your time.

Expert:  ATLProg replied 1 year ago.
ok.
Customer: replied 1 year ago.

I know that price is small, is there anything you can do, maybe question 1 and 2. I will do question 3 by myself.

Expert:  ATLProg replied 1 year ago.
Sorry
Customer: replied 1 year ago.

are you there today?

Customer: replied 1 year ago.
Relist: Other.
Price differnce
Customer: replied 1 year ago.

I am trying tom add some more pay to it.

Expert:  ATLProg replied 1 year ago.
ok...
Customer: replied 1 year ago.

can u please send me n under price report again so I could edit the price

Expert:  ATLProg replied 1 year ago.
price is 65 $
Customer: replied 1 year ago.

I can not fix the price 65 I placed it on 52. is there something you can do with that?

Expert:  ATLProg replied 1 year ago.
ok..I am working on it.
Expert:  ATLProg replied 1 year ago.
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 8649
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
ATLProg and 8 other Homework Specialists are ready to help you
Customer: replied 1 year ago.

Hi. you did not answer my question Sir. This is my question.


1.Describe a minimum of three (3) heuristics to optimize Queries.


2.Provide the SQL code (and screen shots) based on the following criteria:



  1. You must deliver five (5) queries in total for this assignment.

  2. One of your five queries must select from three (3) different tables.

  3. Four of your queries must select from two (2) tables.

  4. Include comments on how you are using the optimization rules you described and discussed earlier.

  5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Expert:  ATLProg replied 1 year ago.
That is what I answered
Customer: replied 1 year ago.

Honestly. I could not find the answer to my question. What eaxcly answers that?



  1. Provide the SQL code (and screen shots) based on the following criteria:



  • You must deliver five (5) queries in total for this assignment.

  • One of your five queries must select from three (3) different tables.

  • Four of your queries must select from two (2) tables.

  • Include comments on how you are using the optimization rules you described and discussed earlier.


 

Expert:  ATLProg replied 1 year ago.
Did you read all the way through paper ?
Customer: replied 1 year ago.
Yes. I did sir
Expert:  ATLProg replied 1 year ago.
Paper has alll rhe items you mentioned in original question
Customer: replied 1 year ago.


hi.. are you very good at Unix?

Customer: replied 1 year ago.
Relist: Other.
No response in 10 hours
Expert:  ATLProg replied 1 year ago.
pls send me details will take a look
Customer: replied 1 year ago.

 


Assignment 1


Terminal Session


In this terminal session, you will create a small text file and practice using the editing


keys that vi provides. Use your imagination. Do not limit yourself to the small file in


this exercise.


Try to use all the keys that are explained in this chapter.


1. Use the vi editor to create a file called Chapter4 and type in the text shown on


screen 1.


2. Save this file


Screen 1


The vi history


The vi editor was developed at the University of california, berkeley


as part of the berkeley unix system.


~


~


"Chapter4" [new file ]


3. Open the test file again and add text to make it look like the text shown on screen 2.


4. Save this file again.


Screen 2


The vi history


The vi editor was developed at the University of california


berkeley as part of the berkeley unix system.


At the beginning the vi editor was part of another editor


The vi part of the ex editor was often used and became very.


This popularity forced the developers to come up with a separate


vi editor.


now the vi editor is independent of the ex editor and is available on


most of the UNIX operating system.


The vi editor is a good editor for everyday editing jobs.


5. Open the test file once more and edit the text to make it look like the text on screen 3.


6. Search for the word vi using the / (forward search). Use n to find the next occurrence


of the word vi.


7. Search for the word vi using the ? (backward search). Use n to find the next occurrence


of the word vi.


8. Place the cursor at the beginning of the file and delete five lines. Undo your delete.


9. Place the cursor at the beginning of the second line and delete 10 characters. Undo


your delete.


10. Use r to replace the character at the cursor position. Undo your action.


11. Use R to change the word developers to creators. Undo your action.


12. If you have a Linux system, practice the following:


a. Get help for the help command.


b. Get help for the ZZ command.


c. Get help for the search command.


13. Save your file for later exercise sessions using the ZZ command.


Screen 3


The vi history


The vi editor was developed at the University of California


Berkeley as part of the Berkeley UNIX system.


At the beginning the vi (visual) editor was part of the ex editor


and you had to be in the ex editor to use the vi editor.


The vi part of the ex editor was often used and became


very popular. This popularity forced the developers to come up


with a separate vi editor.


Now the vi editor is independent of the ex editor and is available


on most of the UNIX operating systems.


The vi editor is a good, efficient editor for everyday editing jobs


although it could be more user friendly.


~


~


~


~


 


 


Assignment 2


Terminal session.


Try the following commands. Observe the output and the command feedback (error messages on the screen and so on) on the screen


Create a directory structure in your HOME directory and try different commands until you feel comfortable with directories and file manipulation commands.



  1. Show your current directory

  2. Change your HOME directory

  3. Identify your HOME directory

  4. List the contents of your current directory

  5. Create a new directory called xyz under your current directory

  6. Create a file called xyz in the xyz directory

  7. Identify the directions in your working directory

  8. Show the contents of your current directory

    1. In reverse alphabetical order

    2. In long format

    3. In horizontal format

    4. Showing the invisible files in your current directory



 


 


 


Assignment 3.



  1. What is the command line to open a file named xyz in read only mode?

  2. What is the command line to open a file names xyz with cursor on the line with first occurrence of the word UNIX?

  3. What is view?

  4. What are the numbered buffers?

  5. What are the named buffers?

  6. What is the vi command to

    1. Delete a line

    2. Delete a word

    3. Copy a line

    4. Copy a word

    5. Delete to the end of the current line

    6. Save two lines in a buffer called z?

    7. Copy the contents of the z buffer after the current line?

    8. Copy the contents of the buffer two after the current line?


  7. What is the vi command for removing the showmode option?

  8. What is the vi command to abbreviate ‘one two three’ to ‘123’

  9. What is the .exrc file? When is the .exrc file executed?

  10. What is the command to execute a shell command such as date while in vi?

  11. What is the command to read the current date and place it in the file under the current line?

  12. What is the set command for vi to display confirmation messages?

  13. What is the vi file recovery option?

  14. What is the command to get the list of the file that were saved before crash?

  15. What is the vim editor

  16. Match the commands shown in the left column with explanations shown in the right. All the commands are applicable only in the command mode.

    1. G a. Replaces the character under the cursor with the letter x.

    2. /most b. Places the cursor on the last line in the file

    3. [Ctrl-g] c. copies four lines in the buffer x

    4. 2dw d. Moves the cursor down one line

    5. j e. shows the line number of the current line

    6. “x4yy f. Positions the cursor on line 66

    7. $ g. Deletes the character under the cursor

    8. 0 (zero) h. retrieves the contents of buffer 1

    9. 66G i. Deletes two words

    10. x j. Positions the cursor at the end of the current line

    11. rx k. Finds the word most

    12. “lp l. Positions the cursor at the beginning of the current line


  17. While using the vi editor, what command do you use to

  18. Set the line number position?

  19. Save five lines in buffer x?

  20. Read (import) the date string into your file?

  21. List your current directory?

  22. Create an abbreviation?

  23. Remove an abbreviation?

  24. Read another file

  25. Write (save) a file without quitting the vi editor?

  26. Delete a word?

Customer: replied 1 year ago.

is it what you can do??

Expert:  ATLProg replied 1 year ago.
Sorry I cannot..

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience
 
 
 

Related Homework Questions