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 Scott Your Own Question
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

I need the scripts and answers following: I have the tables

Customer Question

I need the scripts and answers for the following:
I have the tables but will need you to email me so I can forward as it won't allow me to past that here because it appears to be code and a threat to this website - I already tried. ************
2. Your assignment is to “move” all of the data from the full table into the appropriate tables WITH relationships.
a.Write out the SQL necessary to populate the Owner and Species tables.
b.Write SQL necessary to populate the additional tables with proper key relationships. This should be done with one or two statements that insert/update all rows at once.
i.If you alter tables, show that alteration, even if it is a temporary alteration.
c. There is one problem with one of the tables. What is it? How do you fix it?
3. Create the appropriate Foreign Key relationships. Write out that SQL.
Submitted: 1 year ago.
Category: Homework
Expert:  LogicPro replied 1 year ago.

Hi

welcome

Customer: replied 1 year ago.
Can you help and can you give me your email so I can email the table documents
Customer: replied 1 year ago.
Hello,
Can you help and can you give me your email so I can email the table documents?
Expert:  LogicPro replied 1 year ago.

If you have any file(s), Zip all files; upload the zipped file to http://wikisend.com or http://ge.tt and post download link here.

Customer: replied 1 year ago.
http://wikisend.com/download/870254/SQ.txt
Customer: replied 1 year ago.
did you get the file?
Customer: replied 1 year ago.
File name: SQ.txt
Download file ID: 870254
Download link: http://wikisend.com/download/870254/SQ.txt
Expert:  LogicPro replied 1 year ago.

yes, please wait.

Let me check it.

Customer: replied 1 year ago.
Thank you
Expert:  LogicPro replied 1 year ago.

What is the deadline?

Customer: replied 1 year ago.
In an hour
Expert:  LogicPro replied 1 year ago.

Can it be extended?

Customer: replied 1 year ago.
How long?
Expert:  LogicPro replied 1 year ago.

My apologies, I am out of ideas and opting out for other Professionals to answer. Please wait. You will be notified by email as soon as any Professional joins you.

Thank you for your patience.

Customer: replied 1 year ago.
Ok
Customer: replied 1 year ago.
My deadline is about to pass so if someone can help now that
Customer: replied 1 year ago.
Otherwise I need to cancel
Customer: replied 1 year ago.
Please close this and cancel request I don't need it
Customer: replied 1 year ago.
Closed without any help or assistance from this service