Sql scripts, PL-SQL Programming

Assignment Help:

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose marks. Include also any ALTER TABLE scripts you have used to add constraints to your tables, if you have declared them separately.

SQL ‘INSERT INTO tablename' scripts for each of your tables, showing the sample data you have inserted into your database. The data should fully test the functionality of the system, as illustrated by your SQL queries.

SQL ‘CREATE VIEW' statement for the view you have implemented.Provide also an explanation and rationale for this view: (ie who will use it, what is it for, what does it show);

For each of your 8 SQL queries, provide a) an explanation/rationale for your view (what does it show, what is it for? Who will use it?) and b) the SQL script for your query.You should produce queries that fulfil realistic case study requirements and best demonstrate your knowledge of SQL. Assume also that you have tables populated with realistic numbers of records - so very rarely, IF EVER, will you want to run a SELECT * FROM table query. You should use ‘&prompts' where appropriate to make the queries more flexible; you must also order your output. A query which produces screens of unordered output is of no use to anyone.Remember the basics: output needs to be tailored to who is using it - management will require aggregated data, operational staff detailed records etc., etc.

For each procedure/trigger, provide a) an explanation of what the code does, and b) the PL/SQL script. Note: choose triggers/procedures that best demonstrate your understanding of PL/SQL and are relevant to the case study - ie they implement a stated business rule or requirement.


Related Discussions:- Sql scripts

Out mode - parameter modes, OUT Mode An OUT parameter returns values t...

OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

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

Close statement in pl sql, CLOSE Statement The CLOSE statement allows ...

CLOSE Statement The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed

Updating variables, Updating Variables For assignment, SQL uses the ke...

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Parameter and keyword description - sql cursor, Parameter and Keyword Descr...

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

Solve the business problems using sql, Use the MASCOT tables CREDITRS, PORD...

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Procedures - syntax, Procedures The procedure is a subprogram which can...

Procedures The procedure is a subprogram which can take parameters and be invoked. Normally, you can use a procedure to perform an action. The procedure has 2 sections: the spe

Pl/sql conditional control: if statements, Pl/sql Conditional Control: IF s...

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

Example of alternative formulation as a table constraint, Example of Altern...

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

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