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
- BBCA1033 Introduction to Accounting Assignment, CUM, Malaysia
- Company and Business Law Assignment, BAC, Malaysia Demonstrated ability to identify a legal issue arising from a set of facts. Demonstrated ability to apply a relevant
- MKT558 Digital Marketing Assignment Coursework Brief | UiTM
- EBTL 4103: Law and Technology Management Assignment, OUM, Malaysia Describe the terms and conditions of your current employment which consists of the express and implied terms
- BBIM4103 International Marketing Assignment, OUM, Malaysia
- Investment Analysis and Portfolio Management Assignment, UNM, Malaysia Is Vitrox a growth or value company/ stock? Explain the characteristics, why is it so, find data from the annual report
- Business Law Assignment: A Critical Examination of the Main Sources of Law in Malaysia and Their Role in the Legal System
- Freight and Supply Chain Management Research Paper, SU, Malaysia According to Ziesemer, Thomas (1995) in his study about the growth with imported capital goods
- BFF5915: OPTIONS, FUTURES AND RISK MANAGEMENT Assignment, MUM, Malaysia The Black-Scholes-Merton option pricing model assumes a risk-free rate as the expected rate of return on the asset
- Computer Science Assignment, UON, Malaysia A floating bottle has two ways to go: either it goes to someone else or it comes back to you. The floating bottle
