Assignment 5 Solutions

Assignment 5 Solutions - 4. What uniqueness constraints do...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 5 Solutions Summary Questions 1 - 20 1. A 2. D 3. C 4. False 5. False 6. C 7. D 8. B 9. True 10. B 11. True 12.A 13. E 14. C 15. True 16. C 17. False 18. A 19. True
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
20.B Project 5.2 Part Case #3 1. How can you automatically ensure that a customer doesn’t pick a screen name that someone else is already using? Place a unique constraint on the username column. 2. What’s the easiest way to enforce minimum password length in the database? Place a check constraint on the password column. 3. What kind of database object can you use to ensure that programmers don’t display more information out of the inventory than you want users to see? Create a view that includes only the columns to which users should have access.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4. What uniqueness constraints do you need to enforce on the inventory table? Internal inventory ID. The combination of vendor ID and vendor part number. 5. What place, if any, should default constraints have in the design? Define a default of "Description pending" on the column containing the long description. 6. What should you use to enforce ordering limits on high-value items through the database? You would use a trigger. 7. How do you generate an internal id number? Use the Identity option in SQL Server : CREATE TABLE new_employees ( id_num int IDENTITY(1,1), fname varchar (20), minit char(1), lname varchar(30) )...
View Full Document

Page1 / 2

Assignment 5 Solutions - 4. What uniqueness constraints do...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online