Recent content by jmq

i guess this is enough. time to build the physical db.. i will get in touch every time i'm stuck coding..

jdraw, i guess this is the reason why open source software always is better than proprietary ones. simply because of the collaborated idea/logic of infinite participants. :) i like this. :) i kinda grasp the idea of these er stuff in Lightwave's model. very identical to object oriented...

Lightwave, the idea was very interesting! i will study on this further! Thank you! it's like creating a Class namely Person then Children. all are generic. the difference is the Class "Children" has a field called [mother] and [father]. i think we can even extend this to having only a Class...

[qoute] I was like you I suddenly discovered something which probably had been under my nose for years. You quickly realise that as much as you know you maybe don't know anything. what da?!:eek: lightwave, you and jdraw are brothers or something? :D you have a tongue like jdraw. very poetic in...

oh i get it. this is great! :) thank you!

jdraw, my goal is to create a professional database one day. starting from paper model, to er diagrams, to flowchart of system. so far, everything works for this model. i will try to build the physical db now. with the videos, i can probably watch that on weekends if i can. i'm doing this in...

oh i see. i noticed that every time i mistakenly drag a table to a relationship diagram. so if i have tableA and tableB to have that many to many without manually creating a junction table, i'll just drag tableA again to the relationship diagram thus giving me a tableA, tableA_1, and tableB now...

jdraw, i getting poetic now. :D

It's crazy doing stump alone! :D I don't have employees. I don't have stuff I don't have anyone who cares to do a stump but me. :D lol:D

jdraw, I'm doing it now. i guess i have to focus on that first. and come back to this later. hehehe:D i hope i can submit that here as sample db. :p

i like the idea! i just want to clarify some things.. when you say junction, you mean a many to many relationship? so if i merge the dependents+employees = persons then create a junction labelled personJunction i think this will result to one to many? cause i only have 2 tables now persons...

yes i need to track their addresses. some department has the same rate per position while other has different rate.

jdraw, DeliveryDate DeliveriesTable CustomerInfo Customer Table OrderInfo Orders Table ProductName Product table (via OrderFetails,ProductPrices) ItemQty OrderDetails ItemUnitSellingPrice OrderDetails(AgreedToPrice) Good Received checkbox may be on a paper form Who was...

jdraw, i think i get it. table deliveries will be the receipt? like this?

of course i want a receipt. i just can't figure it out in my model yet.