IDS Lab Activity 4 - IDS Lab 4 PDF

Preview

Summary

IDS Lab 4...

Description

Army Public College of Management & Sciences Department of Engineering Sciences Lab Activity - Top Sheet Department of Computer Science Class

Student’s UET Registration Number UET-18F-BSCS-08

Section

30 Course Title Intro to Database

A

Semester

4th

Course Code ACS-402

Student's Full Name ABDUL REHMAN

Assign Date: 08-05-20

Submission Deadline: 17-05-20

Course Teacher Name Mr.Noman Farooq

Lab Activity No.

Assignment Details:

SQL Select Statement, Where Clause & Operators 4 Instructions to Student: Please Note: Work presented in an assessment must be your own. Plagiarism is where a student copies work from another source, published or unpublished (including the work of another student) and fails to acknowledge the influence of another’s work or to attribute quotes to the author. Plagiarism is an academic offence and the penalty can be serious. To detect possible plagiarism we may submit your work to the national plagiarism detection facility. This searches the Internet and an extensive database of reference material including other students’ work to identify. I have read the above information and I confirm that this work is my own and that it may be processed and stored in the manner described.

Signature:.................................................................... Date: ...........17-05-20............................................ Please leave sufficient time to meet the given deadline and do not leave the handing-in of assignments to the last minute. You are being allowed meaningfull time for any system problems or other issues.

Army Public College of Management & Sciences Department of Engineering Sciences 1. Import CUSTOMER database (CUSTOMER database for lab activity 4) and Find the "CustomerName" and "City" columns from the "Customer" table.

Army Public College of Management & Sciences Department of Engineering Sciences

Army Public College of Management & Sciences Department of Engineering Sciences 2. Find all the columns from the "Customer" table

3. Find only the distinct values from the "City" columns from the "Customer" table

Army Public College of Management & Sciences Department of Engineering Sciences

4. Find all the customer from the city "New York", in the "Customer" table.

Army Public College of Management & Sciences Department of Engineering Sciences 5. Find all the customer in the customer tables whose CustomerID=1.

6. Find all addresses with an id BETWEEN 15 and 25.

Army Public College of Management & Sciences Department of Engineering Sciences 7. Display the addresses outside the range of 15 and 25, use NOT BETWEEN

8. Practice and Display every given above Syntax in Customer Table

a) BETWEEN Operator with IN

Army Public College of Management & Sciences b)

Department of Engineering Sciences BETWEEN Operator with Text Value

c) NOT BETWEEN Operator with Text Value

Army Public College of Management & Sciences Department of Engineering Sciences

d) BETWEEN Operator with Date Value

THE END...