I'm stuck on both of these assignments I have most of them answered 

PT2520 – Database ConceptsUnit 7 HomeworkDue: February 10th, 20151. When using a SELECT statement, when is a GROUP BY clause required?2. When using a SELECT statement, when is a JOIN clause needed?3. What is the diference between an INNER JOIN, an EQUI JOIN and an OUTER JOIN?4. When using a SELECT statement, when is the HAVING keyword needed?5. DeFne re±eren²al integrity in the context o± a database.6. Under what circumstance will re±eren²al integrity prevent you ±rom dele²ng data ±rom a parent(primary key) table?7. What would be the result o± the ±ollowing SQL UPDATE statement?UPDATETUTORSETTutorKey = ‘0000’;8. What would be the result o± the ±ollowing SQL DELETE statement?DELETE³ROMTUTOR;9. Will re±eren²al integrity prevent the SQL ±rom ques²ons 7 and 8 ±rom comple²ng? Why or why not?10. In the context o± a database, what is a “trigger” and when is a “trigger” used?Please type your assignment using a word processor and submit it to your instructor at thebeginning o± class week 8.

PT2520 – Database ConceptsUnit 8 HomeworkDue:November 9th, 20151. Defne “authenTcaTon” in the context oF a database.2. Defne “authorizaTon” in the context oF a database.3. Miscroso± SQL Server supports two ways oF authenTcaTng a user, Windows AuthenTcaTon and SQLServer AuthenTcaTon. In your own words, describe a situaTon where SQL Server AuthenTcaTon shouldbe used instead oF Windows AuthenTcaTon.4. (²rue or ³alse) Roles are collecTons oF permissions and are similar in usage to the way we tradiTonallyuse groups to manage mulTple users with the same permissions.5. List three (3) built-in roles that Microso± SQL server includes and describe what permissions theygrant or deny on the database.6. What is a “schema” in the context oF a database and how does it di´er From a “role”?7. How would you analyze security needs in the context oF a database?8. Why is it important to analyze the security needs oF a database?Please type your assignment using a word processor and submit it to your instructor at thebeginning oF class week 9.

• 1496029648-Unit 7 Homework-Revised.docx
• 1496029648-Unit 8 Homework-Revised.docx

ComputerScienceExpert

(11)

Status NEW Posted 29 May 2017 03:05 AM My Price 9.00

-----------

Attachments

file 1496029651-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer