CIS4365: Database Applications
Fall, 2017


UTEP Oracle 9i
UTEP Oracle 10g Notes

Pseudonym: barohi
Website: http://www.tonbeller.com
Title: http://www.tonbeller.com/Temporaere%20Zeidon_Readme/zeidon/html/Glossary/html/associative_entity.html
Submitter:
Date: 10/02/03
Time: 10:50:46 AM

Comments

It has got some interesting stuff on Databases

Pseudonym: aceone
Website: http://www.keele.ac.uk/depts/cs/Staff/Homes/Mdb3/courses/SD2000/Tpapers/dbdes.pdf
Title: Converting ERD models to Relational Design
Submitter:
Date: 11/05/03
Time: 03:33:19 PM

Comments

This sites gives you an idea of the process to convert an ERD into a RDBMS.

Pseudonym: javes
Website: http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter2/node1.html
Title: Tutorial / Overview of ERD Technique
Submitter:
Date: 11/07/03
Time: 03:41:05 PM

Comments

I found this site helpful on the concepts about ERD techniques and can be used as a course manual for database design.

Pseudonym: navi
Website: http://www-db.in.tum.de/~grust/teaching/ss07/DBfA/db1-03.pdf
Title: The Entity-Relationship Model
Submitter:
Date: 09/16/07
Time: 09:43:55 PM

Comments

Includes basic concepts and examples. Objectives of website paper: "After completing this chapter, you should be able to . explain the three phases of database design, Why are multiple phases useful? . evaluate the significance of the Entity-Relationship Model (ER model) for DB design, . enumerate the basic constructs of the ER model, . develop ER diagrams (schemas in the ER model) for a given application, . translate ER models into equivalent (as far as possible) relational models."

Pseudonym: larn
Website: http://www.brainbell.com/tutors/php/php_mysql/Converting_an_Entity_Relationship_Model_to_SQL.html
Title: Converting an Entity-Relationship Model to SQL
Submitter: A short step by step tutorial showing the procedure necessary to convert an Entity Relationship Diagram to SQL statements.
Date: 09/17/07
Time: 04:42:45 PM

Comments

A short step by step toutorial

Pseudonym: certs
Website: http://databases.about.com/od/sql/a/tables.htm
Title: Creating Databases and Tables In SQL
Submitter:
Date: 10/29/07
Time: 05:52:58 PM

Comments

This web site gives a sample ERD and gives the SQL code in creating the tables for the database. This gives a step by step approach on creating the database, tables, and modifying them. This is a good quick reference guide.

Pseudonym: mona
Website: http://resources.visual-paradigm.com/vpsuite2.2sp2/generate_sql.html
Title: DB Visual ARCHITECT (DB-VA) provides the Generate SQL function on the Entity Relationship Diagram (ERD).
Submitter:
Date: 11/05/07
Time: 11:52:21 AM

Comments

This site provides informationa bout how to create an sql from a ERD. Helpful in creating entities and relationships and thier descriptions.

Pseudonym: jhony
Website: http://db.grussell.org/section004.html
Title: converting ERD to RDBMS
Submitter:
Date: 11/08/07
Time: 06:27:43 PM

Comments

explains the step by step procedure for developing an ERD and converting it to RDBMS

Pseudonym: gally
Website: http://ocw.mit.edu/NR/rdonlyres/Urban-Studies-and-Planning/11-521Spatial-Database-Management-and-Advanced-Geographic-Information-SystemsSpring2003/FAD02140-58F2-49A4-B011-465BFC905993/0/lect9.pdf
Title: Database Design--from E-R Diagram to SQL Statement
Submitter:
Date: 11/22/07
Time: 08:47:39 PM

Comments

This is a paper explaining steps involved in database design from ERD to SQL

Pseudonym: ultimatum
Website: http://www.projectschool.com/psmain/handleProjects.php?rand=oZiRm5adkoSozpvEmdOlX57Q5NU=
Title: RDBMS: Design, Implementation and Management SQLServer
Submitter:
Date: 12/03/07
Time: 01:15:44 PM

Comments

