← Back to Home

Linux Environments & Schema Engineering

Project Overview

This systems infrastructure project showcases initial environment setup configurations, secure shell remote tunneling protocol (ssh) hooks, Linux file-system management routines, and MySQL relational table initializations. The codebase models how to design new database schemas directly from a remote command line workspace.

Technical Tasks Executed

The environment terminal operations are split across separate staging pipelines:

Interactive Command Console Stream

The scrollable window below captures the shell history logs generated while building out folders and populating database constraints:

etnelson — bash — cs1.txwes.edu
(base) EmmaLeighs-MBP:~ emmynelson$ ssh etnelson@cs1.txwes.edu
Enter passphrase for key '/Users/emmynelson/.ssh/id_ed25519':
Last login: Thu Aug 22 18:38:05 2024 from 64.64.64.2

[etnelson@ip-172-31-84-83 ~]$ pwd
/home/etnelson

[etnelson@ip-172-31-84-83 ~]$ mkdir csc4341
[etnelson@ip-172-31-84-83 ~]$ ls
csc4341  public_html

mysql> show databases;
+--------------------+

| Database           |
+--------------------+

| ETNELSON           |
| information_schema |
+--------------------+

mysql> use ETNELSON
Database changed

mysql> create table cellar(
    -> bin_num int (10) NOT NULL,
    -> wine char(20) default NULL,
    -> producer char(20) default NULL,
    -> year int(4) default NULL,
    -> bottles int(4) default NULL,
    -> ready int(4) default NULL,
    -> PRIMARY KEY (bin_num)
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> create table movie(
    -> movie_id int(10) NOT NULL,
    -> title varchar(50),
    -> genre varchar(20),
    -> rating varchar(10),
    -> primary key (movie_id)
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO cellar(BIN_NUM, WINE, PRODUCER, YEAR, BOTTLES, READY)
    -> VALUES (53, 'Pinoit Noir', 'Saintsbury', 1997, 6, 2001);
Query OK, 1 row affected (0.00 sec)

mysql> select * from cellar;
+---------+-------------+------------+------+---------+-------+

| bin_num | wine        | producer   | year | bottles | ready |
+---------+-------------+------------+------+---------+-------+

|      53 | Pinoit Noir | Saintsbury | 1997 |       6 |  2001 |
+---------+-------------+------------+------+---------+-------+

mysql> select * from movie;
+----------+--------------------+------------------+--------+

| movie_id | title              | genre            | rating |
+----------+--------------------+------------------+--------+

|      101 | Sixth Sense, The   | thriller horror  | PG-13  |
|      102 | Back to the Future | comedy adventure | PG     |
+----------+--------------------+------------------+--------+

Environment Architecture Specs