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
- Law of Tort Case Study, BAC, Malaysia John, a student at a local university, frequently visits a nearby coffee shop during his breaks. The coffee shop is owned
- MPU3122 TAMADUN ISLAM DAN TAMADUN ASIA Assignment, OUM, Malaysia Tugasan ini adalah untuk menilai kebolehan pelajar membincangkan tentang Isu Semasa dan Masa Hadapan Berkaitan dengan Tamadun
- Computational Thinking Assignment, MU, Malaysia Computational thinking is an approach to problem-solving that involves critical and logical thinking in order to solve problems
- ECO551: Monetary Economics Assignment, UiTM, Malaysia Explain why econometrics is important for data analysis and Explain what is meant by a consistently estimated parameter
- BHM 3263: Pharmaceutical Management Essay, AMU, Malaysia You have to investigate the management of the pharmacy that you have chosen, by interviewing and researching
- Environmental Engineering Thesis, UKM, Malaysia An ornamental creeping plant will be cultivated vertically to create a wall structure. Light conditions and water availability
- CBWP2203 Assignment OUM : Sep 2024 – Web Programming
- JAVA Programming Level 1 Assignment, UNIKL, Malaysia The management of an airport thinks that the way in which the airport is operated means that incoming flights
- Sustainable Project Management Report, OUM, Malaysia Identify a project that integrates Sustainable developments into its project initiation and management
- Advanced process integration Assignment, CU, Malaysia Determine the minimum fresh water and minimum wastewater targets for the above system using water cascade analysis
