1 Problem Description
The objective of this assignment is to:
(1) enhance your understanding of Relational Database Design & Implementation, and
(2) understand & practice with PL/SQL in particular database interaction, functions & procedures, check constraints, triggers and packages.
The assignment will consist of three (3) tasks.• Task one will involve the extension of the relational model from assignment 1 and the development of the code for maintaining the consistency of the database. • Task two will involve the development of several functions and procedures which will be encapsulated in a package with a separate specification (header) and a body (implementation).• Task three will involve testing the code developed as part of Tasks one and two. You may want to insert a sufficient number of rows into the tables so that you can demonstrate the workings of all the code components.Methodology• Study the relevant chapters from the prescribed textbooks and go over the practical exercises so far.
• Using your solutions to assignments 1 & 2, create the DDL/SQL script file to create the tables and attributes (dropping them all beforehand of course). Place the model with DDL statements into your report.
• Write the code for Task one in a separate SQL script and test it to check for errors.
• Write the package specification and the package body in two separate SQL scripts.
• Write the SQL script file to insert the records (at least five records per table) into the tables.
• Test the functions and procedures provided in the package.
• Refer to the Oracle 10g documentation files when necessary.
• Compile all the separate SQL scripts together into a single script (Assignment3.sql).
• Place the test results into your report (Assignment3.doc).这个只是题目的一部分。。希望看懂英文的
The objective of this assignment is to:
(1) enhance your understanding of Relational Database Design & Implementation, and
(2) understand & practice with PL/SQL in particular database interaction, functions & procedures, check constraints, triggers and packages.
The assignment will consist of three (3) tasks.• Task one will involve the extension of the relational model from assignment 1 and the development of the code for maintaining the consistency of the database. • Task two will involve the development of several functions and procedures which will be encapsulated in a package with a separate specification (header) and a body (implementation).• Task three will involve testing the code developed as part of Tasks one and two. You may want to insert a sufficient number of rows into the tables so that you can demonstrate the workings of all the code components.Methodology• Study the relevant chapters from the prescribed textbooks and go over the practical exercises so far.
• Using your solutions to assignments 1 & 2, create the DDL/SQL script file to create the tables and attributes (dropping them all beforehand of course). Place the model with DDL statements into your report.
• Write the code for Task one in a separate SQL script and test it to check for errors.
• Write the package specification and the package body in two separate SQL scripts.
• Write the SQL script file to insert the records (at least five records per table) into the tables.
• Test the functions and procedures provided in the package.
• Refer to the Oracle 10g documentation files when necessary.
• Compile all the separate SQL scripts together into a single script (Assignment3.sql).
• Place the test results into your report (Assignment3.doc).这个只是题目的一部分。。希望看懂英文的
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货