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
- Computer Application Assignment, ICT, Malaysia Infinity College of Technology (ICT) provides sports facilities to be used not only by its students but also by the public
- Industrial Informatics Research Paper, IIUM, Malaysia What is the role of social media inclusion in elevating brand positioning across the Malaysian market in terms
- Positioning a brand effectively depends on aspects including the industry: Marketing Management, Essay, OUM, Malaysia
- BDPB2103: Introductory Human Resource Management Assignment, OUM, Malaysia Briefly discuss the advantages of training and development programs to an organization
- MPU2163: Pengajian Malaysia Essay, IIU, Malaysia Mencapai keputusan yang cemerlang dalam pelajaran adalah pencapaian yang diidam-idamkan oleh semua yang bergelar pelajar
- CBOP3103: Object Oriented Approach in Software Development Assignment, OUM, Malaysia Global Skills Solution is a prominent training centre located at the heart of Kuala Lumpur
- Commercial Law Essay, UKM, Malaysia Examining the Influence of Existing Regulation on the Increase of Electricity Theft due to Cryptocurrency Mining
- Telecommunications Research Paper, APU, Malaysia Based on an article from Outlook India dated August 2022, experts believe that 5G technology is the perfect technology
- MGT 2023: Organizational Behavior Assignment, KPTM, Malaysia Psychologist Albert Bandura is the researcher most often associated with learning through observation
- DBAF2003: Principles of Accounting Assignment, UoC, Malaysia On 1 January 2011, Yen had two vehicles for use in his business. Vehicle X was bought several years earlier for £7.500