Question Details

[answered] Assist with these requirements. Thank you. Use DDL statemen


  1. Assist?with?these?requirements.?Thank?you.?
  2. Use DDL statements to create, alter, and drop tables
  3. Use DML statements to insert, update, and delete records
Requirements

  1. 1. Run the CreateMy_Employee.sql script to build the MY_EMPLOYEE.
  2. 2. Describe the structure of the MY_EMPLOYEE table.
  3. 3. Add the first row of data to the MY_EMPLOYEE table from the sample data in the following table. Do not list the columns in the INSERT clause.

ID

LAST_NAME

FIRST_NAME

USERID

SALARY

1

Patel

Ralph

Rpatel

895

2

Dancs

Betty

Bdancs

860

3

Biri

Ben

Bbiri

1100

4

Newman

Chad

Cnewman

750

5

Ropeburn

Audrey

Aropebur

1550

  1. 4. Populate the MY_EMPLOYEE table with the second row of sample data from the preceding table. This time, list the column explicitly in the INSERT clause.
  2. 5. Confirm your additions to the table.
  3. 6. Change the last name of employee 2 to ?Drexler?.
  4. 7. Change the salary to 1000 for all employees with a salary less than 890.
  5. 8. Verify your changes to the table.
  6. 9. Delete ?Ralph Patel? from the table.
  7. 10. Confirm your changes to the table.
  8. 11. Create the MY_TITLES table based on the following table. Place the SQL command in a script called ?CreateMy_Titles.SQL?. Then, execute the script to create the table.

Column Name

Id

Title

Category

Publisher

Price

PubDate

Key Type

Nulls/Unique

FK Table

Data Type

Char

Varchar

Varchar

Char

Decimal

DateTime

Length

3

40

10

3

5, 2

  1. 12. Confirm that the table was created.
  2. 13. Populate the MY_TITLES table with data from the TITLES table. Include only the columns that you need.
  3. 14. Confirm that the data loaded correctly.
  4. 15. Create the EMP table based n the following table. Place the syntax in a script called CreateEmp.SQL. Then, execute the script to create the table.

Column Name

Id

Last_Name

First_Name

Dept_Id

Key Type

Nulls/Unique

FK Table

FK Column

Data Type

Decimal

Varchar

Varchar

Decimal

Length

7

25

25

7

  1. 16. Confirm that the table was created.
  2. 17. Modify the EMP table to allow for 30 character employee last names.
  3. 18. Confirm your modification.
  4. 19. Confirm that both the MY_EMPLOYEE and EMP are stored in the data dictionary.
  5. 20. Create the EMP2 table (using a SELECT INTO statement) based on the structure of the EMP table. Include only the Id, Last_Name, and First_Name columns. Name the columns in your new table Emp_ID, LName, and FName, respectively. Do not include any EMP table rows.
  6. 21. Confirm that the table was created.
  7. 22. Drop the EMP2 table.
  8. 23. Confirm that the table was droped
  9. 24. Drop the First_Name column from the EMP table.
  10. 25. Confirm that the column was dropped.
  11. 26. Add a table-level PRIMARY KEY constraint to the EMP table on the ID column. The constraint must be named emp_id_pk at creation.
  12. 27. Confirm that the constraint was added.
  13. 28. Add a column EmpID to the EMP table. The column has a data type of DECIMAL (7).
  14. 29. Confirm that the column and constraints was added.
  15. 30. Display information about the tables from the data dictionary.
  16. 31. isplay information about the constraints from the data dictionary.
  17. 32. Display information about the table columns from the data dictionary.
  18. 33. Display information about indexes from the data dictionary. Notice that new indexes were created. What are the names of the indexes.
  19. 34. Modify the EMP table. Add a COMMISSION column of the DECIMAL data type, precision 2, scale 2. Add a constraint to the COMMISSION column that ensures that a commission value is greater than zero. Name the constraint emp_commission_ck.
  20. 35. Confirm your modification.
  21. 36. Change the publisher of all Tenterhooks Press books to Abatis Publishers.
  22. 37. Delete the rows for books published by publisher P01 or P04 from the title_authors table.

38. Create a table that is available to only you and that dematerializes when your DBMS session ends. Name the table TempAuthors. Use the same columns and data types used in the Authors table.


Confirm addition of second row Updating employee 2

 

UPDATE my_employee SET last_name='drexler' WHERE ID=2 Confirm Salary Update Confirm Deletion Confirm creation of Emp Confirm Creation of My_Titles...

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001005173.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now