[kevinkhan]

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