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
Subject
Written By
Posted
Java Class Diagram to MySQL Database Table Help
October 13, 2012 04:29AM
November 15, 2012 08:51PM
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.