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.
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.
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.
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.
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.
Recent Solved Questions
- PBS3233: International Business Assignment, KPTM, Malaysia The economic system in the world refers to the way in which countries organize their economies to allocate
- HRM70304 Managing People for Performance Assessment-01 (20%) (Continuous) September 2025
- HRM4221E Contemporary Employment Relations Individual Assignment – August 2025
- CMA6134 Queue Simulation Assignment: petrol station brand Case Study for Peak vs Non-Peak Traffic Management
- Accounting and Finance Assignment, UUM, Malaysia Great Excel Traders has a branch at Kota Tinggi. All accounts are maintained at the Head Office in Johor Bahru
- Family Business Report, TU, Malaysia Describe the values, culture, and identity of your family. Critically discuss the differences in values, culture
- FIN30014: Financial Risk Management Case Study, SUT, Malaysia Identify ONE financial risk faced by Alphabet Inc given the above scenario Systematically review and critically evaluate research from a variety
- Chemical Process Engineering Assignment, UTM, Malaysia Choose one Mo from the given range, draw a process flow diagram of the system and determine the composition
- FIN 358: Investment Management Assignment, UiTM, Malaysia Common stock and preferred stock differ significantly in several ways. Most holders of preferred stock
- MPIS7103 Final Examination City University Malaysia : Management Information Systems
