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
- BBM204: Business Law Assignment, WOU, Malaysia Describe the jurisdiction of the Federal Court in Malaysia. Explain any THREE (3) ways in which a proposal can be revoked
- A small new software development project at company SRT Enterprise has five major activities: Production Operation Management Home Work, UUM, Malaysia
- ECO162: Microeconomics Assignment, UiTM, Malaysia Explain briefly the type of business, the background of the company, and the type of product produced
- MGT7101: MANAGING OPERATIONS OF BUSINESS Assignment, UPM, Malaysia Examine the issues and trends in operations management and how that in turn affects an organisations SIPOC
- BBGO4103: The purpose of this assignment is to enhance learners’ ability to apply and adapt the concept and theories of organisational behaviour: Organisational Behaviour, Assignment, OUM, Malaysia
- COMMERCIAL LAW Assignment, UM, Malaysia On 2.2.2021, Sahid entered into a hire purchase agreement with Kejora Finance Bhd for the hire purchase of a new Proton Perdana Motor car
- Business Administration Report, UTN, Malaysia Provide a brief discussion on the importance of the external environment and internal analysis of the organizations
- 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.
- Website Development Report, NEC, Malaysia The owners of the company are eager to have a high-quality website and have asked you to provide them with information
- BMK311: Product Management Assignment, WOU, Malaysia Smart Home Technology was introduced in the early 2000s. Everyone in the world began talking about the Internet of Things
