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

Fetching with a cursor, Fetching with a Cursor The FETCH statements re...

Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

Third step at defining type sid in sql, Third Step at defining type SID in ...

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE

Write a program, to write a heap sort program usin pl-sql

to write a heap sort program usin pl-sql

Using savepoints, Using Savepoints The scope of the savepoint is a tra...

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

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

Cursors - syntax, Cursors   To execute the multi-row query, the Oracle...

Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Assignments in pl/sql, Assignments in pl/sql The Variables and constants...

Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

Pits, PITS Depressions in secondary cell wall is called pit. A pi...

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Literals in pl/sql, Literals A literal is an explicit numeric, string...

Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Use the returning clause -improve performance of application, Use the RETUR...

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

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