Abstract:
Implement an ER diagramming tool fully integrated with pgAdmin. The tool will have the following features: draw database diagrams, apply diagram  modifications to database and, use different notation formats.


Project: ER diagraming tool for pgAdmin
Name: Euler Taveira de Oliveira
E-mail: euler@timbira.com
IRC: Freenode (PentiumII - #postgresql, #postgresql-br)
IM: eulerto@msn.com (MSN), pentiumii@jabber.org (Jabber), 66724246 (ICQ), euler.taveira (Skype)
Languages: Portuguese, English
City: Porto Alegre, RS, Brazil

PostgreSQL community:
I'm a member of PostgreSQL community since 2001. I developed some small features and i'm the pt-br translation maintainer [1]. I'm a member of brazilian PostgreSQL community too.
[1] http://www.postgresql.org/developer/bios

Skills:
Plataforms: Linux, *BSD, Windows, Solaris;
Languages: C, C++, Java, PHP, HTML, XML;
Databases: PostgreSQL, MySQL, Oracle, MS SQL Server;
Services: Web, DNS, E-mail, DHCP, SAMBA, LDAP, FTP;
Techniques: Backup, Recovery, High Availability, Information Security, Network Protocols.
Academic Background: Computer Engineer (UFG:1998-2002), Mastering Computer Science (UFRGS:2007-2009);

Project Summary:
Implement an ER diagramming tool fully integrated with pgAdmin. The tool will have the following features: 
1) draw database diagrams: the ability to draw relation with its attributes, constraints, keys and draw relationships among them. The idea is to use the wxArt2D library [2] (it's tightenly integrated in wxWidgets [library used in pgAdmin] and it's actively maintained);
2) get the modifications in the diagram and apply it to schema/database: map modifications to SQL statements;
3) save the diagram in a proposed format (xml-based): draft a XML DTD format to store the metadata;
4) use different notation formats for diagrams (Barker's, IDEF1X, others?): make an abstraction layer to support all of the notation formats.

[2] http://wxart2d.sourceforge.net/

Steps:
1) draft a XML DTD to save the diagram metadata;
2) draft the interface integrated in pgAdmin;
3) implement the drawing diagram feature;
4) implement the diagram-to-saving-format feature;
5) implement the metadata to SQL statements feature;
6) implement different notation formats for diagrams.

pgAdmin Project:
No. I'm a mere user but already looked at the code sometimes.

Academic Paper or Industry Standard:
IDEF (http://www.idef.com/) - family of ICAM Definition Languages and standard modelling techniques.

Challenges:
1) prepare a flexible and extensible format to save the metadata - ask people's opinion on this issue;
2) handle the lack of feature in the drawing library - patch the library to support the feature or in the last case try another library.

Considerations:
The main goal of this project is to use one tool to do everything you want in a PostgreSQL Database. Of course, it's just an important module of this tool but it'll benefit a lot of developers who use a tool to model and another to handle the DDL and DML.