KEMBAR78
CE5 RelationalModel | PDF
Scribd
Upload
37 views4 pages

CE5 RelationalModel

The document discusses relational databases and relational algebra operations. It lists sets and their cartesian product, defines relational integrity constraints, and provides examples of relational algebra queries including selection, projection, join, insertion, deletion and update operations.

Uploaded by

No one
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
37 views4 pages

CE5 RelationalModel

The document discusses relational databases and relational algebra operations. It lists sets and their cartesian product, defines relational integrity constraints, and provides examples of relational algebra queries including selection, projection, join, insertion, deletion and update operations.

Uploaded by

No one
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

[Relational Model]

1. Please list set R  set S.


R = {1, 2, 3, 4}, S = { a, b, c}
2. Please list the relational integrity constraints and explain them.

3. Pleas find out candidate keys from above table.


4. Please find out the primary key from above able.
5. Please find out that whether following operation will be a success or an error.
6. Insert <‘Robert’, ‘F’, ‘Scott’, ‘943775543’, ‘1952-06-21’, ‘2365 Newcastle Rd, Bellaire, MD’, M,
58000, ‘888665555’, 1> to EMPLOYEE.

7. Insert <‘ProductA’, 4, ‘Bellaire’, 2> to PROJECT


8. Insert <Production’, 4, ‘943775543’, ‘1998-10-01’> into DEPARTMENT.

9. Insert <‘677678989’, NULL, ‘40.0’> to WORKS_ON.

10. Delete the WORKS_ON tuples with ESSN = ‘333445555’


11. Delete the EMPLOYEE tuple with SSN = ‘987654321’

12. Delete the PROJECT tuple with Pname = ‘ProductX’.


13. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to
‘123456789’ and ‘1999-10-01’, respectively

14. Modify the Super_ssn attribute of the EMPLOYEE tuple with SSN = ‘999887777’ to ‘943775543’.

15. Modify the Hours attribute of the WORKS_ON tuple with Essn = ‘999887777’ and Pno = 10 to
‘5.9’

You might also like