Chapter 10: functional dependencies and normalization for relational
CHAPTER 10: FUNCTIONAL DEPENDENCIES AND NORMALIZATION FOR RELATIONAL DATABASES Answers to Selected Exercises 15.19 Suppose we have the following requirements for a university database that is used to keep track of students transcripts: (a) The university keeps track of each student’s name (SNAME), student number (SNUM), social security number (SSSN), current address (SCADDR) and phone (SCPHONE), permanent address (SPADDR) and phone (SPPHONE), […]