The site provide all the inormation needed for the database undersatanding and managemnent

Pseudonym: ultimatum
Website: http://www.projectschool.com/psmain/handleProjects.php?rand=oZiRm5adkoSozpvEmdOlX57Q5NU=
Title: RDBMS: Design, Implementation and Management SQLServer
Submitter:
Date: 12/03/07
Time: 01:15:53 PM

Comments

The site provide all the inormation needed for the database undersatanding and managemnent

Pseudonym: Raver
Website: http://web.mit.edu/11.521/www/lectures/lecture9/lecture9.html
Title: Database Design--from E-R Diagram to SQL Statement
Submitter:
Date: 12/07/07
Time: 10:36:26 AM

Comments

Very good lecture where one can see how to translate the information from an ERD to SQL Statements.

Pseudonym: flyhigh1883
Website: http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter2/node4.html
Title: ERD to Relational Database Model.
Submitter:
Date: 12/07/07
Time: 06:49:42 PM

Comments

This is a useful web site that gives information on how to to formulate Relational Data Model from ERDs(Transforming ERD to tables).Furthur, it gives information on various important terms in database design process.

Pseudonym: asdfghjkl
Website: http://web.mit.edu/11.521/www/lectures/lecture9/lecture9.html
Title: database design erd to sql
Submitter: Dedeepya Vaka
Date: 12/07/07
Time: 10:26:24 PM

Comments

This site has all information about how to create tables from the erd

Pseudonym: Del Sol
Website: http://resource.visual-paradigm.com/vpsuite2.2sp2/generate_sql.html
Title: Generating SQl Statements
Submitter:
Date: 04/20/09
Time: 10:13:27 PM

Comments

Valuable Resource,print screens, and links to other websites

Pseudonym: Quato
Website: http://www.adp-gmbh.ch/perl/erd.html
Title: Creating an ERD out of SQL create table statements
Submitter:
Date: 04/22/09
Time: 11:02:34 AM

Comments

This link provides an example of an ERD from table statements.

Pseudonym: Strider
Website: http://www.scribd.com/doc/4155399/RdbmsEltp
Title: RDBMS ELTP
Submitter:
Date: 05/04/09
Time: 11:37:35 AM

Comments

Here is an online power point about the relationship between RDBMS and ERD's.

Pseudonym: waitingplace
Website: http://web.sxu.edu/rogers/sys/er.html
Title: An entity-relationship diagram is a graphical depiction of organizational system elements and the association among the elements. E-R diagrams can help define system boundaries. The elements that make up a system are referred to as entities.
Submitter: Marian Ali
Date: 05/15/09
Time: 09:29:03 AM

Comments

This gives a basic example of Entity Relationship Diagrams

Pseudonym: aab05
Website: http://ocw.mit.edu/NR/rdonlyres/Urban-Studies-and-Planning/11-521Spatial-Database-Management-and-Advanced-Geographic-Information-SystemsSpring2003/FAD02140-58F2-49A4-B011-465BFC905993/0/lect9.pdf
Title: ERD to SQL
Submitter:
Date: 11/17/09
Time: 09:29:08 AM

Comments

it provides a good quide about the creation from ERD to SQL

Pseudonym: dyah
Website: http://www.idready.org/webcast/materials/spr07/relational_database/2006-12-01/RDBMS.ERDiagrams.pdf
Title: summary of ERD
Submitter:
Date: 11/19/09
Time: 09:58:09 AM

Comments

Steps for Constructing an E-R Diagram and examples

Pseudonym: Maranon2
Website: http://www.youtube.com/watch?v=1BYt3wmkgXE
Title: Visio ERD to SQL Tutorial YouTube Video
Submitter:
Date: 11/19/09
Time: 10:16:20 AM

Comments

This is a great video about using Visio to create an ERD and then "push" the changes to SQL. Their words not mine. I thought this was interesting because I used Visio for my Systems class.

Pseudonym: Viper2111
Website: http://www.sharewareconnection.com
Title: Software Listing: Entity Relationship Diagram
Submitter: -
Date: 11/19/09
Time: 10:47:40 AM

Comments

