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
- Biostatics Assignment, SU, Malaysia A company claims that its new manufacturing process results in a mean weight of 60 grams for a certain product
- Advanced Financial Management Assignment, UUM, Malaysia Show an excellent description and discussion of issues and material with evidence of critical evaluation of issues and material
- Nursing Thesis, USM, Malaysia Physical restraint (PR) is the term used to describe limiting a patient’s motions and preventing them from moving around
- Hubungan Etnik Assignment, UTN, Malaysia An alisisperanan nstitusi agama seperti masjid, tokong, gudhwaraataugerejauntukmengatasikonflik agama di Malaysia
- LAW034: Introduction to Legal Theories Assignment, UiTM, Malaysia You are the renowned constitutional law expert in the country and have a column in a local daily
- FIN435: Financial Market And Banking Services Assignment, UiTM, Malaysia Overview of the development of the Malaysian financial system
- CBCT2203: Basic Concepts of Information Technology Assignment, OUM, Malaysia Hari ini, pembangunan dan kecanggihan Maklumat dan Teknologi (IT) dilihat sebagai fenomena penting yang memberi
- Operation Management Assignment, OUM, Malaysia Mr Wong is a Burger Queen outlet franchisee. As a franchisee, Mr Wong is expected to fulfill his contractual obligation to ensure his outlet
- BIT2133: Programming Concepts Course Work, UOC, Malaysia Students MUST keep a copy of all submitted work for reference purposes prior to the original being handed in and returned
- Industrial Informatics Research Paper, IIUM, Malaysia What is the role of social media inclusion in elevating brand positioning across the Malaysian market in terms