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