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 TheDoctor Your Own Question

TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1482
Experience:  M.S. in Internet Information Systems
59032869
Type Your Homework Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

**FOR THE DOCTOR** Step 1: Using the same subset of 4 (four)

Resolved Question:

**FOR THE DOCTOR**
Step 1:
Using the same subset of 4 (four) tables from the Project 1 ERD you used for your Access database, develop and run the SQL DDL (data definition language) statements necessary to construct an Oracle database on the UMUC Nova Server that exhibits the proper relational database design practices of integrity and normalization.
You should use a re-runable SQL script file for this step (e.g. "p2_step1.sql"), which may be called from pare
Submitted: 10 months ago.
Category: Homework
Expert:  TheDoctor replied 10 months ago.
Hello again! Thank you for requesting me.

I will contact you once this is ready.
Customer: replied 10 months ago.

 


Sorry i can only post so much on the first question. here is the full assignment.


Step 1:
Using the same subset of 4 (four) tables from the Project 1 ERD you used for your Access database, develop and run the SQL DDL (data definition language) statements necessary to construct an Oracle database on the UMUC Nova Server that exhibits the proper relational database design practices of integrity and normalization.
You should use a re-runable SQL script file for this step (e.g. "p2_step1.sql"), which may be called from parent SQL script file (e.g. "project2.sql"). By "re-runnable" it is meant that your SQL script can be run over and over again without any modification, so it will need to include the necessary DROP TABLE statements prior to corresponding CREATE TABLE statements.
Eventually you need to run your SQL script file while logged on to the Nova server via iSQL*Plus or SQL*Plus, but you may develop your SQL script on any suitable Oracle host. Your created database tables must reside on Nova in your own schema.
Your script files must contain all necessary SQL*Plus commands for echoing SQL statements and capturing output in a SPOOL file. Via the SQL CONSTRAINT keyword, you must explicitly name all tables' constraints for primary keys, foreign keys, check and unique constraints (you do not need to name NOT NULL constraints). Note that there is no SPOOL command for iSQL*Plus so if you use that option, simply redirect your SQL execution output to an HTML file and submit that in lieu of a SPOOL file.


Step 2:
Using the appropriate SQL DML (data manipulation language) statements, populate each table in your Oracle database on the Nova server with at least two rows of data each. You should do this via a re-runable SQL script file (e.g. "p2_step2.sql"), which would be called from your parent SQL script file (e.g."project2.sql") immediately following the calling of your Step #1 script file.
Be sure to include a COMMIT statement in your SQL script file.
Once all tables are populated, demonstrate via SQL "SELECT *" statements in your script file that your tables are properly populated. You should plan to develop your SQL script file on the Nova server, via a remote connection via SQL*Plus, or iSQL*Plus. Note that there is no SPOOL command for iSQL*Plus so if you use that option, simply redirect your SQL execution output to an HTML file and submit that in lieu of a SPOOL file


Deliverable
Take a screen snapshot of your 4 (four) tables on Nova. This can be accomplished via the SQL statement “SELECT table_name FROM user_tables”. Also, do a DESC (i.e. DESCRIBE) of each table and then take a screen snapshot of the columns of each table show in the output.
Take screen snapshots of the contents your 4 (four) tables on Nova. This can be accomplished via the SQL statement “SELECT * FROM your_table_name_here ”.


This assignment is Due Sunday Nov 10 by 11pm

Expert:  TheDoctor replied 10 months ago.
Thank you. I will contact you once his is ready.
Expert:  TheDoctor replied 10 months ago.
Hello again George!

Please download the files here:

DOWNLOAD

This is everything that you need for this assignment. Of course, you still have to run it on your school server.

If you are going to run with SQL*Plus, then you will upload the three sql files to your school account and run it in SQL*Plus with the command:

@project2.sql

This will automatically create a spool file for you called MY_SPOOL.TXT

I have sent you my copy of the spool file to show you that everything works fine. But you still need to run this stuff on your school's server.

If you are going to use iSQL*Plus, then you cannot create a spool file like this (as mentions din the assignment). I this case, you will run all of the code in p2_step1.sql and then p2_step2.sql and redirect your output to an HTML file, as mentioned in the assignment. I'm note entire sure how you go about doing that, as I never use iSQL. I use SQL*Plus. It is easier that way, as you can run everything instantly with a single command. You just need to make sure the three SQL files are in the write place. All the information about connecting to SQL*Plus and where to upload your files should all have been provided to you in your course. Unfortunately, I cannot log into your school account and run this stuff for you. But I can promise that it all works and meets all of the requirements. You can review the spool file I sent to see the results of me running it.

Please keep in mind that the first time you run this stuff, you WILL get errors. That is because you are required to include drop tables in your scripts. The first time you run them, there will be no tables to drop. Therefore, you will get errors. You can simply ignore them. They're are normal.

Let me know if you have any questions. I'm here to help.

Please remember to rate my answer. Thank you so much and have a wonderful day!
Customer: replied 10 months ago.

Hey Doc, thank you very much for the answer, but i still need


a portion of the assignment. which is: Take a screen snapshot of your 4 (four) tables on Nova. This can be accomplished via the SQL statement “SELECT table_name FROM user_tables”. Also, do a DESC (i.e. DESCRIBE) of each table and then take a screen snapshot of the columns of each table show in the output.
Take screen snapshots of the contents your 4 (four) tables


thank you

Expert:  TheDoctor replied 10 months ago.
I cannot do that for you. Read that requirement:

Take a screen snapshot of your 4 (four) tables ON NOVA

It is asking you to take a screen snapshot of you running the code on your school's server.

As mentioned in the assignment requirements, you **must** run all of the code on your schools server. Only you can do that and I gave you detailed notes about you needing tot do that. I obviously cannot run the code on your school's server for you, as I do not have access. "Nova" refers to your school's server. If I take screenshots on my server, your instructor will instantly know that it was not taken on the school server.

Only you have the ability to take those screen shots. And if you don't run the code on your school's server, as I mentioned in my answer, you will likely fail the assignment, as it is required that you run all of the code on the school's server.

I am not a student at your school and cannot connect to "Nova" (your school's server). You have to do that. You have to run all of the code I gave you there anyway or you will fail the assignment.

Run all of the code I gave you on the school's server, as I described, and then do as it states. Run that select statement for each of the four tables and then run a desc on each of the four tables. It is extremely simple, but I cannot do it for you. I cannot connect to your school's server.
Expert:  TheDoctor replied 10 months 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.
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1482
Experience: M.S. in Internet Information Systems
TheDoctor and 3 other Homework Specialists are ready to help you
Customer: replied 10 months ago.

oh thank you DOC. but that is not necessary, i have run the code through the Nova server, and have done all of the steps. i have submitted the assignment. i thank you very much for your help, and expertise. i will ask for you again in the future.


Again thank you


 

Expert:  TheDoctor replied 10 months ago.
That's excellent George. I was really worried that you wouldn't be able to get the code run on the server in time! I'm glad you got it submitted.

Thank you again
Customer: replied 10 months ago.

I gave a little extra.


Thanks again Doc

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