Hey there i need help with this assignment that dues by the 20th ,, it explains every thing in a 28 pictures i also would provide more pictures if needed ,, good luck and thank you. Assignment 1

Hey there i need help with this assignment that dues by the 20th ,, it explains every thing in a 28 pictures i also would provide more pictures if needed ,, good luck and thank you.

Assignment 1 – Install MySql

1. Install Mysql Server .

2. Run the create database script- that is uploaded in Class1 module on Canvas.

3. Upload snapshot of your server information

4. Upload snapshot of database/tables created.

***********************************************************

— *************************************************************

— This script creates all 3 sample databases (AP, EX, and OM)

— for Murach’s MySQL 3rd Edition by Joel Murach

— *************************************************************

— ********************************************

— CREATE THE AP DATABASE

— *******************************************

— create the database

DROP DATABASE IF EXISTS ap;

CREATE DATABASE ap;

— select the database

USE ap;

— create the tables

CREATE TABLE general_ledger_accounts

(

account_number        INT            PRIMARY KEY,

account_description   VARCHAR(50)    UNIQUE

);

voice_due_date    DATE         NOT NULL,

payment_date        DATE

);