Members area |
|
|
|
|
Other info |
|
|
|
|
Other links |
|
|
|
|
| |
|
|
Project: database  
ID: 1211316831
| Status: |
Open
|
| Budget: |
N/A
|
| Created: |
5/20/2008 16:53
|
| Bidding Ends: |
5/27/2008 16:53 (expired)
|
| Project Creator: |
stuck06
Rating:
(No Feedback Yet)
|
| Description: |
2.Printouts of table creation statements for all tables in your database (note: table creation statements are required, not �DESC table' listings).
3.A printout of two view creation statements plus outputs from each view, together with an explanation of the rationale for each view.
4.A comprehensive set of sample data, suitably formatted and printed (using �SELECT * FROM table' statements). The printout should then be annotated to show that careful consideration has been taken to include data that fully tests the functionality of the system, as illustrated by your SQL queries (below).
5.Eight substantial SQL queries/updates that best demonstrate the functionality of the system, with an explanation of their rationale/use. The use case that each query addresses should be clearly indicated. The SQL for each query should be printed, together with the output it produces. The queries you choose should illustrate the breadth and potential of the implemented database, as well as a good understanding of SQL.
6.Two PL/SQL procedures that extend the functionality of SQL and best demonstrate your understanding of PL/SQL, with an explanation of their rationale/use � they should be used to implement business rules that you have identified. Each procedure should be displayed and executed, and proof to show the procedure/trigger works should also be submitted.
|
| Attached File: |
erdiag.docx |
| Job Type: |
sql
|
Messages Posted: 0
|
|
|
