Cs 4400 Quiz 2 Navathe Omienciski

Cs 4400 Quiz 2 Navathe Omienciski - KEY TO QUIZ 2 NOTE: Q21...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
KEY TO QUIZ 2 NOTE: Q21 has been cancelled due to incorrect wording of the question. (the word “scalar” should have been “computed”. )If you have it marked wrong, you will be given credit for it. CS4400 – Summer 2007 QUIZ 2 (Navathe/Omiecinski) Refer to the following relational schema and the current state of the relations for appropriate questions in this quiz. Primary keys are undelined. Customer (CID , Cname, City) Account (AID , Balance, Type, Limit) CustomerAccount (CID, AID ) TransactionHistory (AID, Date , Amount, Trans_Type) AID is account ID CID is a foreign key in CustomerAccount referencing the Customer relation AID is a foreign key in CustomerAccount referencing the Account relation AID is a foreign key in TransactionHistory referencing the Account relation Primary keys are underlined Limit is an overdraft limit for the account (you can overdraw account upto the limit) Customer Account CID Cname City AID Balance Type Limit 101 John Smith Marietta 102 Jane Doe Marietta 103 Bob Jones Atlanta 104 Jim Brown Atlanta 105 Sue Brown Atlanta 106 Ash Patel Alpharetta CustomerAccount TransactionHistory CID AID AID Date Amount Trans_Type 101 1 101 3 102 4 103 2 103 5 104 6 Summer 07- Quiz 2-posted key Page 1 Navathe/Omiecinski 1 1000 Saving 20000 2 5000 Saving 10000 3 100 Saving 0 4 50 Checking 5000 5 200 Checking 1 6 2000 Checking 25000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
105 6 Summer 07- Quiz 2-posted key Page 2 Navathe/Omiecinski 1 2007-06-02 18000 Withdraw 2 2007-06-04 5000 Deposit 4 2007-06-11 100 Deposit 3 2007-06-12 10 Deposit 4 2007-06-12 6000 Withdraw 5 2007-06-12 50 Withdraw 5 2007-06-15 100 Deposit
Background image of page 2
NAME (LAST, FIRST)______________________________________ GT_ID____________________________________________ CS4400 – Summer 2007 QUIZ 2 (Navathe/Omiecinski) 1. Which statement is true for the Customer relation? (a) CID, City is a superkey (b) the degree of the relation is 3 (c) the 6 tuples represent a state of the CUSTOMER relation (d) all of the above (e) Only (a) and (b) 2. Which of the following statements are true? (a) a tuple in the CustomerAccount relation cannot have a null value for AID (b) a tuple in the Account relation cannot have a null value for Balance (c) a tuple in the TransactionHistory relation can have a null value for Date (d)all of the above (e) Ony (a) and (c) 3. Which of the following statements are true? (a) Several attributes in a relation may have the same domain.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Cs 4400 Quiz 2 Navathe Omienciski - KEY TO QUIZ 2 NOTE: Q21...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online