Java Class Diagram to MySQL Database Table Help
Posted by: Kevin Khan
Date: October 13, 2012 04:29AM

Please see this link http://djhirecork.com/project/classDiagram.jpg for 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

Options: ReplyQuote


Subject
Written By
Posted
Java Class Diagram to MySQL Database Table Help
October 13, 2012 04:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.