Question: Consider a database with the following four base relations and view. For the view, we are given the SQL statement that created it. cid

Consider a database with the following four base relations and view. For

 the view, we are given the SQL statement that created it. cid name. 1 Anna Bob Charlie View Ridge 2 3 Customer 1 Account aid amount type 237 address Capitol Hill University 900 checking 2000 savings 900 checking 100 savings Owns cid aid 1 1 2 1 2 

Consider a database with the following four base relations and view. For the view, we are given the SQL statement that created it. cid name. 1 Anna Bob Charlie View Ridge 2 3 Customer 1 Account aid amount type 237 address Capitol Hill University 900 checking 2000 savings 900 checking 100 savings Owns cid aid 1 1 2 1 2 2 3 3 1 2 102 103 3 4 Activity Log aid1 opid eid optype deposit 101 1 2 withdrawal 3 transfer 1 1 3 aid2 amount NULL NULL 100 200 100 Owns.cid is a foreign key that references Customer.cid. Owns.aid is a foreign key that references Account.aid. Activity Log.cid is a foreign key that references Customer.cid. Activity Log.aid1 and Activity Log.aid2 are foreign keys that reference Account.aid CREATE VIEW GoldenCustomer AS SELECT DISTINCT C.cid, C.name FROM Customer C, Owns O, Account A WHERE C.cid = O.cid AND O.aid = A.aid AND A.amount > 1000 2 CS CamScann

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!