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

Keyword, what is the use of declare keyword

what is the use of declare keyword

Explicit cursors, Explicit Cursors The set of rows returned by the que...

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

How to use the explain plan for statement, Using the student and faculty ta...

Using the student and faculty tables create a select query that outputs all students for a specific advisor. Generate the execution plan, select out the explain plan . Create an

Character types, ROWID and UROWID Internally, every database table has ...

ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

Primary key - sql, Primary Key - SQL A PRIMARY KEY specification carri...

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

Package body in pl/sql, Package Body: The package specification is imp...

Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

Data types, Datatypes Every constant and variable has a datatype that s...

Datatypes Every constant and variable has a datatype that specifies the storage format, constraints, and the valid range of values. The PL/SQL gives a variety of predefined dat

Left and right joins, Left and Right Joins LEFT OUTER JOIN can be used...

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Using raise_application_error - user-defined exceptions, Using raise_applic...

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Declaring and initializing objects in pl/sql, Declaring and Initializing Ob...

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

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