Re: ERD Database Modelling Help
Posted by: Peter Brawley
Date: March 26, 2011 09:07PM

Keep a cheatsheet of ERD symbols in front of you.

An employee can have zero or more assignments, so emp_id is to be an assignment foreign key referencing employee, so those lines of the create table assignment command will say ...

...
empid smallint unsigned not null,
foreign key(empid) references employee(emp_id)
...

If you want to study a MySQL implementation of this in MySQL, I suggest you put away Visio and try MySQL WorkBench, where you can see what happens when you tell it to build the DB.

PB

Options: ReplyQuote


Subject
Written By
Posted
March 26, 2011 08:36PM
Re: ERD Database Modelling Help
March 26, 2011 09:07PM


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.