It/264 Appendix W

 It264 Appendix B Essay

Axia College Materials

Appendix N

SQL Development Assignment Sheet

School: IT/264

Day: May 12-15, 2011

Assignment title: Full Scenario, Component 1

Requirements:

Create a database for Aequitas Hardware Supply that will take care of customers, purchases, and products on hand.

Solution summary:

Used SQL programming and CREATE TABLE command to develop the dining tables titled Customer, Item, Buy, and Order-Item. Identified the principal Key for each and every table make the necessary CERTAINLY NOT NULL qualities.

SQL resource:

The SQL resource here.

MAKE TABLE CUSTOMER

(CUSTOMER_NUM CHAR(5) PRIMARY ESSENTIAL,

LAST_NAME CHAR(15) NOT NULL,

FIRST_NAME CHAR(15) NOT NULL,

ADDRESS CHAR(15),

CITY CHAR(15),

STATE CHAR(2),

ZIP CHAR(5),

PHONE CHAR(10),

FAX CHAR(10),

EMAIL(30) );

CREATE DESK ITEM

(ITEM_NUM CHAR(5) MAJOR KEY,

EXPLANATION CHAR(30) CERTAINLY NOT NULL,

VOLUME CHAR(3),

PRODUCT COST DECIMAL(4, 2),

REGULAR PRICE DECIMAL(4, 2),

MARKETING PRICE DECIMAL(4, 2) );

CREATE STAND ORDER

(ORDER_NUM CHAR(5) MAIN KEY

CLIENT NUMBER CHAR(5) NOT NULL,

SALES PERSON NAME CHAR(15) CERTAINLY NOT NULL,

DUTY AMOUNT DECIMAL(4, 2, ),

TOTAL SUM DECIMAL(4, 2),

SHIPPING TECHNIQUE CHAR(15), );

CREATE DESK ORDER ITEM

(ORDER ITEM_NUMBER CHAR(5) MAJOR KEY,

PURCHASE NUMER CHAR(5) NOT NULL,

ITEM INFORMATION CHAR(15) CERTAINLY NOT NULL,

PRICE DECIMAL(4, 2),

QUANTITY CHAR(5), );

End result results:

Range from the output here, which is usually in table form.

BUYER

CUSTOMER NUMBERLAST NAMEFIRST NAMEADDRESSCITYSTATEZIP CODEPHONE FAX EMAIL

ITEM

ITEM NUMBERDESCRIPTIONQUANTITY ON HANDUNIT COSTREGULAR PRICEPROMOTIONAL PRICE

BUY

ORDER NUMBERCUSTOMER NUMBERSALESPERSON NAMETAX AMOUNTTOTAL AMOUNTSHIPPING METHOD

ORDER-ITEM

ORDER ITEM NUMBERORDER NUMBERITEM NUMBERPRICEQUANTITY

Assessment:

Include a information of the assessment here.

Share:

Related

 Lord from the Flies Composition 09.08.2019

Lord from the Flies Composition

п»їEnglish 10H Mrs. Lev 1 March, 2013 Lord of the Lures Essay In William Golding's Lord in the Flies there are two main character that…...

Read →
 Essay on Carrefour’s Failing 09.08.2019

Essay on Carrefour’s Failing

810 09.08.2019

Carrefour's Failure

Review 1: Group work First Presentation Business chosen: CARREFOUR's Failure in Japan The presentation begins with sharing with the visitors what her team will probably be discussing through…...

Read →
 Hate Article 09.08.2019

Hate Article

989 09.08.2019

Hate

Genoice that can be found almost everywhere in the world that truly no one is secure from. 1988, the Rwandan Patriotic Entrance (RPF) started in Kampala, Uganda as being a…...

Read →
 Thank You for Cigarette smoking Essay 09.08.2019

Thank You for Cigarette smoking Essay

557 09.08.2019

Thank You for Smoking

Thank you for cigarette smoking „Thank You for Smoking" is a politics satire film by Jerr Reitman. The film is usually adapted coming from a novel by Christopher Buckley.…...

Read →
 ACC 291 Week a few Discussion Concerns and Responses Essay 09.08.2019

ACC 291 Week a few Discussion Concerns and Responses Essay

п»їACC 291 Week 3 Dialogue Questions and Responses www.paperscholar.com DIRECT HYPERLINK TO THIS EXAMINE GUIDE: http://www.paperscholar.com/acc-291-week-3-discussion-questions-and-responses/ Instantly Down load! Get Better Grades in Less Time! completely…...

Read →