1) Draw a Normalized Database ... a. Include all keys(primary and foreign) b. add tables where necessary c. add surrogate keys to make tables unique d. add fields to database tables where it makes sense Stu-dent Num-ber Student Name Student Major Student Address Course Number Course Title Term Pro-fessor Profes-sor's De-partment Grade 333-24-3333 Steve Lee Math 123 Main St. Chicago IL Math201 Algebra Fall Dr. Euclid Math B+ 333-24-3333 Steve Lee Math 123 Main St. Chicago IL History 310 US His-tory Fall Dr. Vidal History A 222-56-4444 Rusty Larue CS 456 Madi-son Chicago IL History 310 US His-tory Winter Dr. Vidal History B- 666-11-7373 Dennis Rod-man An-thropology 234 LaBrea Los Ange-les English 455 Shakespeere Winter Dr. Jon-son English A

2) Suppose the organization has the following description of a discount policy: A phone card company has a policy of discounting its cards to customers under certain circum-stances: Discounts are given to the customer if payment is received within 2 weeks. If the amount of the order of phone cards is greater than $50, subtract 5% from the or-der. If the amount is greater than or equal to $20 and less than or equal to $50, then subtract 3% discount from the order a) Represent this situation as a decision table b) Represent the situation above as a decision tree.