Sql queries-oracle , PL-SQL Programming

Assignment Help:

1- You can check attribute names from each table in DBF11 by running for example:

 desc dbf11.Member;

 desc dbf11.Agent;

 desc dbf11.Producer;

Because some attribute names in the tables might be slightly different from those in the assignment blue sheet, please make sure to verify the attribute names first before querying the tables.

This way, you check the real data set first before validating your queries.

2- For question 1d:

Display the month(s) in which the number of entries for the awards is higher than the monthly average of entries for the current year.

The 'number of entries' refers to the FILM entity, and the montly average comes from the 'entry_date'. This question is referring to the number of films that have been entered into the award system.

3- INSTRUCTIONS for TASK 3 FILES

- You need to run (or cut and paste) 'task3-build.sql' on your own oracle account to create the required tables for question 3

- You then need to populate the tables with data by running (or cutting and pasting) 'task3-populate-before-trigger.sql'

- You can then implement the trigger questions for the assignment.

- You need to submit your spool for trigger questions by showing the results of executing (or cutting and pasting) 'task3-populate-after-trigger.sql'.


Related Discussions:- Sql queries-oracle

Example of coalesce operator - sql, Example of COALESCE operator Examp...

Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

Parameter & keyword description-execute immediate statement, Parameter and ...

Parameter and Keyword Description: dynamic_string: This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block. define_vari

Using forall statement - bulk bind performance improvement, Using the FORAL...

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

Using %type-declarations in sql, Using %TYPE The %TYPE attribute gives th...

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Write an anonymous block that contains a pl/sql function, a. Write an anon...

a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

I want database development with analysis tools, Project Description: I ...

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Using operator deref - manipulating objects in pl sql, Using Operator DEREF...

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Theory of panspermia - origin of life, THEO R Y OF PANSPERMIA - Arrh...

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Declare keyword description in pl sql, DECLARE : This keyword signals t...

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

Relational operators-comparison operators, Relational Operators The rela...

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd