INFO222 - DB SYSTEMS

These sites have good articles on database design, and you may find them useful.

https://www.datanamic.com/support/lt-dez005-introduction-db-modeling.html

Some online free ER Diagram Tools:

• dbdiagram.io: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#dbdiagramio
• draw.io: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#drawio
• Lucidchart: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#lucidchart
• SQLDBM: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#sqldbm
• QuickDBD: https://www.holistics.io/blog/top-5-free-database-diagram-design-tools/#quickdbd

These sites have good articles on using SQLite, and you may find them useful.

• https://www.sqlitetutorial.net/what-is-sqlite/
• Commands:  https://www.sqlitetutorial.net/sqlite-commands/
• Download and Install: https://www.sqlitetutorial.net/download-install-sqlite/
• Sample Database: https://www.sqlitetutorial.net/sqlite-sample-database/
• Tutorial: https://www.sqlitetutorial.net
• DbSchema:  https://dbschema.com/categories/SQLite/

Useful applications

•   DB Browser for SQLite (DB4S)  : https://sqlitebrowser.org

Videos:

• Creating Tables using DB Browser:  https://www.youtube.com/watch?v=Kr2w-sEcpLw
• Creator who has a few videos on SQLite:  https://www.youtube.com/@codingunderpressure7818

These sites have good articles on basic entity relationship modeling and you may find it useful.

• https://www.guru99.com/er-diagram-tutorial-dbms.html
• https://beginnersbook.com/2015/04/e-r-model-in-dbms/
• https://www.tutorialspoint.com/dbms/er_model_basic_concepts.htm

These items can help explain how to convert your ER Diagram into a database schema:

• https://www.learndb.com/databases/how-to-convert-er-diagram-to-relational-database
• http://www.opentextbooks.org.hk/ditatopic/25280

Data Definition Language

• https://docs.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-2017
• https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Transact-SQL%20Data%20Definition%20Language%20-%20DDL-%20Reference.pdf

Data Manipulation Language

• https://codingsight.com/tutorial-on-sql-ddl-dml-on-the-example-of-ms-sql-server-dialect/
• https://ramkedem.com/en/sql-server-dml/

I found this site that explains how to run this application on an Apple computer.:

• https://database.guide/how-to-install-sql-server-on-a-mac/
  

Pivot / Crosstab Queries

• https://www.youtube.com/watch?v=RWfuT1_p4Cw

Online SQL Editors

•  Create a new SQL program - myCompiler: https://www.mycompiler.io/new/sql
  Online 
• SQL Editor - Online SQL Scripting - Practice SQL Online (jdoodle.com): https://www.jdoodle.com/execute-sql-online/
• SQL Editor (sqltutorial.org): https://www.sqltutorial.org/seeit/ 

Download SQL Server Management Studio

• https://aka.ms/ssmsfullsetup

 These two sites have good videos on database administration that you may find it useful.

• Video: https://www.youtube.com/watch?v=rPfncf8W1MA

• Video: https://channel9.msdn.com/Series/dbfundamentals/05

If you are struggling with APA formatting of references and how to cite sources you can take a look at this site for some assistance.

• https://apastyle.apa.org/

This site talks about references lists:

• https://blog.apastyle.org/apastyle/2011/02/whats-a-reference-list-for.html

Here are some additional resources for those trying to understand transaction management. Try looking at these sites which gives some good information on transaction management:

• https://www.guru99.com/dbms-transaction-management.html

• https://www.tutorialspoint.com/dbms/dbms_transaction.htm

• https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm