Database Assignment | Professional Writing Services

Complete the requirements

 

Don't use plagiarized sources. Get Your Custom Essay on
Database Assignment | Professional Writing Services
Just from $13/Page
Order Essay

Advanced Database Management Systems MIS480 – Spring 2020

Weekly Assessment 2 (15%) – Chapter 6

Start Date: 21 May 2020 – 8:00 am

Due Date: 28 May 2020 – 23:59 pm

(Note: please upload your answer on Moodle using Assignment Submission Link

 

  Student Name:

 

Student ID:
1.           

 

 

 

 

Complete the following SQL tasks:

 

 

 

 

  1. Write the SQL statements that would create the below customer relation and SQL to insert the values to the table, assuming that the Customer ID, name, Client address and city cannot be Null. Use proper data types and constraints. (30%)
CustomerID CustomerName ContactName Address City PostalCode Country
1 AlfredsFutterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
2 Ana Trujillo Ana Trujillo Avda. de la Constitución México D.F. 05021 Mexico
3 Antonio Moreno Antonio Moreno Matadoros 2312 México D.F. 05023 Mexico
4 Around the Horn Thomas Hardy 120 Hanover Sq. London WA1 1DP UK
5 Berglundssnabbköp Christina Berglund Berguvsvägen 8 Luleå S-958 22 Sweden

 

 

  1. Write SQL statement that selects all the customers from the country “Mexico”, in the “Customers” table (10 points)
  2. Write SQL statement that selects all customers from the country “Germany” AND the city “Berlin”, in the “Customers” table (10 points)
  3. The following SQL statement selects all customers from the city “Berlin” OR “Mexico”, in the “Customers” table (10 points)
  4. Write SQL statement that selects all customers from the country “Germany” AND the city must be equal to “Berlin” OR “Munchen”, in the “Customers” table (10 points)
  5. Write SQL statement that selects all customers from the “Customers” table, sorted by the “Country” column (10 points)
  6. Write SQL statement that selects all customers from the “Customers” table, sorted DESCENDING by the “Country” column (10 points)
  7. Write SQL statement that selects all customers with a City starting with the letter “s”(10 points)

 

 

 

Place Order
Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Grab A 14% Discount on This Paper

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.