Can I get some help on this set of problems please?
PARENT (ParentNumber, ParentName, SiblingName, Job)
1.) Candidate Keys - ParentNumber and ParentName?
2.) Show a relation for two parents, (one has 3 siblings the other has one). Each Parent has one job.
3.) Show data changes to add a second job for the first parent only.
4.) Show data changes to add a second job for the second parent.
5.) Why is this relation not well-formed?
6.) Functional dependencies?
Are these the answers to 2,3,and 4?
2.) ParentID ParentNumber ParentName Job1
JobID Job
ParentNumber SiblingID SiblingName
3.) ParentID ParentNumber ParentName Job1 Job2
JobID Job
ParentNumber SiblingID SiblingName
4.) ParentID ParentNumber ParentName Job1 Job2
JobID Job
ParentNumber SiblingID SiblingName
|
|