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
- EGB10403:Intermediate Microeconomics Assignment, MU, Malaysia explain with a relevant example why is it important for a business
- CES3013: Social and Current Issues in Computing Assignment, UOW, Malaysia Evaluate the implications of social and ethical issues in the development of information systems. Demonstrate awareness of the nature
- DATA ANALYSIS Assignment, TU, Malaysia Develop RQ, RO, Hypothesis and Framework Data screening and data coding in excel and then SPSS based on the questionnaire given
- MKT539 Brand Management, Report, BCU, Malaysia Product Strategy Features, Quality, Style and Design, Packaging and Labelling, After marketing
- LEI3044: MANAGING SECURED ENVIRONMENTS Assignment, SUC, Malaysia You are required to build an insider threat mitigation program for your company
- BCS2143: Object Oriented Programming Assignment, UMP, Malaysia You are required to develop a Java Application-based banking application that enables customers to apply for loans online
- How might Nestlé strategize for the global expansion of its sustainability initiatives: marketing management Assignment, IIU, Malaysia
- Financial Economics Assignment, SU, Malaysia Australia’s economy has plunged into its first recession in nearly thirty years, as it suffers the economic fallout from the coronavirus
- MPMM7113: You have a friend named David who is a passionate environmentalist and runs a small eco-friendly products store: Davideting Management Assignment 2, CUM, Malaysia
- Marketing Innovations Report, APU, Malaysia Coway has been committed to the Malaysian market for over 15 years. According to GfK 2020 brand health survey
