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

Count operator in sql, Count Operator in SQL Example: Counting the stu...

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Need for dynamic sql - pl sql , Need for Dynamic SQL: You need dynamic...

Need for Dynamic SQL: You need dynamic SQL in the situations as follows: 1) You would like to execute a SQL data definition statement (like CREATE), a data control statemen

Data types in sql, Data Types in SQL SQL's concept does not differ sig...

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

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

Update stock levels, At times, customers make mistakes in submitting their ...

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

Keyword and parameter description - delete statement, Keyword and Parameter...

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Logical operators-pl/sql expressions , Logical Operators The logical op...

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.

Example of group by and collect operator, Example of GROUP BY and COLLECT O...

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Sql pseudocolumns, SQL Pseudocolumns The PL/SQL recognizes the followin...

SQL Pseudocolumns The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are n

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