Beginning Database Design by Clare Churcher

Author:Clare Churcher
Language: eng
Format: epub, pdf
ISBN: 9781430242093
Publisher: Apress

Now we see that student and course will not be a suitable key. As soon as the student tries to enroll in the course again, we will have another row with the same values for student number and course.

Let’s try the combination (studentID, course, year):

Analyst: Is it possible for a student to enroll in the same course again in the same year (say during the summer)?

Client: It is for some subjects.

Analyst: If a student did reenroll in the same subject in the summer, would you want to keep both her previous and her new grade?

Client: Of course!

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.