Write SQL queries to answer the following questions. Use the information given in each table: Database Assignment, IIU, Malaysia

University INTI International University (IIU)
Subject Database Assignment

1. Write SQL queries to answer the following questions. Use the information given in each table.

Database Assignment
a) List the customer details who has a balance of more than 300.

b) List the customer’s name, area code, and invoice number of all customers. Sort the answer in descending order by customer name.

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

C) List the male customer details whose name starts with the letter

d) Find the number of male customers and display the column name as ‘Total

e) Find the minimum, maximum, average, and number of customers for each area code.

f) Change the balance for Siti to 500.

g) Find the name of a customer who lives in the same area as Diana.

2. Consider the structure of the following PRODUCT table.

a) Write the SQL command to create a new table called PRODUCT based on the information given in Table 1 below.
Database Assignment

b) Change the field length of the description to VARCHAR(30) in the PRODUCT table.

c) Add a price column in between description and code in the PRODUCT table. This column only allows floating number data to be entered with a maximum precision of 3 digits and a scale of 2 digits.

d) Rename column description to in the PRODUCT table. This column only
allows variable character data to be entered with a maximum of 30 characters.

Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services.

Get Help By Expert

Need help with your Data Assignment in Malaysia? Look to our assignment helper Malaysia service, where Malaysian students can conveniently pay someone to do my assignment and receive personalized support. Our team of experts is adept at handling various data-related tasks, including analysis, modelling, and programming.

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

70841+ Orders Delivered

4.9/5
5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

AAR451 Construction Technology I UITM Assignment Samples, Malaysia
AAR451 Construction Technology I at UiTM, Malaysia offers an introductory overview of the construction industry. We are here to provide the assignment solution for this course, allowing you to gain…
Engineering
ASC713 Finance And Risk Modelling UITM  Assignment Answer Malaysia
The ASC713 Finance and Risk Modelling course at UITM in Malaysia provides students with an understanding of how to evaluate and manage financial risks in today's global markets. The course…
Finance

UP TO 15 % DISCOUNT

Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now