CPSC 3220 University of Tennessee Chattanooga File and Database Processing HW Part 1 – Create Your Tables Your first step will be to create a database wit

CPSC 3220 University of Tennessee Chattanooga File and Database Processing HW Part 1 – Create Your Tables

Your first step will be to create a database with a set of tables. You will need to start your SQL Server. (For windows users simply click the Start button from the control panel). (For Linux Users type the command: sudo /opt/lampp/lampp start). At the end of this section of the homework you should have a single file called schema.sql that contains all the scripts needed to create your schema (https://en.wikipedia.org/wiki/Database_schema). Just to be clear there is NO PHP for this part. You will create tables using DBeaver or similar, then paste the proper commands into a script schema.sql.

You will need to create a database to hold your tables. You can right click “Databases” on your connection in DBeaver and select “Create New Database”. Name your database “SuperStore”

You will then right click the new database and “Edit Database” to add tables. The list of tables you need to create is as follows. The Primary Keys are underlined bold, foreign keys are italics.

customer(customer_id, first_name, last_name, email, phone, address_id)

order(order_id, customer_id, address_id)

product(product_id, product_name, description, weight, base_cost)

order_item (order_id, product_id, quantity, price)

address(address_id, street, city, state, zip)

warehouse(warehouse_id, name, address_id)

product_warehouse(product_id, warehouse_id)

Part 2 – Create a PDF Document with Screenshots

Create and submit a PDF document that documents the correctness of your scripts. You should post a picture of your overall ER Diagram (right click your database from the listing on the left side of DBeaver, and select “Edit Database”. From there you can click the “ER Diagram” tab that opens on the right.

You should see something similar to this:

You also need to add pictures of your tables. Right click the table name on the menu to the left, and click edit. Then look at the “Properties” tab.

Here is a sample of what your ER Diagram should look like: Default Extra Comment
aut
Column Name
Columns
te actor_id
Constraints
Foreign Keys jame
References
Triggers
Indeses
# Data Type Not Null Auto Increment key
1 in 11
PRI
2 varchart
3 varchar
100
DOL
order jo
product_id
onderd
come
schwalenple
product rame
product_ware
product ja
area ofor HW4 database
address
Waddesi
—
Properties AER Diagram
actor
actor_id
nastame
lass rsurams|
movie actor
movie_id
actorid
movie
12 movie_id
description
release date
moviestore3
movie_actor
Value
customer movie store schema.
Properties Data de ER Diagram
Name
General
Table Name
Engine
Auto Increment
Charset
Collation
Description
> Statistics
actor
Innen
1
general

Purchase answer to see full
attachment