Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
10-13-2012, 11:21 AM #1
- Join Date
- Jun 2009
- Thanked 0 Times in 0 Posts
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
Equipment Booking table
Corporate Customer Table
category (should i have another table called category and have this field categoryid???)
10-13-2012, 10:15 PM #2
No, it is not correct. But neither is your ER diagram.
Where is you BOOKING table???
You seem to have subsumed it TWICE into EquipmentBooking and DJBooking. I think that's a mistake. Here, the ER diagram is right.
I don't see the primary keys in any of your tables in the ER diagram. No bookingid for example. And you use customerid in your two booking tables but you don't have customerid as a primary key in your customers table. And and and and...
Yes, you clearly need a category table.
You have no fields at all in either the DJ table or the DJBookingTable that allows them to be linked together.
I'm sorry, but both the ER and the classes need to completely reworked.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.