Write the SQLite querys for the give lab tasks in image attached according to the database relation image Lab Tasks:1. Display records of employee id, last name, first name of employees' table.2. Sort the tracks (by Albumld) and then by by the Milliseconds in descending order.3. Display the distinct city and country from customer table.4. Find the ld of playlist 'classical'.5. Find the genre name that has id 3 and 16.6. To find tracks whose name starts with wild,7. To find the tracks whose names ends with wild8. To find the tracks vwhose names contain the Wild literal string9. Create a query to show list of tracks whose genre id is not in a list of (1,2,3)10. To find the Invoices whose total are not between1 and 20.11. To find invoices whose invoice dates are from January 1 2010 and January 31 2010.12. List the first five shortest tracks13. Finds tracks whose composers are not NULL.14. Find the Title and hire date of employee 'Nancy'. SQLITEplaylistsPlaylistid NTEGERName NVARCHAR 120)invoicescustomersInvoiceld INTEGERCustomerld INTEGERInvoiceDate DATETMEBillingAddress NVARBillingCity ARCHA4 more columnsCustomerld INTEGERFirstName NVARCHAR(40)LastName NVARCHAR(20)Company NVARCHAR(80).Address NVARCHAR70)City NVARCHAR(40)State NVARCHARMO).Country NVARCHAR(40)PostalCode NARCHARITO)Phone NVARCHARI24)Fax NVARCHARIZ4).Email NVARCTARIGMSupportRepid NTI CERTUTORIALplaylist trackPlaylistid HTEGERTrackldNEGER.media typesMediaTypeld TESER,Name RZinvoice ilemsvoiceltemldInvoiceld.Trackid ERUnitPriceQuantitytracksTrackidAlbumidMediaTypeld ERGenreld.ComposerMilisecondsBitesUnitPricegenresGenreldNameemployeesEmptoyeeld TEGERLastName AHARI2A.FirstName ARCHARZUAlbumidTteAtistid.TitleReportsTo NECERBirth Date E HNEHireDate E HNEAddress RCHARNameDType here to search

The employee table consists of 8 columns. SQL(Structured Query Language) has three basic commands…

Answered: 1. Display records of employee id, last…

Engineering

Computer Engineering

1. Display records of employee id, last name, first name of employees' table.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Because the order of operands (tables) matters in an EXCEPT (MINUS) query but not in a UNION query,…

A: - We need to talk about the difference in using EXCEPT and UNION queries.

Q: Two students are registered for one course. Can both students get the last database seat?

A: Given: There are two college students that must sign up for the course. But, there is just one seat,…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: Computer Engineering / Salesforce Design a general Salesforce query to fetch all fields of a object…

A: query: SELECT FIELDS(ALL) FROM OBJECT LIMIT 200

Q: How does the use of "Materialized Views" benefit the optimization of complex queries?

A: Materialized views are a powerful tool that can be used to improve the performance of complex…

Q: Explain the Dataset object and its purpose.

A: The answer of this question is as follows.

Q: PLZ help with the following: IN SQL Let R (A, B, C) be a relation schema. What happens if we…

A: Relational schema refers to the meta-data that describes the structure of data within a…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: What are the benefits of normalisation methods that use functional dependencies?

A: Normalization is the process of organizing the data in the database. Normalization is used to…

Q: Convert this ER model to a list of tables (Please provide a picture of the tables from Access)…

A: ER diagram stands for Entity relationship diagram and it contains mainly three components that…

Q: In Database Design and Concepts, how would I write a query for the following problem: If a customer…

A: First we have to filter out the data where invoice amount more than 700 Then we have to group the…

Question

Write the SQLite querys for the give lab tasks in image attached according to the database relation image

Lab Tasks:
1. Display records of employee id, last name, first name of employees' table.
2. Sort the tracks (by Albumld) and then by by the Milliseconds in descending order.
3. Display the distinct city and country from customer table.
4. Find the ld of playlist 'classical'.
5. Find the genre name that has id 3 and 16.
6. To find tracks whose name starts with wild,
7. To find the tracks whose names ends with wild
8. To find the tracks vwhose names contain the Wild literal string
9. Create a query to show list of tracks whose genre id is not in a list of (1,2,3)
10. To find the Invoices whose total are not between1 and 20.
11. To find invoices whose invoice dates are from January 1 2010 and January 31 2010.
12. List the first five shortest tracks
13. Finds tracks whose composers are not NULL.
14. Find the Title and hire date of employee 'Nancy'.

SQLITE
playlists
Playlistid NTEGER
Name NVARCHAR 120)
invoices
customers
Invoiceld INTEGER
Customerld INTEGER
InvoiceDate DATETME
BillingAddress NVAR
BillingCity ARCHA
4 more columns
Customerld INTEGER
FirstName NVARCHAR(40)
LastName NVARCHAR(20)
Company NVARCHAR(80).
Address NVARCHAR70)
City NVARCHAR(40)
State NVARCHARMO).
Country NVARCHAR(40)
PostalCode NARCHARITO)
Phone NVARCHARI24)
Fax NVARCHARIZ4).
Email NVARCTARIGM
SupportRepid NTI CER
TUTORIAL
playlist track
Playlistid HTEGER
TrackldNEGER.
media types
MediaTypeld TESER,
Name RZ
invoice ilems
voiceltemld
Invoiceld.
Trackid ER
UnitPrice
Quantity
tracks
Trackid
Albumid
MediaTypeld ER
Genreld.
Composer
Miliseconds
Bites
UnitPrice
genres
Genreld
Name
employees
Emptoyeeld TEGER
LastName AHARI2A.
FirstName ARCHARZU
Albumid
Tte
Atistid.
Title
ReportsTo NECER
Birth Date E HNE
HireDate E HNE
Address RCHAR
Name
DType here to search

Organized collection of structured information, or data, typically stored in a computer system.

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

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

PLZ help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints. Normalize the relations to 3NF.
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
need solution for problem 19 of chapter 7 of book- Database Systems: Design, Implementation, and Management, 13th Edition, by Carlos Coronel and Steven Morris
CENTRAL SCHOOL LIBRARY Observe the ER diagram for the CENTRAL SCHOOL LIBRARY CENTRAL SCHOOL LIBRARY ERD LBID LBName CopyID CoverType LIBRARY BOOK Has COPY (2,10) iswrittenBy 4 AUTHOR AuthorID Authortiame How many tables will the relational schema mapped from the Central School Library ER diagram have?
Given the database schema below, write a relational algebra expression to get the count of records in the DEPENDENT relation group by Essn. Also, show the result of your query.
computer engineering question Write the Program in APEX using Salesforce Object query Language to Fetch Contacts and Opportunities Records and also show the output
Based on the table provided, answer the following questions in relational algebra.
Consider the following database table named water_schemes: water- schemes scheme_no district_name capacity Ajmer 1 20 1 Bikaner 10 2 Bikaner 10 3 Bikaner 20 1 Churu 10 Churu 20 1 Dungargarh 10 The number of tuples returned by the following SQL query is with total(name, capacity) as select district_name, sum(capacity) from water_schemes group by district_name with total_avg(capacity) as select avg(capacity) from total select name from total, total_avg where total.capacity 2 total_avg.capacity
When sorting data on more than one field in an Access query, which field is the major sort key? Which field is the minor sort key? What effect do these keys have on the order in which the rows are displayed?