How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

OverviewImplement the tables from the COMPANY database

Customer Question

Implement the tables from the COMPANY database schema shown in the pdf
that accompanies this one in your DBMS, including data values. Then create the
following database elements:
1. A view that has the full supervisor name, department name, employee name
and employee salary in department number sequence
2. A trigger that generates a violation entry in a NEW TABLE (of your design)
when a new employee receives a lower salary than ALL other employees in
the department
Submission Instructions
You will be evaluated on:
1. The domain format and value constraints, along with the Foreign keys you
implement for the attributes in each table (10 points)
2. The View you build and execute meeting the above given requirements (20
3. The Feasibility, Flexibility, and Appropriateness of the trigger you create
for the designated INSERT statement (20 points)
Export the CREATE SQL for the resulting tables, view, and trigger. Submit
the resulting file (concatenate all CREATE files if you export more than one, they
are text files, into one file for submission) using the following naming convention:
Capture the data output from the VIEW and submit the resulting file using the
following naming convention:
lastname:firstname:Exercise08V new:txt
Capture the data output in your NEW TABLE from the INSERT Statement for a
new Employee tuple which activates the TRIGGER and submit the resulting file
using the following naming convention:
PDF visit this link:
Submitted: 6 months ago.
Category: Programming
Customer: replied 6 months ago.
I need is soon please.
Customer: replied 6 months ago.
This assignment is due at midnight , I need it befor then please .
Customer: replied 6 months ago.
(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Secure Remote Assistance. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  LogicPro replied 6 months ago.
HiWelcomeAre you using Oracle?How much time left in hours?
Customer: replied 6 months ago.
No not using Oracle , we are using MySQL workbench , and I need it as soon as possible please maybe like little less then 2 hours
Expert:  LogicPro replied 6 months ago.
ok. Time is short. Let me opt out for others to help youI would help you with other questions though
Customer: replied 6 months ago.
I need help with this question please
Customer: replied 6 months ago.
Is anybody working on this question?

Related Programming Questions