CIS3010 - The Script to Create the Databases - Computer Science Assignment Help

Assignment Task

For this assignment we will use the Brewers database chapter 4 that comes with the textbook. The script to create the databases is included as a file in the assignment 1 section of the course website as well as week 2 on the study desk. You will need to run the scripts to create the needed database tables. If you are using your own Oracle insulation the script should work as normal.

Question 1 

Write an anonymous block that places a substitution variable (&) into a local variable of type varchar2.

You will need to convert the types and round them to nearest tens unit. For example, 84.4555 would be 84.5.

You should check the value entered in the local variable and output different messages depending on the value provided.

The anonymous block is a simple grade calculator with the following rules.

If the value less than 44.5, output the following message “Resulting Grade for VALUE marks is ‘Fail’”

If the value is 44.5 or more and less than 55.4 output the following message “Resulting Grade for VALUE marks is ‘Make Up Work’”

If the value is 55.5 or more and less 74.5 output the following message “Resulting Grade for VALUE marks is ‘Pass’”

If the value is 74.5 or more and less than 89.5 output the following message “Resulting Grade for VALUE marks is ‘Good Pass’”

If the value is 89.5 or more the output the following message “Resulting Grade for VALUE marks is ‘High Pass’”

If the inputted value is not in the range of 0 - 100 print an error message “ONLY VALUES BETWEEN 0 AND 100 ACCEPTED”

If the value is a string type, then the system cannot convert to a numeric form the system should print “ONLY NUMERIC VALUES ACCEPTED”

This (CIS3010) Computer Science Assignment has been solved by our Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinctio.