INFS_428_Assg_3 - INFS 428 Chapter 4 Problems and Exercises...

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

View Full Document Right Arrow Icon
INFS 428 Chapter 4 Problems and Exercises Kristen Jack Problem 5 (assuming instructor location is their office) Instructor (instructor id , instructor name, instructor location) Student (student no. , student name, major) Course (course no. , course title) Grade Book (course no. student no. , grade) Problem 13 (a) The determinants are: St ID, Ticket #, and Code St ID L Name F Name Phone No St Lic Lic No Ticket # Date Cod e Fin e 3824 9 Brown Thoma s 111- 7804 FL BRY 123 15634 10/17/1 0 2 $25 3824 9 Brown Thoma s 111- 7804 FL BRY 123 16017 11/13/1 0 1 $15 8245 3 Green Sally 391- 1689 AL TRE 141 14987 10/05/1 0 3 $10 0 8245 3 Green Sally 391- 1689 AL TRE 141 16293 11/18/1 0 1 $15 8245 3 Green Sally 391- 1689 AL TRE 141 17892 12/13/1 0 2 $25 (b) (c) With the relation as it was, modification anomalies can occur when changing phone no., you have to change it on each row. (d) Student (St ID , L Name, F Name, Phone No, St Lic, Lic No) Code Rule (Code , Fine, Violation) Ticket (Ticket # St ID Code , Date)
Background image of page 1

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

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

This note was uploaded on 02/20/2012 for the course ACC 3101 taught by Professor Tom during the Spring '11 term at American University in Bulgaria.

Page1 / 2

INFS_428_Assg_3 - INFS 428 Chapter 4 Problems and Exercises...

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

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