Tag Info

New answers tagged

1

From my answer on stack overflow: http://stackoverflow.com/a/29772759/2534472 Ok, let's have a look at your 2NF attempt: Student studentID | studentName | courseCode | modCode | resultCode Course courseCode | courseTitle Module modCode | modTitle | credits Let's talk about Student first. Your key cannot be studentID, because ...


0

We have X (A, B, D, E, F, G, H, J) with A and B as primary key Y (K, L, M, N, O, P, Q, R) with K and L as primary key With functional dependencies: A -> G, H B -> D, E, F E -> F H -> G L -> N, O, P, Q N -> Q 2NF Normalization R1((A,B) (PK), J) R2(A (PK) ,G,H) R3(B (PK) ,D,E,F) R4((K,L) (PK), M,R) R5(L (PK) ,N,O,P,Q) 3NF ...


0

Yes, it's atomic; your domain is the ISBN. If you were storing the domains for ISBNPrefix, ISBNRegistrationGroup, ISBNRegistrant, ISBNPublication and ISBNCheckDigit, then you'd split it up. Consider the North American phone number +1-234-567-8901 ext 234567. Many systems choose to store such a number under two domains, such as PhoneNumber and ...


1

It's difficult to say if the ER is correct not knowing what is acceptable entered data. Based on your current design, including UserID in UserRecipes is unnecessary since you can get that information through RecipeID and joining it with the Recipes table and then using fkUserID. But I think if Recipes table is supposed to be a dish like "Lasagna" and ...



Top 50 recent answers are included