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
- BFW3121: Investments and portfolio management Coursework, MUM, Malaysia The table below depict the expected return CCC Berhad and XXX Berhad for April and May
- TEE103: i. Calculate the voltage Vs, by using Kirchhoff’s law and Ohm’s.: Circuit Theory I Assignment, WOU, Malaysia
- Property Management System Assignment, APU, Malaysia Identify a business domain for Condominium Property Management. Construct a software solution using
- ESE633: Statistics of Education Assignment, AeU, Malaysia An English test was administered to two classes of secondary school students. Explain the distribution
- BFW3121: Investments and Portfolio Management Assignment, MUM, Malaysia The Malaysian stock market is a key economic indicator of the country’s overall economic health
- BM070: Business Research Methods Assignment, APU, Malaysia Describe principles, design, methodology, and concepts in formulating research. Interpret business problems into a succinct
- BAS6434 Advanced Accounting Information Systems Assessment: Proposed Information System for Yahama Bike Sales System
- Data Mining Case Study, UOM, Malaysia- Choose any dataset and present the comparative analysis between clustering and association analysis, keeping in mind all the stages of SEMMA
- CWP3014: Evaluate the current suggested Gifted Education system requirements and discuss what are the variables: Introduction to Web Design Assignment, UOW, Malaysia
- 380CT: Theoretical Aspects of Computer Science Assignment, CU, Malaysia You are assigned to the problem stated above and you are required to develop a computer program to try and solve it