1. SOLUsing SOLvoa, Create following table, Insert ALL the data/record.STUDENTADDRESSAmpangGombakSelayangAmpangBangsarNO MATRIKNO TELNAMEMazlinaKumarRidwanLow TeckAminahCOURSE12345012-3842375DTMMLVKDPGSSKDPG23456012-61016173456745678013-235689456789017-2567741COURSECOURSEDTMSUBJECT1TT235SUBJECT2TT695SUBJECT3PP563LECT1LECT2LECT3Lo56Lo03L322MLVKТТ365TT695SSo03TT235SS003L123Lo56L123L322L056Lo03L601DPGSSKPP563TT234PP999PP023Lo03L322LECTURERADDRESSDamansaraKajangGombakKajangCherasQUALIFICATION DEPARTMENTMsc CSMbaBς CSBsc ITΒα EconLECT IDNAMELo03L123L056L322L601JohnMilahAhmadRajSitiTeknologiPerdaganganTeknologiTeknologiPerdaganganUsing SQL Query, answer all trhis following statement.i. Subject taken by Kumar (2.5m)ii. Aminah's lecturer and subject.(2.5m)iii. Subject that teach by Ahmad(2.5m)iv. Student that don't have any contact number.(2.5m)

CREATE TABLE STUDENT (NoMatrik int, Name varchar(255), Address varchar(255), NoTel int, Course…

Using SQL Query, answer all trhis following statement. i, Subject taken by Kumar (2.5m) ii. Aminah's lecturer and subject.(2.5m) iii. Subject that teach by Ahmad(2.5m) iv. Student that don't have any contact number.(2.5m)

Using SQL Query, answer all trhis following statement. i, Subject taken by Kumar (2.5m) ii. Aminah's lecturer and subject.(2.5m) iii. Subject that teach by Ahmad(2.5m) iv. Student that don't have any contact number.(2.5m)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write SQL queries to answer the following questions:a. List the numbers of all sections of course…

A: To write an SQL query to list the numbers of all sections of course ISM 3113 thatare offered during…

Q: Write SQL query for following: Fetch the details of all Juices which have price less than 30 from…

A: Given: Juice(Name, Price, Rating) Requirement-Fetch the details of all Juices which have price less…

Q: True or False? SQL stands for Structured Questioning Language

A: The answer is false.

Q: Express the following queries in SQL: a) List first name, last name and department ID of all…

A: Find the required SQL queries given as below :

Q: Ineed help with the SQL query for the following question: 1. Get top 5 list of most liked and…

A: Explanation: The below query selects the Top 5 table data based on city, rating and price. The…

Q: Write SQL query to get the Names of all employees which have department alloted to them. Table-…

A: Given: We are given two tables Employee(Eno, Ename,address) and Department (Deptno, Dname, Eno). To…

Q: Drag-and-drop the assembly code to form a program where 10 numbers in an array are added and stored…

A: Below I have provided a complete program for the given question.

Q: Write an sql query thevempld and fullname of all the employees working under managers with ID 986

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: Write an appropriate SQL query to list the lecturers that teach more than one module.

A: We need to write a SQL query for the given scenario.

Q: Put in all of the various types of numerical information. In SQL

A: Here we have given the various types of numerical information in sql. You can find the solution in…

