Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

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

);

Show more
  • @
  • 4 orders completed
ANSWER

Tutor has posted answer for $35.00. See answer's preview

$35.00

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

Click here to download attached files: SQL3.PNG
Click here to download attached files: SQL1.PNG
Click here to download attached files: SQL2.PNG
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question