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

drivenjesus
drivenjesus, Engineer
Category: Homework
Satisfied Customers: 243
Experience:  Tutor for students, friends, family, and others.
68869132
Type Your Homework Question Here...
drivenjesus is online now
A new question is answered every 9 seconds

I need some help in getting some answers on 5 PL/SQL

Customer Question

I need some help in getting some answers on 5 PL/SQL questions
Submitted: 8 months ago.
Category: Homework
Customer: replied 8 months ago.
SQL Files are attached
Expert:  drivenjesus replied 8 months ago.

Hello!

The first question:

1. This question actually says: "Select all the data, if fall or summer is in the description, write to the empty field the year from the term start date field. Then if spring, insert the same date data as above, but subtract 1 from the date. If none of these match, simply carry over the acad_year field.

2016

2016

2017

2015

2016

2014

2014

Expert:  drivenjesus replied 8 months ago.

The second question reads:

1. Select all records from all fields with data (named specifically) and pull the row number (which is not shown in the fields) and order them all by effective date (effdt) and description (desc), and insert into ranking field the data from the CS_Subject_tbl, as long as it is not a duplicate (eft_status = 'A') so for ease of working out the data, eliminate ALL duplicates right off the bat. The only duplicate is the very last record. You would end up with an alphabetically and chronologically sorted list, first by date, and if there is a duplication in date, then by description.

Expert:  drivenjesus replied 8 months ago.

After rechecking that, it looks like there is not a duplicate, it is 7/1 vs 7/2 on the date, close but not quite...working on the table...

Expert:  drivenjesus replied 8 months ago.

Table...it does not look like line number is ***** in the output, but I would throw a line number field on there just in case...

Expert:  drivenjesus replied 8 months ago.

Q3 is: @ID

Expert:  drivenjesus replied 8 months ago.

Or %ID

Expert:  drivenjesus replied 8 months ago.

Question 4: Runtime errors are caused by not handling an output somewhere, in this case the problem is in the "On" statement, there is no subsequent "then" to handling if the records do not match.

Expert:  drivenjesus replied 8 months ago.

it is there further down in the code, but it also does not handle "if field not empty" on inserting.

Expert:  drivenjesus replied 8 months ago.

And finally an example star schema, these are very simple relation tables diagrams, and my instructor in college often took referenced diagrams in lieu of making new ones from scratch. If you need one of these made, I can do it for you, for a slight fee.

Expert:  drivenjesus replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Customer: replied 8 months ago.
Sorry, I didnt any replies yesterday and I had them resolved yesterday
Customer: replied 8 months ago.
Sorry, I didnt get any replies yesterday and I had them resolved yesterday

Related Homework Questions