|
|
|
|
SID | Building | Fee |
---|---|---|
100 | Randolph | 1200 |
150 | Ingersoll | 1100 |
200 | Randolph | 1200 |
250 | Pitkin | 1100 |
300 | Randolph | 1200 |
SID | Major | Fname |
---|---|---|
100 | Math | Cauchy |
150 | Psychology | Jung |
200 | Math | Riemann |
250 | Math | Cauchy |
300 | Psychology | Perls |
300 | Math | Riemann |
SID | Major | Activity |
---|---|---|
100 | Music | Swimming |
100 | Accounting | Swimming |
100 | Music | Tennis |
100 | Accounting | Tennis |
150 | Math | Jogging |
STUDENT(SID, GradeLevel, Building, Fee) Key:SID Constraints: Building->Fee |
Domain Definitions
SID in CDDD, where C is [1..9] and D is [0..9]
Relation and Key Definitions
STUDENT(SID, GradeLevel, Building)
BLDG-FEE(Building, Fee) |
PROFESSOR(FID, Fname, Class, SID, Sname) Key:(FID,Class,SID) Constraints: FID->Fname |
Domain Definitions
FID in CDDD, C=1; D=decimal digit Relation and Key Definitions
FACULTY (FID, Fname)
PREPARATION (Fname, Class)
STUDENT(SID, Sname, Fname) |
STU-ADVISER(SID, Sname, FID, Fname, GradFacultyStatus) Key:SID Constraints: FID->Fname |
Domain Definitions
FID in CDDD, where C is 1 and D is [0..9]
Additional Domain Definitions Relation and Key Definitions
FACULTY(FID, Fname, GradFacultyStatus)
G-ADV(GSID, Sname, Gfname)
UG-ADV(UGSID, Sname, Fname) |
Form | Defining Characteristic |
---|---|
1NF | any relation |
2NF | all nonkey attributes are dependent on all of the keys |
3NF | there are no transitive dependencies |
BCNF | every determinant is a candidate key |
4NF | there are no multivalued dependencies |
5NF | not described in this discussion |
DK/NF | all constraints on relations are logical consequences of domains and keys |
One-to-One | Many-to-One | Many-to-Many | |
Relation Definition | R(A,B) | S(C,D) | T(E,F) |
Dependencies | A->B B->A | C->D C not ->D | E not->F F not->E |
Key | Either A or B | C | (E,F) |
Rule for Adding Another Attribute | Either A or B->C | C->E | (E,F)->G |