Pt2520 Unit 6 Lab 1

Mekao Tramil
November 11, 2014
PT2520 Unit 9 Labs

Lab 9.1

1. Both SQL server and windows authentication mode is enabled.

Lab 9.2

13. What is a natural key? What are the advantages and disadvantages of using natural keys?
14. What are access and security requirements?
15. What is one to one relationship?
16. What are many to many relationships?
17. What are linking entities?
18. What are domain entities?
19. What are weak entities?
20. What is normalization?
21. What is first normal form?
22. What is third normal form?
23. What are deletion anomalies?
24. What is the difference between the logical design and the physical design of a database?
25. What are data types?
26. What is the difference between nchar and nvarchar
data types?
27. What are nulls in a database?
28. What is referential integrity?
29. What is the effect of “enforcing referential integrity” on the “insert action’ change to the data in a database? 30. Enforcing referential integrity protect the database from data
31.
32. What is the difference between data manipulation language and data definition language in SQL?
33. What is the purpose of the wildcard asterisk(*)?
34.
35. What is the purpose of the % wild card character? Give an Example?
36. What is the difference between scalar and aggregate functions?
37. What key word should be used instead of WHERE?
38. What happens when you use an UPDATE or a DELETE without a WHERE clause?
39. What is an inner join? Give an example?
40. What are equi joins? Give an example?
41. What is authentication?
42. What is permission?
43. In SQL server a login is a level account
44. What are roles?
45. What is the purpose of the db_owner role?