Create the following table in your database with the following schema: Table: Customer +- | Column Name | Type +. | id | int | varchar | | int | name | referee id +- ---+ id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them. Add the following data to your tables: Input: Customer table: +----+----- | id | name | referee id | +----+------ | 1 | 2 | 3 | 4 | 5 | 6 | will | null | Jane | null | Alex | 2 | Bill | null | Zack | 1 | Mark | 2 +--- Write an SQL query to report the IDs of the customer that are not referred by the customer with id 2.

Create the following table in your database with the following schema: Table: Customer +- | Column Name | Type +. | id | int | varchar | | int | name | referee id +- ---+ id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them. Add the following data to your tables: Input: Customer table: +----+----- | id | name | referee id | +----+------ | 1 | 2 | 3 | 4 | 5 | 6 | will | null | Jane | null | Alex | 2 | Bill | null | Zack | 1 | Mark | 2 +--- Write an SQL query to report the IDs of the customer that are not referred by the customer with id 2.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 2MC

See similar textbooks

Similar questions

Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be able to retrieve data from the CONDO_UNIT table. b. Users Crandall and Perez must be able to add new owners and condo units to thedatabase. c. Users Johnson and Klein must be able to change the condo fee of any unit. d. All users must be able to retrieve the unit number, condo fee, and owner number forevery condo unit. e. User Klein must be able to add and delete service categories. f. User Adams must be able to create an index on the SERVICE_REQUEST table. g. Users Adams and Klein must be able to change the structure of the CONDO_UNITtable. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNITtables.
What is a cross join? Give an example of its syntax.
3.1 Create a database Cat with the following schema: CREATE TABLE owners ( ownerid integer, name text, age integer, PRIMARY KEY (ownerid) ); CREATE TABLE cats ( catid integer, owner integer, name text, breed text, age integer, PRIMARY KEY (catid), FOREIGN KEY (owner) REFERENCES owners); 3.2. Write a SQL query that returns the number of cats, over the age of 10, of each breed of cat. 3.3. Write a SQL query that returns the ownerid/owner of the one cat owner who owns the most cats.
You are working with a database table that contains invoice data. The table includes columns for invoice_id and customer_id. You want to remove duplicate entries for customer ID and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The three dots (...) indicate where to add the clause. 1 2 3 4 5 SELECT ... FROM invoice ORDER BY invoice_id RunReset What customer ID number appears in row 12 of your query result?
A mobile app for booking doctor appointments is running very slowly when accessing data from a database and the programmers think that poorly optimised SQL statements are causing it. There are three places where they think the code might be slow. 1. When users book a new appointment. 2. When the date of an appointment is modified. 3. When a user searches for doctors by name or specialty. Could any of these be improved by creating a database index? Why/Why not? What column or columns (if any) would be appropriate to add an index to?
Using MySQL, design a 2 table database. The data types of columns should be set properly tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month) The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordingly Using Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons. 1.4 The first button will open aa frame that can be used to add, update and delete Gyjm Members. The second button will open a frame that will be used to collect the payments made by students. 1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example: Order # is the sequence number of the member in tblMembers…
From the database scheme write the query(all tables are empty) 1) Insert your name and your phone as a new tenant 2) Delete your phone number from the table tenant. 3) Create a new contract lease for you. 4) Delete the contract that you created. 5) List the city name, city population and country name. 6) List the cities that have the letters “re” in any part of the name; 7) List the tenant name contract number, rent price, when the contract rent price is bigger equal 500 and lower equal 1000. 8) List all columns from apartments with the services offered (all columns from service). 9) List the building address, the city name and the country name for the building in Canada. 10) List the name of the user with the city name and country name, ordering by name of user.
Create a table named "student" with the following columns/fields: 1. id - integer not null primary key and auto increment 2. name - string with max of 200 characters not null 3. birthdate - date allows null Enter your answer 2. Create a database named "enrollment" Enter your answer 3. Get all the columns/fields of the "student" table. Enter your answer 4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null. Enter your answer 6. Delete all the records in "student" table. Enter your answer 7. Delete a record in "student" table where its id is 1. Enter your answer 8. Get only the "name" and "birthdate" of the "student" table where its "name" starts with "Jo" Enter your answer
You are working with a database table that contains invoice data. The table includes columns for invoice_id and customer_id. You want to remove duplicate entries for customer ID and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The three dots (...) indicate where to add the clause. 1 2 3 4 5 SELECT ... FROM invoice ORDER BY invoice_id ВыполнитьСбросить What customer ID number appears in row 12 of your query result? 0 / 1 балл 16 42 23 8
This question relates to creating and altering tables, as well as implementing constraints and referential integrity. Q.1.1 You are required to create the following tables in a database named SICKLEAVE:EMPLOYEESEMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEYEMPLOYEE_NAME VARCHAR(30) NOT NULLEMPLOYEE_SURNAME VARCHAR(30) NOT NULLDATE_OF_BIRTH DATE NOT NULLDOCTORSDOCTOR_ID VARCHAR(5) NOT NULL PRIMARY KEYDOCTOR_NAME VARCHAR(30) NOT NULLEMPLOYEE_SICKLEAVEEMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES EMPLOYEES(EMPLOYEE_ID)START_DATE DATE NOT NULL PRIMARY KEYDOCTOR_ID VARCHAR(5) NOT NULLNUMBER_OF_DAYS SMALLINT NOT NULLQ.1.2 Populate the tables created in Q.1.1 with the following data:EMPLOYEESEMPLOYEE_ ID EMPLOYEE_NAME EMPLOYEE_SURNAMEDATE_OF_BIRTHI0001 Dominique Woolridge 1993-04-19I0002 Nico Baird 1991-11-19I0003 Derek Moore 1992-06-24I0004 Neo Petlele 1993-12-29I0005 Andrew Crouch 1994-01-30DOCTORS DOCTOR_ID DOCTOR_NAMED0001 Thabo NtlaliD0002 Deon CoetzeeD0003 Kwezi…
Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: For every supplier that only supplies green parts, print the name of the supplier and the total number of parts that she supplies. For every supplier that supplies a green part and a red part, print the name and price of the most expensive part that she supplies.
Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: Find the sids of suppliers who supply only red parts. Find the sids of suppliers who supply a red part and a green part. Find the sids of suppliers who supply a red part or a green part. For every supplier that only supplies green parts, print the name of the supplier and the total number of parts that she supplies. For every supplier that supplies a green part and a…

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS