This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Summer '10
- Databases, minimum password length, Rue, Internal inventory ID, id_num int IDENTITY, internal id number