Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Natural/ business key Come from[…]
Read moreCategory: Database
Mapping Ternary Relationships,”STUDENT(StudentID, StudentName)COURSE(CourseID, CourseName)PROFESSOR(ProfID, ProfName)RELATESTO(StudentID, CourseID
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Mapping Ternary Relationships,”STUDENT(StudentID, StudentName)COURSE(CourseID, CourseName)PROFESSOR(ProfID,[…]
Read moreAugmentation,”if X → Y, then XZ → YZIn other words
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Augmentation,”if X → Y, then[…]
Read moreSurrogate keys,”(those with no business meaning such as 001, 002
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Surrogate keys,”(those with no business[…]
Read moreMapping Weak Entities,”except the primary key(s) from any attached strong entity or entities must be included with the weak entityMOVIE(MovieID, MovieName, ReleaseDate)VIDEO-TAPE(CopyNumber, DateAcquired
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Mapping Weak Entities,”except the primary[…]
Read moreTransivity,”if X → Y and Y → Z
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Transivity,”if X → Y and[…]
Read moreKey constraints,”A relation must have at least one candidate key such that for every tuple
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Key constraints,”A relation must have[…]
Read moreMapping Aggregation,”Relationships involving aggregations should reference all necessary primary keys from inside the aggregationEx.STUDENT(StudentID, StudentName)COURSE(CourseID, CourseName)PROFESSOR(ProfID, ProfName)TAKES(StudentID, CourseID)TEACHES(ProfID, StudentID
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Mapping Aggregation,”Relationships involving aggregations should[…]
Read moreDecomposition,”If X → YZ
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Decomposition,”If X → YZ then[…]
Read moreDomain contraints,”Attributes must be of the same type and consistent with domain rules. For instance
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Domain contraints,”Attributes must be of[…]
Read more