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
);
