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

Defining records, Defining and Declaring Records To create records, yo...

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Sql, Write a query to find academics that are authors and that have only ev...

Write a query to find academics that are authors and that have only ever coauthored papers with authors from institutes in the same state as their own. List their academic number,

Cursor attributes in dynamic sql - pl sql, Using Cursor Attributes: Ev...

Using Cursor Attributes: Every cursor has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. If appended to the cursor name, they return the helpful information about

Goto statement - syntax, GOTO Statement   The GOTO statement branches ...

GOTO Statement   The GOTO statement branches categorically to a block label or statement label. The label should be exclusive within its scope and should precede a PL/SQL bloc

Authorize and fetch data from instagram, Authorize and fetch data from Inst...

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Maintain an audit trail of product table changes, The accuracy of product t...

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Using default-declarations in sql, Using DEFAULT You can use the keyword...

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Use of table comparisons - sql, Use of Table Comparisons - SQL Table ...

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Transactions in sql, Transactions in SQL BEGIN TRANSACTION, COMMIT, an...

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Aggregate assignment-declarations in sql, Aggregate Assignment The %ROWT...

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

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