Website has a lot of general information about the relationship of ERD's to Structured Query Language. The users that implement ERDs to SQL commands will find very effective information.

Pseudonym: cobalt1130
Website: http://www.umsl.edu/~sauterv/analysis/dfd/DiagrammingMethods.html
Title: Comparison of Diagramming Methods
Submitter:
Date: 11/24/09
Time: 09:42:27 AM

Comments

This is a decent website that goes into great detail of what the differences and how many kind of charts and diagrams are available to use.

Pseudonym: jack daniels
Website: http://resource.visual-paradigm.com/vpsuite2.2sp2/generate_sql.html
Title: Generate SQL
Submitter:
Date: 10/26/10
Time: 06:53:57 PM

Comments

This site shows you how you can create an SQL from an ERD and the tools that you can use to help you accomplish the process.

Pseudonym: jack daniels
Website: http://resource.visual-paradigm.com/vpsuite2.2sp2/generate_sql.html
Title: Generate SQL
Submitter: Joseph Garza
Date: 10/26/10
Time: 06:54:21 PM

Comments

This site shows you how you can create an SQL from an ERD and the tools that you can use to help you accomplish the process.

Pseudonym: IlmcSNuYRPSY
Website: http://svcvaknrbeuh.com/
Title: uyUBvXVgfJmaNOnpIg
Submitter: qyrxgyFLddG
Date: 11/01/10
Time: 11:12:47 AM

Comments

pyLoE9 <a href="http://lilozlnpnilw.com/">lilozlnpnilw</a>, [url=http://pgckdflwdevt.com/]pgckdflwdevt[/url [link=http://qeqzopzjktge.com/]qeqzopzjktge[/link http://gvseyjezlvxe.com/

Pseudonym: Dalastdon32
Website: http://www.phlonx.com/resources/nf3/
Title: ERD to RDBMS
Submitter:
Date: 11/18/10
Time: 10:11:23 PM

Comments

This article explains how ERD's are used and are essential for RDBMS.

Pseudonym: rae
Website: www.idready.org/webcast/materials/.../RDBMS.ERDiagrams.
Title: Elements of Data
Submitter:
Date: 11/22/10
Time: 06:31:15 PM

Comments

Shows the elements of data and the relationships between them.

Pseudonym: viggo010
Website: http://www-db.in.tum.de/~grust/teaching/ss06/DBfA/db1-04.pdf
Title: The Entuty Relationship Model
Submitter:
Date: 11/23/11
Time: 10:51:30 AM

Comments

well explained and supported with pictures to have a better appreciation

Pseudonym: lYimByHZwb
Website: http://www.facebook.com/profile.php?id=100003405723254
Title: HcrkYmZascrIPSuRj
Submitter: jrvtKPqskrcVIy
Date: 04/05/12
Time: 04:42:22 PM

Comments

, Hey, I know that guy and he's a patriot! No need to look frhtuer. What a great move that was (pun intended). Jeff and Paul showed up right at 9am and we worked them into the ground for the next 13 hours. I loved the option of having us help and provide our own helpers to speed things up and keep the cost down. Jeff was all about getting us moved as fast as possible and taking great care of all our stuff. It took a bit longer than any of us anticipated and despite the chaos that comes with moving your whole life after 12 years we had a great time! jIt's not often you can say you had a great time with your moving guys and never once had to question what they were doing or how they went about getting our stuff in or out of the van. They are pros and really do a great job of giving helpful direction to rookies. We hired my friend's 21 year old son and his friend to help out and with awesome direction from Jeff and Paul the move went off without a hitch.We would recommend Jeff and the We Move It team to anyone for any size project. The bill was more than fair and we could not have done it without them. I was shocked that having the aid of a mover was that inexpensive. We have rented the U-Haul and had friends help in prior moves and that always turns into a total zoo and it costs way more than you anticipate. Having professionals at the helm to guide our weary crew into the wee hours of the night was invaluable. P.S. It was so much fun we all went to dinner afterward just to celebrate our extreme exhaustion! Call Jeff and skip the do-it-yourself disaster in the making. You'll be glad you did