Preview

Assignment 1

Satisfactory Essays
Open Document
Open Document
535 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Assignment 1
Assignment 1

8. Result of Restrict Operation that lists orders in Feb 2013.
OrdNo
OrdDate
CustNo
EmpNo

O1656777
02/11/2013
C8543321

O7959898
02/19/2013
C8543321
E8544399

9. Result of restrict operation that lists the customers residing in Seattle, WA.
CustNo
CustFirstName
CustLastName
CustCity
CustState
CustZip
CustBal

C2388597
Beth
Taylor
Seattle
WA
98103-1121
$500.00
C3340959
Betty
Wise
Seattle
WA
98178-3311
$200.00

11. Result of Project operation that lists the custcity and custstate columns of the customer table.
CustCity
CustState

Littleton
CO
Denver
CO
Seattle
WA
Monroe
WA
Renton
WA

14. Result of Natural Join of Employee and Order Tbl tables.
EmpNo
EmpFirstName
EmpLastName
EmpPhone
EmpEmail
OrdNo
OrdDate

E1329594
Landi
Santos
(303) 789-1234
LSantos@bigco.com
O2334661
01/14/2013
E8544399
Joe
Jenkins
(303) 221-9875
JJenkins@bigco.com
O1116324
01/23/2013
E9345771
Colin
White
(303) 221-4453
CWhite@bigco.com
O7989497
01/16/2013
E9884325
Thomas
Johnson
(303) 556-9987
TJohnson@bigco.com
O2233457
01/12/2013
E1329594
Landi
Santos
(303) 789-1234
LSantos@bigco.com
O4714645
01/11/2013
E9884325
Thomas
Johnson
(303) 556-9987
TJohnson@bigco.com
O5511365
01/22/2013
E8544399
Joe
Jenkins
(303) 221-9875
JJenkins@bigco.com
O7959898
02/19/2013

15. Result of one-sided outer join between the employee and order Tbl tables. Preserve the rows of the order Tbl table in the result.

OrdNo
OrdDate
CustNo
EmpNo
EmpFirstName
EmpLastName
EmpPhone
EmpEmail

O1116324
01/23/2013
C0954327
E8544399
Joe
Jenkins
(303) 221-9875
JJenkins@bigco.com
O2334661
01/14/2013
C0954327
E1329594
Landi
Santos
(303) 789-1234
LSantos@bigco.com
O3331222
01/13/2013
C1010398

O2233457
01/12/2013
C2388597
E9884325
Thomas
Johnson
(303) 556-9987
TJohnson@bigco.com
O4714645
01/11/2013
C2388597
E1329594
Landi
Santos
(303) 789-1234
LSantos@bigco.com
O5511365
01/22/2013
C3340959
E9884325
Thomas
Johnson
(303) 556-9987
TJohnson@bigco.com
O7989497
01/16/2013
C3499503
E9345771
Colin
White
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    DBM380 Week 2
    • 837 Words
    • 3 Pages

    DBM380 Week 2

    There will be seven tables in this database source system order data, customer data, corrections table data, drop ship corrections, workflow status, end system data, and comparison results table. The source system table will be comprised of columns for customer purchase order number, customer name, transmitted date, and status. The customer table will consist of columns for customer name and customer number. Corrections table will provide columns for customer purchase order number, system reference data, date received and error message. Drop ship table…

    • 837 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Nt1330 Unit 4
    • 1142 Words
    • 5 Pages

    Nt1330 Unit 4

    4. Lynn is adding a billing table to a customer database. If she wants the database to retrieve…

    • 1142 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Dbm380 Wk2
    • 772 Words
    • 3 Pages

    Dbm380 Wk2

    There will be seven tables in this database source system customer data, order data, corrections table data, comparison results table, drop ship corrections, end system data, and workflow status. The source system table will be comprised of columns for customer name, customer purchase order number, status, and transmitted date. The customer table will comprise of columns for customer name and customer number. Corrections table will offer columns for customer purchase order number, system reference data, date received and error message. Drop ship table will consist of customer…

    • 772 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Devry Acct 244 Lab1 Questions
    • 314 Words
    • 2 Pages

    Devry Acct 244 Lab1 Questions

    The Orders table is related to the Customers, Shippers, Orders Status, Orders Tax Status, Order Details, Invoices, Inventory Transactions, and Employees tables.…

    • 314 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Comparison Proposal: Hopkins County Madisonville Public Library
    • 1038 Words
    • 5 Pages

    Comparison Proposal: Hopkins County Madisonville Public Library

    “We make available ideas and information to all and we strengthen our community by promoting individual and lifelong learning.”\…

    • 1038 Words
    • 5 Pages
    Better Essays
    Read More
  • Good Essays

    Assignment 1
    • 872 Words
    • 4 Pages

    Assignment 1

    The IP addresses defined in a DHCP scope must be contiguous and are associated with a subnet mask. If the addresses you want to assign are not contiguous, you must create a scope encompassing all the addresses you want to assign and then exclude specific addresses or address ranges from the scope. So just be sure to check how you have your DHCP…

    • 872 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Rfp Inventory Control
    • 5649 Words
    • 23 Pages

    Rfp Inventory Control

    The following section entails information that Just Seeds Unlimited Co. requires of bidders when preparing the response bid proposal:…

    • 5649 Words
    • 23 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Assignment 1
    • 1774 Words
    • 19 Pages

    Assignment 1

    5. Use easily understandable language to demonstrate an understanding of the materials. Apply the knowledge developed to a similar context [(f) Communicate and Apply Unit 5]…

    • 1774 Words
    • 19 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Assignment 1
    • 330 Words
    • 2 Pages

    Assignment 1

    Since the consumption of these more excellent goods is an evidence of wealth, it becomes honorific; and conversely, the failure to consume in due quantity and quality becomes a mark of inferiority and demerit (p3).…

    • 330 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Assignment 1
    • 6548 Words
    • 27 Pages

    Assignment 1

    You will notice that you need to look in different course books for some of the information and not all unit evidence correspond to the matching unit number…

    • 6548 Words
    • 27 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Assignment 1

    • 352 Words
    • 3 Pages

    Assignment 1

    2. Use the table below to describe some of the different types and styles of documents that are produced in a business environment, and then explain when these different options may be used.…

    • 352 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Manage Budgets and Financial Plans Case Study
    • 507 Words
    • 3 Pages

    Manage Budgets and Financial Plans Case Study

    | Invoice Date: 11-05-2011Invoice #: 0548392Customer ID: 561Ship to:Name: Farrington CompanyAddress: 333 wellinton streetPhone: 5964832222E-mail: Farrington@company.com…

    • 507 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    assignment 1
    • 1442 Words
    • 6 Pages

    assignment 1

    1. Describe two examples of important things that financial planning skills can help you do, and explain why these things are important to you personally. (4-6 sentences. 2.0 points)…

    • 1442 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Spyder Active Sports
    • 486 Words
    • 8 Pages

    Spyder Active Sports

    Advertisement, brand marketing, competition, brand value, scope of expansion, goodwill, supply channel the product portfolio.…

    • 486 Words
    • 8 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    List of Banks in Tarlac
    • 1296 Words
    • 6 Pages

    List of Banks in Tarlac

    RB of Sta. Rosa de Lima, Inc. Address: #7 Burgos st., Pob. Sur, Paniqui, Tarlac Chairman: Orlando F. Cervantes President: Orlando F. Cervantes Manager: Orlando F. Cervantes Tel.…

    • 1296 Words
    • 6 Pages
    Satisfactory Essays
    Read More

Related Topics