Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2010
    Posts
    7

    Unanswered: Class Diagram to Database Table Help

    Please see attached a class diagram that i have created. I am looking to design a normalised database for this project that i am doing for college.

    Here is what i have come up with so far.
    Can anyone tell me if this is correct or not?

    Dj Booking table
    id
    customerID
    venue
    Price
    eventDate
    StartTime
    FinishTime
    dateOfBooking
    PlaylistURL
    Occasion
    BookingType
    Note Status

    Equipment Booking table
    customerID
    Price
    venue
    status
    dateOfBooking
    BookingType
    Note
    Status
    Category
    equipmentReturned
    needsToBeDroppedOf
    EquipmentIDs

    Customer Table
    name
    contactNo
    address
    email
    sourceOfContact
    dateOfContact

    DJ Table
    name
    contactNo
    address
    email
    sourceOfContact
    dateOfContact

    Corporate Customer Table
    name
    contactNo
    address
    email
    sourceOfContact
    dateOfContact
    companyName

    EquipmentTable
    name
    category (should i have another table called category and have this field categoryid???)
    price
    dateOfPurchase
    serielNumber
    operational
    Attached Thumbnails Attached Thumbnails Class Diagram2.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •