File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree Original file line number Diff line number Diff line change 1+ # java-sql
2+
3+ A student that completes this project shows that they can:
4+ * Query data from a single table
5+ * Query data from multiple tables
6+ * Create a new datadaase using PostgreSQL
7+
18# Introduction
29
310Working with SQL
@@ -57,7 +64,7 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
5764
5865### Keep track of the code you write and paste at the end of this document
5966
60- - use [ ` SQLite Studio ` ] ( https://sqlitestudio.pl/index.rvt ) to create a database, name it ` budget.sqlite3 ` .
67+ - use pgAdmin to create a database, naming it ` budget ` .
6168- add an ` accounts ` table with the following _ schema_ :
6269
6370 - ` id ` , numeric value with no decimal places that should autoincrement.
@@ -68,4 +75,3 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
6875 - the ` id ` should be the primary key for the table.
6976 - account ` name ` should be unique.
7077 - account ` budget ` is required.
71- > This can be done with the CREATE TABLE clause
You can’t perform that action at this time.
0 commit comments