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: 11 months ago.
Category: Homework
Expert:  LogicPro replied 11 months ago.

Hi

welcome

Customer: replied 11 months ago.
Can you help and can you give me your email so I can email the table documents
Customer: replied 11 months ago.
Hello,
Can you help and can you give me your email so I can email the table documents?
Expert:  LogicPro replied 11 months 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 11 months ago.
http://wikisend.com/download/870254/SQ.txt
Customer: replied 11 months ago.
did you get the file?
Customer: replied 11 months ago.
File name: SQ.txt
Download file ID: 870254
Download link: http://wikisend.com/download/870254/SQ.txt
Expert:  LogicPro replied 11 months ago.

yes, please wait.

Let me check it.

Customer: replied 11 months ago.
Thank you
Expert:  LogicPro replied 11 months ago.

What is the deadline?

Customer: replied 11 months ago.
In an hour
Expert:  LogicPro replied 11 months ago.

Can it be extended?

Customer: replied 11 months ago.
How long?
Expert:  LogicPro replied 11 months 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 11 months ago.
Ok
Customer: replied 11 months ago.
My deadline is about to pass so if someone can help now that
Customer: replied 11 months ago.
Otherwise I need to cancel
Customer: replied 11 months ago.
Please close this and cancel request I don't need it
Customer: replied 11 months ago.
Closed without any help or assistance from this service

Related Homework Questions