dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 1 of 1

Thread: ER to relational mapping!

  1. #1
    Join Date
    Sep 2011
    Location
    Los Angeles,United States of America.
    Posts
    11

    ER to relational mapping!

    Hi,

    Here is my problem description:

    2 entities:

    a) Employee{salary,shift}

    b) Weak Entity:

    Service{hours, Data/Workcode}

    The Date /Workcode is a partial key which has it's own attributes namely DAte and Work Code.


    The above two entities are connected via a relationship named "Maintain".


    The resulting table must be like this:

    Table Name: MAINTAIN

    Salary | Date/Workcode | Hours.


    I'm confused which attribute of Employee entitiy I should selest as a primary key as nothing among Shift and Salary is mentioned as a key.

    Is my table correct above?

    Do I need to include Date/Workcode attributes as well as a separate table?If yes could you tell me what could be the resulting table?

    While mapping to Relational model,I'm confused what would be the primary key for Employees entity?
    Last edited by Jack_Tauson_Sr; September 24th, 2011 at 03:30 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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)