Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Please solve with approves to the correct answer thank u You have been asked to

ID: 3576709 • Letter: P

Question

Please solve with approves to the correct answer thank u

You have been asked to put together a web page that will be fed with updated XML tags on a regular basis The web page will go on the company intranet and display the names, office numbers, e-mails and phone numbers of current employees. Your first step is to O Create a view to include the information above. Query the view making sure to include the line for xml auto, elements which generates the tag. Finally save the tag file as employeetags.xml O Create a view to include the information above. Query the view. O Create a view to include the information above. Query the view making sure to include the line for xml auto, elements which generates the tag. Finally save the tag file as employeetags.xsd. O Create a view to include the information above. Finally save the tag file as employee tags.xml

Explanation / Answer

you have been asked to help maintain a database where you work the DBA has appoarched you with a report that shows some mismatches for instantance in the order table the order id 5147 shows up in order _itm but does not show up in orders the dba has fixed this particular error but wants a more permanent solution what would be your suggestion ?

Answer: option 3

To add a foriegn key constraint on the ORDERID column in ORDER_ITEM