CSC316 TUI SQL Statements: Employee table

This assignment consists of 2 parts: Part 1: Answer questions Write Oracle SQL statements to create a table called Employee with the following attributes and associated data types.Write Oracle SQL statements to insert new records to the Employee table. The program should do the following:Check whether data has been loaded to the table properly. Employee EmployeeID CHAR(9) LName CHAR(15) FName CHAR(15) PhoneNo CHAR(10) — 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 Oracle live SQL does not support some of the commands such as ACCEPT. It is helpful to learn these commands though. Part 2: Write Essay Database Queries and Reports You are to finish the project by applying what you have learned to generate queries (ask questions) of the database. For the same bookstore database, write SQL statements to provide the following information for the output specified in the SLP: Employee information (e.g., employee name, address, phone number, hiring date, salary, etc.) Information about the books and CDs in the bookstore (e.g., title, author, price, etc.) Sales of CDs and books, searchable by date Current inventory status of books and CDs Any other output you think appropriate Write a 2- to 5-page paper that includes your SQL statements and screenshots of the results tables in the DBMS (database management system). use the included powerpoint presentation and word document to supplement the tables in the powerpoint for part 2

Related Posts

Quality Writing Features

Price Start $10
  • 24/7 Customer Support
  • All Subject Areas
  • Money-Back Guarantee
  • Timely Delivery
  • Originality report
  • Confidentiality guaranteed

Ordering Homework Writing Service

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.


Submit Requirements

Fill in your assignment instructions on the order form


Writer match

Immediately you contact us for homework help; we will assign your assignment to an academic expert.


Quality review

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission


Get Your Completed Paper

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.



Budget-friendly writing services



We don’t share our client’s information with a third party



We write every assignment from scratch

Amazing Homework Writing Features

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

Free Homework Writing Services

Free plagiarism checker

You can confirm that the content you get is original for free using our plagiarism checker.

Free samples

We offer unlimited access to our essay homework samples.

Free title page and bibliography

Once you place an order, we format it accordingly without demanding additional charges.

Free unlimited revisions

We offer free unlimited revisions until your assignment is of your desired quality..

Free editing and proofreading

We have a team of specialized editors who review your assignment before submission.

Free customer support

You can track the progress of your homework for free.

Request for Homework Writing Service Today!

We have over 500 homework writing experts, ready and waiting to help you improve your writing skills