Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for project 1. Your script must also include queries to demonstrate that all objects are created successfully (i.e. selecting from the database catalog/data dictionary using user_objects and user_tables). Additionally, you must submit a separate document that contains the complete textual output from running your DDL script successfully. Your score will include the evaluation of this output report as well as a live, error-free expected run of your script in the environment. Within your DDL SQL script, the following minimum requirements must be met: Data Definition Language (DDL) SQL Script Minimum Requirements: 1. Drop Statements for All Objects as needed (5 points) At the beginning of your script, ensure that all objects that are required to be dropped are properly dropped. 2. Create/Alter Statements for All
The post Create SQL script containing data definition language appeared first on Assignment Freelancers.
