var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with building Entity relationship diagrams?
Hi I am new here. I have to draw an erd, well I finished drawing it, just trying to figure out a few things. I'm not sure if this is the right place. Thanks. I'm not sure if this is the correct forum.. Thanks
I'm not sure anywhere is the correct forum, since you do not pose a question. If you look a little further down the list here on DBFORUMS there is a Database Concepts and Design board.
This is what I have to do, but thanks Ill post it in the other forums
Draw the corresponding ERD for the following data structure:
Products(ProID, Descrip, Cost, Price, CatID)
People(ID, FName, LName, Phone)
Employees(EID, DOH, DOB, SupervisorID)
ClientAddress(CLID, CID, Street1, Street2, City, State, Zip)
PriceHistory(PrID, ProductID, Price, StartDate, EndDate)
InvDetail(InvNum, DetID, Qty, ProdID, UnitPrice, Discount)
InvHeader(InvNum, Date, ClientID, CliAddrID, SalesPersonID, Memo)
Underline stands for primary key
Italic stands for Foreign key.
you still haven't posed a question as to what your problem is.
What few things?
I finished drawing it, just trying to figure out a few things.
I went ahead and posted in the other forum like you suggested.
I am trying to figure out, with the objects that contain a foreign key? Does that Object then and always indicate a many object?
Are the primary keys in each object suppose to be connected, with the primary keys in other related object boxes?