Register

DATABASE

430 views
0 votes
0 votes

User Avatar

1 Answer

0 votes
0 votes
I think only 1 is correct as on udate cascade will update record in foreign key column too but deleting is invalid as no on delete cascade or set null or no action is used.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
peter09 asked Apr 16
43 views
Relational Database
Give an appropriate tree-structure diagram for the following relational database: Employee (person_name, street, city) Works (person_name, company_name, salary) Company (company_name, city) Manages (person_name, manager_name)
Give an appropriate tree-structure diagram for the following relational database:Employee (person_name, street, city)Works (person_name, company_name, salary)Company (com...
User Avatar
0 votes
0 votes
1 answer
3
phaniphani asked Nov 16, 2023
199 views
Database system concepts by abraham silberschatz #14th chapter
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
User Avatar
Link Copied!