Order Processing (using SQL * PLUS) -Coursework

Order Description

Referencing:
In the main body of your submission you must give credit to authors on whose research your work is based. Append
to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to
complete this assignment (e.g. for books: surname of author and initials, year of publication, title of book, edition,
publisher: place of publication)

Part A – Documentation
• SQL code used to generate each table structure;
• SQL code used to create the referential integrity constraints;
• SQL code used to create the check constraint;
• SQL code used to build the database performance tuning enhancements;
• SQL code to manage users;
• Data used to populate each table (minimum of four records per table);
• Evidence of testing carried out;
• Evidence of rollback and commit operations.
• References to books, journals, notes and web material used in the completion of the assignment
Students’ Briefing Notes
Part B
Write a report of approximately 1,000 words on the addition of Object Oriented features to the Oracle database. The report
should concentrate on the extension to the Oracle SQL Plus language and how this may be used in the Northwind Trading
Company Case Study.
• References to books, journals, notes and web material used in the completion of the assignment
• Evidence of SQL Plus language features that could be used to:
• Translate the Relational SQL Data Definition Language
• To Object-Relational Data Definition Language
• Evidence of report being linked to the Northwind Trading Company Case Study
• Report format to be used
• Good use of written English

PLACE AN ORDER WITH SIMILAR OR RELATED INSTRUCTIONS NOW.