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

     

Transcribed Image Text:

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 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