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
- DGM40102: Plant Maintenance Report, PM, Malaysia Apply the fundamentals of plant maintenance knowledge in related industries. Perform the plant maintenance working flow
- Master of Renewable Energy Assignment, UM, Malaysia Malaysia has used renewable energy technology such as biomass, solar and hydro energy for power generation
- SBFS1103: Thinking Skills and Problem-Solving Assignment, OUM, Malaysia In the 21st century, it has become essential for companies to be digitally literate in a challenging business environment
- SMP10803: Principles of Marketing Assignment, UMP, Malaysia You are planning to venture into one of the agribusinesses in the area in which you live Discuss 3 (THREE) major external forces that will impact your future business.
- MHR612 Human Resource Management Level: Master Exploring HR Practices: An In-Depth Interview with an HR Manager
- Fundamental of Statistics Assignment, APU, Malaysia Suppose that an accounting firm does a study to determine the time needed to complete one person’s tax forms
- Organizational Behaviour Assignment, UiTM, Malaysia The Great Wall restaurant is an extremely popular restaurant in southwest Kuala Lumpur. It is located in and is part
- Financial Accounting and Reporting Assignment, SU, Malaysia The Malaysian Accounting Standard Board develops and publishes the Malaysian Private Entities Reporting Standards
- MSM606: Strategic Management Essay, AeU, Malaysia Acquire relevant knowledge on factors related to and that had impacts on how business organizations function
- Economics Assignment, HU, Malaysia The quantity demanded and quantity supplied for good A and good B by the citizens of a country XYZ at different prices
