Q1
You place two PHP scripts on Mentor–emplist.php and regions.php. When you
access emplist.php, you see the message, “Internal Server Error.” What must
be done to fix this? When you access regions.php, you see text at the top of the
page stating what is suppose to display, but no results are shown. Discuss at least
two possible reasons for this. Be specific. Don’t just say there was an error in the
SQL statement. What are some possible errors?
Q2
What is the definition of a VIEW in an RDBMS. Discuss why a developer would use
this.
Q3
Convert the following subquery to a standard query using INNER JOIN syntax.
SELECT dirname FROM director
WHERE dirnum IN ((SELECT dirnum FROM movie WHERE mvnum IN
(SELECT mvnum FROM movstar WHERE starnum=2));
Q4
Explain the concept of Referential Integrity within RDBMSs. How is it implemented
in SQL? What kind of problems does this prevent?
Q5
Create an ERD from the following Business Rules. Use any program of
your choice. Save as a PDF and upload the image to Canvas for this
question.
A sales representative writes many invoices.
Each invoice is written by one sales rep. (can’t be more than 1 at a time)
Each sales rep is assigned to one department
Each department has many sales reps.
A customer may generate many invoices
An invoice may be generated by one customer only.
