Write An Assertion For The Bank Database To Ensure That The Assets Va

1.	Write An Assertion For The Bank Database To Ensure That The Assets Value For The Perry Ridge Branch Is Equal To The Sum Of All The Amounts Lent By The Perry Ridge Branch?
Answer» The ASSERTION-name is ARBITRARY. We have CHOSEN the name Perry. Note that since the assertion applies only to the Perry ridge branch we must RESTRICT attention to only the Perry ridge tuple of the branch relation rather than writing a constraint on the entire relation. create assertion perry check (not exists (select * from branch where branch-name = ’Perryridge’ and assets ?= (select sum (amount) from loan where branch-name = ’Perryridge’))) The assertion-name is arbitrary. We have chosen the name Perry. Note that since the assertion applies only to the Perry ridge branch we must restrict attention to only the Perry ridge tuple of the branch relation rather than writing a constraint on the entire relation.

Write An Assertion For The Bank Database To Ensure That The Assets Value For The Perry Ridge Branch Is Equal To The Sum Of All The Amounts Lent By The Perry Ridge Branch?

Answer»

The ASSERTION-name is ARBITRARY. We have CHOSEN the name Perry. Note that since the assertion applies only to the Perry ridge branch we must RESTRICT attention to only the Perry ridge tuple of the branch relation rather than writing a constraint on the entire relation.

create assertion perry check (not exists (select * from branch where branch-name = ’Perryridge’ and assets ?= (select sum (amount) from loan where branch-name = ’Perryridge’)))

The assertion-name is arbitrary. We have chosen the name Perry. Note that since the assertion applies only to the Perry ridge branch we must restrict attention to only the Perry ridge tuple of the branch relation rather than writing a constraint on the entire relation.

Discussion

No Comment Found

Related InterviewSolutions

Discuss The Advantages And Disadvantages Of The Two Methods That We Presented In Section 19.5.2 For Generating Globally Unique Time Stamps?
Give An Example Where Lazy Replication Can Lead To An Inconsistent Database State Even When Updates Get An Exclusive Lock On The Primary (master) Copy?
Explain The Difference Between Data Replication In A Distributed System And The Maintenance Of A Remote Backup Site?
Explain The Notions Of Transparency And Autonomy. Why Are These Notions Desirable From A Human-factors Standpoint?
When Is It Useful To Have Replication Or Fragmentation Of Data?
How Might A Distributed Database Designed For A Local-area Network Differ From One Designed For A Wide-area Network?
Explain How The Following Differ: Fragmentation Transparency, Replication Transparency, And Location Transparency?
Discuss The Relative Advantages Of Centralized And Distributed Databases?
Consider A Network Based On Dial-up Phone Lines, Where Sites Communicate Periodically, Such As Every Night. Such Networks Are Often Configured With A Server Site And Multiple Client Sites. The Client Sites Connect Only To The Server, And Exchange Data With Other Clients By Storing Data At The Server And Retrieving Data Stored At The Server By Other Clients. What Is The Advantage Of Such An Architecture Over One Where A Site Can Exchange Data With Another Site Only By First Dialing It Up?
Consider A Bank That Has A Collection Of Sites, Each Running A Database System. Suppose The Only Way The Databases Interact Is By Electronic Transfer Of Money Between One Another. Would Such A System Qualify As A Distributed Database? Why?