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

Ask a homework question - tutors are online