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.
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.
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.
Recent Solved Questions
- LAW60104: Business Law Case Study, TU, Malaysia On 14th February 2023, Peter advertised his BMW car which was actually worth RM80,000 for sale for RM66,000
- ACC 116: Introduction To Cost Accounting Assignment, UiTM, Malaysia Limau Manis Sdn Bhd is a medium-sized company that manufactures a variety of pickles in the northern region of Malaysia
- Strategic Corporate Finance Assignment, HWU, Malaysia An investment business situated in Malaysia has just hired you to be a financial analyst on their investment team
- PBD10202: ENGLISH II Essay, IIUM, Malaysia Steph was looking at Instagram there were blessed yoga photos and Sunday Breakfast pictures
- AMCA5203: Basic statistics and research method Assignment, OUM, Malaysia The Assignment Is Intended To Provide Learners With The Opportunity To Grasp The Understanding Of Basic Concepts Of Statistics
- Physics Assignment, UOW, Malaysia When a capacitor is charged through a resistor by a constant voltage source, the voltages across the capacitor
- BMG323: Based on the distribution, compute (by formula) the average and standard deviation for: Business analytics Assignment, WOU, Malaysia
- MGT7101: MANAGING OPERATIONS OF BUSINESS Assignment, UPM, Malaysia Examine the issues and trends in operations management and how that in turn affects an organisations SIPOC
- BMK309: International Marketing Assignment, WOU, Malaysia Songket, a traditional handwoven fabric, is intricate and exquisite, with vibrant colors and beautiful patterns
- AC4012: Introduction to Financial Accounting Report, SC, Malaysia You are required to choose TWO listed companies from Bursa Malaysia with the annual report from 2014 onwards
