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 Carla Your Own Question
Carla
Carla, Engineer
Category: Homework
Satisfied Customers: 560
Experience:  Bachelor's degree in Data Processing Technology. Over 12+ years experience in IT, Databases and Systems Administration.
19007361
Type Your Homework Question Here...
Carla is online now
A new question is answered every 9 seconds

sql

This answer was rated:

sql

hi

thanks for using justAnswer.com

please send the question details

Customer: replied 4 years ago.

I really don't know where to begin this so, can you please show me that would be awesome...


 


http://speedy.sh/cu3ts/New-Microsoft-Word-Document-4.docx


 


http://speedy.sh/8QDPJ/SQL.pdf

hi

ok i will do this
this using Oracle, right

i have sent an underpriced report.
if you are ok with that, please raise the price
Customer: replied 4 years ago.
Linux
hi

sorry i am opitng out this to other experts

Hello

These questions you have asked can only be done using SQL programming.

What database system are you using? SQL Server, MySQL or Oracle?

Linux is the operating system where you might have your database (Oracle or MySQL) installed.


Can you please clarify the above so that I can start working on your project? I will also need some more information about the fields that you need to add to each one of the tables.



Thank you

Customer: replied 4 years ago.
No specific program was mentioned n the fields are in the PDF file
Customer: replied 4 years ago.
Hey are we using MySQL SQL server or oracle for the assignment that's due today
Sorry, I didn't see the PDF file. I have been able to download it now.

Because I will have to create the tables manually and due to the time this will take I will submit an underpriced report.

You will receive an email letting you know the suggested price and providing you with a link to update the question value.

Thank you
I think someone has already submitted the report. If you could then please update the question price, I will get started working on this project.


Thank you again
Customer: replied 4 years ago.
To how much??
I don't know how much the other Expert put in the underprice report that you should have received by email but I would say that it will take between 3 to 5 hours to get all the work completed in the required time.

It's up to you how much more you would like to add to the question based on that but for the offered price of $10.80 I can only create and populate the tables.
Customer: replied 4 years ago.
Ok it's changed
Okay. I will do the whole assignment for the price you are offering this time but keep in mind that this is quite low for the time required for this type of work (about 3 hours).


Thank you
Customer: replied 4 years ago.
Ok thanks
I will post the answer asap.

Thank you again.
I have finished your queries.

You can download them from the following link:

https://www.dropbox.com/sh/ejv2h043xt26juv/GNTK8zulDF

This is what you have to do:

1. Extract the files to a folder on your computer
2. Login to SQL*Plus first
3. Then run the dbproject.sql script to create and populate the tables with the following command:

@c:\foldername\dbproject.sql
example: c:\temp\dbproject.sql

4. Then edit the dbproject.lst file and replace "YOURFIRSTNAME YOURLASTNAME" with your own first and last name.

5. Run the dbproject.lst script to generate the spool file:

@c:\foldername\dbproject.lst
example: c:\temp\dbproject.lst


If you have any questions, please let me know.


Thank you



You will have to edit the script first by right-clicking on it and then
Hello Customer

Could you please let me know if you have been able to download the answers?


Thank you
Customer: replied 4 years ago.

is this correct??


 


http://speedy.sh/r6dFz/correct.PNG

THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Carla, Engineer
Category: Homework
Satisfied Customers: 560
Experience: Bachelor's degree in Data Processing Technology. Over 12+ years experience in IT, Databases and Systems Administration.
Carla and other Homework Specialists are ready to help you

Thank you for rating my answer.

 

If you need help in the future with database or SQL assignments, please feel free to contact me again.

 

 

Thank you!