Hw1 - Figure 1 COMPANY relational database schema 1....

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

View Full Document Right Arrow Icon
Figure 1 COMPANY relational database schema 1. Suppose each of the following update operations is applied directly to the COMPANY relational database schema. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints: a. Insert < 'Flora', 7, 'Taipei', '3'> into PROJECT b. Insert < 'Marketing', null, '333666999', '1988-06-30' > into DEPARTMENT c. Insert <'Eason', 'E', 'Chan', '777777777', '1974-07-27', '220 New Taipei, TW', M, 53000, '888665555', 1> into EMPLOYEE. d. Delete the DEPENDENT tuple with ESSN= '987654321'. e. Modify the SALARY attribute of the EMPLOYEE tuple with SSN= ‘123456789' to ‘50000’ 2. Consider the relation 課程 ( 流水號 , 課程名稱 , 授課老師 , 學期 , 教室 , / 選修 , 學分 , 時段 ). Find out the attributes that can be candidate keys with related assumptions you defined. 3.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Hw1 - Figure 1 COMPANY relational database schema 1....

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