IT 403 Saudi Electronic University Fundamentals of Databases Discussion

1-Give an example of a relation schema R ? and set F ? of functional dependencies such that there are at least three distinct lossless-join decompositions of R ? into BCNF

2-Give an example of a relation schema R and a set of dependencies such that R is in BCNF but is not in 4NF.

3-List any four characteristics of a bad database design?

4-Normalize the following Schema with the given functional dependencies into BCNF.

EnrollTrain (TraineeID, ClassID, Level, TrainerID, TraineeName)

Functional Dependencies:

FD1: TraineeID, ClassID à Level, TrainerID, TraineeName

FD2: TraineeID àTraineeName

FD3: ClassID®TrainerID

5-There are many scalability challenges of a proxy service. Explain one of these challenges and propose a solution to handle it?

______________________________________________________________________

hi plz finish on time

AVOID plagiarism