Q: Write SQL query to find the maximum marks obtained by any student in the table: Result(RollNo,…

A: Given: Result(RollNo, Name, Class, Marks) To find: Maximum marks obtained by any student. Solution:…

Q: Write SQL statements to the following queries. Update the UNIT_PRICE to be decreased by 20% for…

A: Here I Cannot see the database exactly, so this is a generic solution.

Q: Answer this following question using SQL Statement. From table STUDENT : Write a SQL Query to show:…

A: 1. select first_name, last_name, address from student where address='Ampang'; 2.…

Q: Write an SQL statement to display the minimum, maximum, and average weight of dogs.

A: SELECT MIN(Weight) AS MinimumWeight,MAX(Weight) AS MaximumWeight,AVG(Weight) AS AverageweightFROM…

Q: between SQL and MyS

A: with the help of examples differentiate between SQL and MySQL

Q: Write SQL Query to find the average of all the salaries from the table Employee(ID, NAME, SALARY,…

A: Given Table: Employee(ID, NAME, SALARY, DEPARTMENT) To Find: SQL Query to find the average of all…

Q: Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4…

A: To find the superno where COUNT(superno) is greater than or equal to 4.

Q: Find and display sales men that must not be living in the city similar to their customers also got a…

A: According to out guidelines, we are allowed to solve only the first three subparts of the question.…

Q: Write a SQL statement that retrieve all the attributes from employee_tbl and the salary attribute…

A: JOIN: These are clauses in SQL statements that link two tables together, usually based on the keys…

Q: Write an SQL query to extract the answer directly.

A: The query below will selects the year and month from the Arrivaldate column of the visit table,…

Q: Write SQL queries for the following. Display full name of doctors whose first name is other than…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Consider the following schema: Employee (Ename , EID, EDept, ERank, EAddress) Convert the following…

A: For the given query statements, we have to write the Relational Algebraic Expression.

Q: Write SQL statements to answer each of the following questions. 1. List the Customer Id, Customer…

A: According to the company's policy, we are allowed to answer only three sub-parts of a question at a…

Q: Write SQL statement that list the branches of parts in ascending order and the suppliers for each…

A: Find the required query given as below :

Q: From the following, Which one is an SQL query to find the salary for employees whose salary is less…

A: The given question is the SQL language question and it is answered by using the SQL query syntax…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: protocol to date? What are the potential consequences or implications of this discovery? Upon…

A: What are the identified issues with the router's layer 2 protocol to date? What are the potential…

Q: Why SQL is called Oriented language.

A: Given: Why SQL is called Oriented language.

Q: „By using SQL language return the items and their total number of units that have been ordered…

A: Background:- Here group by statement will be used on item name column and apply not like '%pen%' to…

Q: Use database dreamhome • All questions should be written in one SQL query 1. List the number of…

A: Introduction: In this question, we are given two tables and asked five queries by taking help of…

Q: sql queries

A: Given :- A relational database schema is given as, Team (tname, year, coach, salary) Player (pname,…

Q: Write SQL query to fetch the Names of all employees in IT department from table Employee (Name, Id,…

A: Given: Write SQL query to fetch the Names of all employees in IT department from table Employee…

Q: Use SQL commands to finish the questions. Please include BOTH SQL commands and results in your…

A: SQL : SQL (Structured Query Language) is a programming language used to manage and manipulate…

Q: Solve This SQL For the following operations, write the appropriate SQL statement. b) Determine the…

A: Please see the next step for solution:-

Q: Write MS SQL Query to retrieve top 10 students ordered by marks Student(Id, Name, Marks)

A: HI THEREI AM ADDING QUERY BELOW FOR ABOVE QUESTION PLEASE GO THROUGH IT THANK YOU

Q: Which artist has had the most works of art sold, and how many of the artist’s works have been sold?

A: MySQL:- SQL stands for Structured Query language. Oracle Corporation develops, distributes, and…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

1. SOL
Using SOLvoa, Create following table, Insert ALL the data/record.
STUDENT
ADDRESS
Ampang
Gombak
Selayang
Ampang
Bangsar
NO MATRIK
NO TEL
NAME
Mazlina
Kumar
Ridwan
Low Teck
Aminah
COURSE
12345
012-3842375
DTM
MLVK
DPG
SSK
DPG
23456
012-6101617
34567
45678
013-2356894
56789
017-2567741
COURSE
COURSE
DTM
SUBJECT1
TT235
SUBJECT2
TT695
SUBJECT3
PP563
LECT1
LECT2
LECT3
Lo56
Lo03
L322
MLVK
ТТ365
TT695
SSo03
TT235
SS003
L123
Lo56
L123
L322
L056
Lo03
L601
DPG
SSK
PP563
TT234
PP999
PP023
Lo03
L322
LECTURER
ADDRESS
Damansara
Kajang
Gombak
Kajang
Cheras
QUALIFICATION DEPARTMENT
Msc CS
Mba
Bς CS
Bsc IT
Βα Econ
LECT ID
NAME
Lo03
L123
L056
L322
L601
John
Milah
Ahmad
Raj
Siti
Teknologi
Perdagangan
Teknologi
Teknologi
Perdagangan
Using SQL Query, answer all trhis following statement.
i. Subject taken by Kumar (2.5m)
ii. Aminah's lecturer and subject.(2.5m)
iii. Subject that teach by Ahmad(2.5m)
iv. Student that don't have any contact number.(2.5m)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Creating Tables

VIEW

Step 2:

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Subqueries--Create an sql script to answer the following questions.--List all products whose unit price is less than the average price.--List the shipper id, shipping company and freight cost for the order with the lowest freight charge.--List all products with their highest unit price, i.e. not discounted. --List the average unit price for each product category and--the average unit price without discounts
Write an SQL query to retrieve the names of employees who earn a salary higher than $50,000 from an "Employees" table. Employees (Employee ID, EmployeeName, EmployeeSalary) I
Consider the following schema:instructor(ID, name, dept_name, salary)What is the correct SQL statement to perform a query to find the names of all instructors excluding duplicates?(a) select name from instructor;(b) select unique name from instructor;(c) select name from instructor no duplicates;(d) select distinct name from instructor;
USING SQL QUERY, Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id.
What is the solution for this question (sql queries)
Write an SQL statement to show the sum of SubTotal for each customer. List CustomerID, LastName, FirstName, Phone, and the calculated result. Name the sum of SubTotal as SumOfSubTotal and sort the results by CustomerID, in descending order.
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted directly. Thank you!
Question 35 If there are several operators with same priority in an arithmetic expression of an SQL statement then the priority will be For division for multiplication From left to right For addition
Please please all questions solve
Write SQL query to find the Name of all books from the table: Store(BookId, BookName, BookPrice, BookQuantity)
QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name, P_price, P_quantity, vend_name) Vender(vend code, vend fname, vend_areacode, vend salary, vend_nationality) find the names of products that owned by vender "smith" and not owend by vender "dan." 1- find the name, price and quantity of product that has code 34657 and owned by spanish venders. 2- 3- Find the name of iraqi venders who has salary less than the average salary of venders. Find the prodect name that their quantity greater than 17 and oreder them by vender name. 4- 5-add new column to the product table called p_company.
I need help with the SQL query for the following question: 1. Show the total number of customers who complained about Bluetooth issues for every product name of every manufacturer from every retailer Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours