Conversion problem 9 textbook p 213 perform the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: . [3 marks] 2. Conversion Problem # 9, textbook p. 213 Perform the conversion for minimal NULLs in the resulting relation schemas (i.e. always use the Optional 1-M Relationship rule where appropriate). IGNORE the sentence 'List the conversion rules and the resulting changes to the tables.' [Relation schemas, with PKs and FKs labeled : 2 marks x 7 = 14 marks] 3. Conversion Problem # 10, textbook p. 214 Perform the conversion for minimal NULLs in the resulting relation schemas (i.e. always use the Optional 1-M Relationship rule where appropriate). IGNORE the sentence 'List the conversion rules and the resulting changes to the tables.' [Relation schemas, with PKs and FKs labeled : 2 marks x 8 = 16 marks] Optional Practice Suggestion (Not for marks) - code the DDL (CREATE TABLE) statements from your resulting relation schemas. Additional Marking Scheme: Cover page 1 mark Total = 40 marks...
View Full Document

This note was uploaded on 07/23/2012 for the course COMP 1730 taught by Professor Tony during the Spring '06 term at British Columbia Institute of Technology.

Ask a homework question - tutors are online