CSC316 TUI SQL Statements: Employee table

Anonymous
timer Asked: Feb 20th, 2019
account_balance_wallet $50

Question Description

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

DATABASE CONCEPTS Module 2 - SLP CSC316 Database Systems Roy E Ayscue January 26, 2019 PROBLEM DEFINITION • Design, program, and implement a Database Management System (DBMS) • Database will be able to provide the following information: • 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 DATABASE TABLE DESIGN & PRIMARY KEYS INVENTORY DATA Product ID Product Name Unit Price Cost as % of Price Current Inventory Monthly purchases SALES DATA Trans ID P.O. Number Product ID Trans Code Date Customer ID Units Sold Cashier Type Author Edition BOOK DATA Product ID = Primary Key Book Name ISBN Unit Price Year DATABASE TABLE DESIGN & PRIMARY KEYS EMPLOYEE DATA Employee Name Employee Address Phone Number Hiring Date Salary CUSTOMER DATA Customer Name Customer ID Customer Address Email Phone Number DOB Username Password PAYMENT METHOD Type = Primary Key Card Name Card Holder Phone Number Expiration Date Billing Address ER DIAGRAM

Tutor Answer

ProfessorArthur
School: Duke University

Attached.

Running Head: BOOKSTORE DATABASE MANAGEMENT SYSTEM

Bookstore Database Management System
Your Name Here
School Name Here
22 February 2019

1

BOOKSTORE DATABASE MANAGEMENT SYSTEM
Bookstore Database Management System
Database Design
The approach used to design the database is a bottom...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors