Useful_URLs

 

http://fabforce.net/dbdesigner4/ - another design tool. 

 

Download site for mysql

http://dev.mysql.com/downloads/

 

SchemaToDoc Enterprises  - Database Documentation and Query Tools

http://adwords.schematodoc.com/   

See Sample MS-SQL document  http://adwords.schematodoc.com/MSSql_Sample1.html

Here are the free downloads  which are limited in scope http://adwords.schematodoc.com/downloads.html

 

Table Designer is no longer shipped with Database Processing, but students and instructors can obtain a 30 day complementary copy of it from www.TableDesigner.com.

 

Here is the link to the free trial version of Erwin  www.ca.com

Click on Trials and Downloads under >>Learn More

Click on AllFusion Erwin Data Modeler and try it. 

 

Here is a link with some information about the relation between Access and SQL Server – leaning to where they differ... It shows what data type migrations occur when converting an Access database to a SQL Server database.  Thanks to Andrew Richter for finding the information.  http://www.databasejournal.com/features/msaccess/article.php/1490561

 

 

www.prenhall.com/kroenke - go to our text “ Database Processing, 10/e Kroenke”  which is the top lefthand image - click on “companion website”  and then select a chapter from the navigation bar above.  There you will find

·        the power point slides which accompany the text – some of which will be used in lectures.

·        glossary

·        a self study guide which has

o       true false questions

o       multiple choice questions

o       essay questions

 

SAP information

 

Open Source DBMS mySQL

http://www.mysql.com.

 

 

Examples of Single-User Database Applications – discussed on pages 5 and 6

 

 

 

 

 

Examples of E-commerce Database Applications – described on page 7

 

 

E-R Data Modeling Tool