Results 1 to 2 of 2
  1. #1
    javier571 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    1

    Relational Database

    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




  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Is there a question here? Seems this could be page 1 of an exam. If you want help, please
    a) ask a specific question, and
    b) show us what you have done in attempting to "solve" the issue.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple Relational Database - Please Help!
    By hannahskellam in forum Database Design
    Replies: 2
    Last Post: 05-09-2013, 11:47 AM
  2. Few relational database questions
    By rik1254 in forum Access
    Replies: 10
    Last Post: 12-13-2012, 01:13 PM
  3. Setting up relational database
    By aceoftrades in forum Access
    Replies: 1
    Last Post: 02-22-2012, 08:42 AM
  4. Relational database for mice breeding
    By shiphtfour in forum Database Design
    Replies: 19
    Last Post: 12-16-2010, 10:01 PM
  5. Relational Database/query help
    By Champin4 in forum Queries
    Replies: 7
    Last Post: 07-14-2010, 08:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums