answer these five questions carefully. this course is about database management system. 

 

1You place two PHP scripts on Mentor--emplist.php and regions.php. When youaccess emplist.php, you see the message, “Internal Server Error.” What mustbe done to fx this? When you access regions.php, you see text at the top oF thepage stating what is suppose to display, but no results are shown. Discuss at leasttwo possible reasons For this. Be specifc. Don't just say there was an error in theSQL statement. What are some possible errors?2 Whatis the defnition oF a VIEW in an RDBMS. Discuss why a developer woulduse this.3 Convertthe Following subquery to a standard query using INNER JOIN syntax.SELECT dirname FROM directorWHERE dirnum IN ((SELECT dirnum FROM movie WHERE mvnum IN(SELECT mvnum FROM movstar WHERE starnum=2));4Explainthe concept oF ReFerential Integrity within RDBMSs. How is itimplemented in SQL? What kind oF problems does this prevent?Create an ERD from the following Business Rules. Use any program ofyour choice. Save as a PDF and upload the image to Canvas for thisquestion.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.

Attachments:

• 1496019063-assginment .docx