Sql queries-oracle , PL-SQL Programming

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'.

Posted Date: 3/12/2013 2:29:37 AM | Location : United States







Related Discussions:- Sql queries-oracle , Assignment Help, Ask Question on Sql queries-oracle , Get Answer, Expert's Help, Sql queries-oracle Discussions

Write discussion on Sql queries-oracle
Your posts are moderated
Related Questions
SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

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

EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Authorisations - Privileges As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privilege