| Site: http://www.aisintl.com |
| Entity-Relationship Diagram. A tutorial to display the different relationships among entities and the types of entity relationship diagrams |
| Site: http://www.umsl.edu/~sauter/analysis/dfd/DiagrammingMethods.html |
| Systems Analysis Web Sites: CASE Tools – Comparison of Diagramming Methods.
This web site compares the various diagramming methods available to designers. There is information available on methodologies and diagramming principles, based on the tools available to the designer. The web site gives specific information with regards to CASE tools on Bachman’s crow-footed notation, as well as details about Chen’s method for constructing ERDs. There is also information about ethics and systems analysis, feasibility analysis, requirements, estimation, project management, and much, much more. This is an excellent site to visit for anyone planning to undertake a serious project. |
| Site: http://www.davidbass.com/technical_resources/database_schema.shtml |
| Data Models and Database Schemas-ERD-Entity Relationship
Diagram. I liked the website. David Bass demonstrates Data Models and Schemas. He also shows an Entity Relationship Diagram an the SQL code for the diagram. |
| Site: http://www.ececs.uc.edu/~kcd/research/trans-e |
| Mapping ERDS to Relations. The site lists the steps on how to transform ERDS to Relations plus it has a view links with information pertaining to SQL. |
| Site: http://www.ececs.uc.edu/~kcd/research/trans-ed-paper/node2.html |
| Conceptual Design: ERD to SQL Generation. The website has navigational links into different topics such as ERDs and how to implement into a relational database model. The website covers the topic of the Entity-Relationship model and how to capture the
requirements to translate it into a relational database. It illustrates the process necessary to turn the relationships into an implementation model.. the website is easy to
navigate through since it’s a short tutorial with two links. Although it is short the topics are nicely illustrated. |
| Site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=5917 |
| SQL Server Magazine: This is the site of a magazine which has a variety of links related to different topics of interest to people who deal with sql servers and other products. In the main article for this day called SQL By Design: Views and Stored Procedures explain how can you retrieve useful information from fragmented tables among other things. Also, it explained what a view was and how to formulate the views. It seems like an interesting source of current topics in SQL. |
| Site: http://www.frick-cpa.com/ss7/Theory_ERD.asp#Relationships |
Entity-Relationship Diagram (ERD). This web page contains an
Overview:
1.Definition and Use
2.Tables
3.Relationships
4.ERD for 'Pubs' Database
5.ERD for 'Northwind' Database |
| Site: http://mini.net/sax/post/822401.txt |
| CASE Studio 2 - A professional database design tool. Ever want to create ERD's with ease? The CASE Studio 2 is a design tool that includes ERD diagrams for various DBMS (Oracle, DB2, MS SQL, MySQL, InterBase, and Sybase). The tool includes individual database options such as referential integrity, constraints, domains, triggers and user permissions. I have yet to use CASE Studio 2 and apply it to creating a useful ERD. |
| Site: http://www.umsl.edu/~sauter/analysis/er/er_intro.html |
| Entity-Relationship Diagrams (ERD). It is pretty interesting to get another professor's take on entity relationship diagrams. This website is a nice reference to come back to. |
| Site: http://www.informit.com/ |
| IT articles, books, and other information. This website contains articles and books you can reference from when developing databases. |
| Site: http://remus.rutgers.edu/~roni/cs336/translate.html |
| Converting E-R diagram to Relational Model. The following site was taken form the following source: [1] Date, C. J., An Introduction to Database Systems chap 12, Sixth Edition, 1995. It explains how the E-R model is a graphical representation of the database and needs to be translated to the relational equivalent. This site states that this mapping is done by using the E-R translation rules listed in
Elmasri/Navathe.[1] It goes on to list the first six rules related to the E-R model and then states that Rule #7 has been added for sub/super types. |
| Site: http://www.sqlteam.com/item.asp?ItemID=122 |
| Article covering ERD, normalization, SQL, cardinality. This article contains information on ERDs, normalization, data modeling, cardinality. Also has links for many articles, especially on SQL queries on the right hand side of the page. |
| Site: http://www.microsoft.com/office/visio/downloads/default.asp |
| Microsoft Visio Website. Visio is a useful and fast tool for making ERD's. Student pricing available. |
| Site: http://www.casestudio.com/enu/ |
CASE Studio 2 v. 2.9 is designed to visually create and maintain ER diagrams for numerous databases. It is an ideal choice for companies and developers who want to work with their own databases in the most comfortable way. ","Great site. Has FREE download of case studio version2.9 for ERD development.Has these Latest enhancements
Sybase ASE 12.5 full support
Reverse engineering for Sybase ASE 12.5
Support of compound foreign keys!
Enhanced RE for MS SQL 2000
HTML reports with CSS styles
Export into XML
To-Do list maintenance
One Instance Only support
Better versionning
|
