Oracle SQL statements Discussion

Check your essay before you submit. See exactly what your professor sees.

See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.

Get Plagiarism Report Humanize My Essay

In this assignment, you are to write Oracle SQL statements to:

Create a table.
Accept user input to populate the table.
Check if the data has been added to the table properly.
Use the following as references for your assignment.

Date, Time Exercise (with answers)
Help with writing SQL commands to format date and time.
Text Processing Exercise (with answers)
Help with formatting the output and allowing users to communicate with the database.
Sequence Exercise (with answers)
Help with writing SQL statements to create sequence and alias.

This assignment consists of three parts:

Write Oracle SQL statements to create a table called Employee with the following attributes and associated data types.
Employee

EmployeeIDCHAR(9)LNameCHAR(15)FNameCHAR(15)PhoneNoCHAR(10)

Write Oracle SQL statements to insert new records to the Employee table. The program should do the following:
— Trident Bookstore —
Please enter the Employee ID: Jimmy2345
Please enter employee First Name: Jimmy
Please enter employee Last Name: William
Please enter the phone number of the employee: 714-456-3456
Note: Add at least 2 records of the data

Check whether data has been loaded to the table properly.
Oracle live SQL does not support some of the commands such as ACCEPT. It is helpful to learn these commands though.

Assignment Expectations
Copy the Oracle SQL commands to a Word document, and turn it in to the dropbox. Please note that there is no need to turn in the output of the commands, since you would most likely get a “Commands not supported” error message because of reserved words ACCEPT in your SQL.
Apply what you have learned in this module to accomplish all three parts of the assignment.

Distinguished

(100%)

Proficient

(85%)

Basic

(70%)

Below Expectations

(50%)

Non-Performance

(0%)

Thesis Statement

Raises the strongest objection to the thesis presented in the assignment. The objection is strongly grounded in research and logical reasoning.

Raises a plausible objection to the thesis presented in the assignment. The objection is mostly grounded in research and logical reasoning.

Raises an objection to the thesis presented in the assignment. The objection is somewhat grounded in research and logical reasoning.

Attempts to raise an objection to the thesis presented in the assignment. The objection is minimally grounded in research and logical reasoning.

The objection to the thesis is either nonexistent or lacks the components described in the assignment instructions.

Counter Argument

Provides a strong, thorough rebuttal to the objection. The rebuttal effectively demonstrates that the thesis can withstand the objection and applies the principles of charity and accuracy.

Provides a rebuttal to the objection. The rebuttal mostly demonstrates that the thesis can withstand the objection and mostly applies the principles of charity and accuracy.

Provides a limited rebuttal to the objection. The rebuttal somewhat demonstrates that the thesis can withstand the objection and somewhat applies the principles of charity and accuracy.

Attempts to provide a rebuttal to the objection; however, the rebuttal minimally demonstrates that the thesis can withstand the objection and does not apply the principles of charity and accuracy.

The rebuttal is either nonexistent or lacks the components described in the assignment instructions.

Conclusion

– Provides clear and concise closing remarks that comprehensively summarize the essay. The remarks consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem.

Provides closing remarks that summarize the essay. The remarks mostly consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem. The closing remarks are somewhat unclear.

Provides closing remarks that minimally summarizes the essay. The remarks minimally consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problems. The closing remarks are unclear and/or vague.

Attempts to provide closing remarks that summarize the essay, however, the remarks do not consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem. The closing remarks are unclear and vague.

The closing remarks are either nonexistent or lack the components described in the assignment instructions.

Written Communication: Context of and Purpose for Writing

Demonstrates methodical application of organization and presentation of content. The purpose of the writing is evident and easy to understand. Summaries, quotes, and/or paraphrases fit naturally into the sentences and paragraphs. Paper flows smoothly.

Demonstrates sufficient application of organization and presentation of content. The purpose of the writing is, for the most part, clear and easy to understand. There are some problems with the blending of summaries, paraphrases, and quotes. Paper flows somewhat smoothly.

Demonstrates a limited understanding of organization and presentation of content in written work. The purpose of the writing is somewhat evident but may not be integrated throughout the assignment. There are many problems with the blending of summaries, paraphrases, and quotes. Paper does not flow smoothly in all sections.

Organization and presentation of content are extremely limited. The purpose of the writing is unclear. There is little or no blending of summaries, paraphrases, and quotes. Paper does not flow smoothly when read.