Create Dept_no CREATE TABLE employee (eid INTEGER PRIMARY KEY,name TEXT NOT NULL,AGE INTEGER NOT NULL,salary INTEGER NOT NULL7 );INSERT INTO employee VALUES (1, 'Ryan', 26, 30000);INSERT INTO employee VALUES (2, 'Joanna', 30, 45000);INSERT INTO employee VALUES (3, 'Mark', 35, 75000);INSERT INTO employee VALUES (4, 'Anthony', 24, 35000);12 INSERT INTO employee VALUES (5, 'Lisa', 24, 60000);13 INSERT INTO employee VALUES (6, 'Henry', 50, 250000);SELECT * FROM employee ORDER BY name ASC, salary DESC;346 Practical Tasks for Database SystemsQuestion:1Show all data from employee table where name should be in ascending and salary indescending order.Show the total length of (eno. deptno). (Employee Number, department Number) joined itand rename by funetion from the employee table?Show the ename (employee name) first 3 alphabets of manager?Write a query that show the manager data like this.job*** MANAGERenameJONESBLAKE***MANAGER

Answered: Image /qna-images/answer/9d48a518-8f64-4f08-9365-a6009576f390.jpg

Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Show the total length of (eno. deptno), (Employee Number, department Number) joined it and rename by funetion from the employee table? Show the ename (employee name) first 3 alphabets of manager? Write a query that show the manager data like this. ename JONES job *** MANAGER BLAKE ***MANAGER

Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Show the total length of (eno. deptno), (Employee Number, department Number) joined it and rename by funetion from the employee table? Show the ename (employee name) first 3 alphabets of manager? Write a query that show the manager data like this. ename JONES job * MANAGER BLAKE *MANAGER

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 5TD

See similar textbooks

Similar questions

This question is related to the Database:- Suppose you are creating a database for a library management system. Explain how you would make a table for the "books" entity and insert some sample data, and then alter the table to add a new column for the "authorID" attribute and update "authorID" with some data. Finally, make a SQL query to retrieve all the books that were published after the year 2000. Note that this book schema has several columns, including "book_id" as the primary key, "title", "authorN", "publisher", "publication_year", "isbn", "language", and "num_pages". It also includes "available" column that is set to "true" by default and can be used to track the availability of the book. Please don't use handwriting...
WRITE THE OF MYSQL IN PYTHON, JUST ANSWER THE 2ND QUESTION BY LOOKING AT THE FIRST QUESTION Create database and tables as given below by using Python. (a) Market database (b) Vendor: vendor id integer, vendor name varchar, license start date, license end date (c) Item:itemidinteger,itemnamevarchar,itemtypevarchar, previous price float, last sold date date (d) Auction: auction id integer, vendor id integer, item id integer, price float Choose primary and foreign keys depending on the relations in Market database design. Create arrays of at least 5 di↵erent records. Use these arrays to populate each table in the database.
WRITE THE CODE OF MYSQL IN PYTHON Create database and tables as given below by using Python. (a) Market database (b) Vendor: vendor_id integer, vendor_name varchar, license_start date, license_end date (c) Item: item_id integer, item_name varchar, item_type varchar, previous_price float, last_sold_date date (d) Auction: auction_id integer, vendor_id integer, item_id integer, price float Choose primary and foreign keys depending on the relations in Market database design.
In Database Design and Concepts, how would I write a query for the following problem: If a customer placed 2 or more high dollar orders, list the customer ID, number of orders and the total amount of all high dollar orders placed. ("High dollar order" is an individual order with invoice amount (dollars) >$700.00) cid Total Orders Total Dollars C001 2 1440 C002 2 1584 C003 2 2208
Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?
How about a rundown of the advantages that come with using tables in database systems? Could you perhaps write a few words on the topic of NULL?
Since no particular student is affiliated with a number, disclosing the total of all financial assistance for students in Smith dorm is not sensitive. Similarly, since no numbers are mentioned, a list of names of students seeking financial assistance is not sensitive. If only one student in Smith dorm requires funding, the sum of these two lists shows the number for an actual student. What calculations does a database management system have to make to figure out if the list of names contains classified information? What documents does the database management system need to keep on what particular people know in order to decide whether or not the list of names contains classified information?
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1. Given the preceding information, answer Questions a through e. How many database requests can you identify for an inventory update for both PRODUCT and PART? Using SQL, write each database request you identified in Step a. Write the complete transaction(s). Write the transaction log, using Table 10.1 as your template. Using the transaction log you created in Step d, trace its use in database recovery.
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.Given the preceding information, answer Questions a through e.a. How many database requests can you identify for an inventory update for both PRODUCT and PART?b. Using SQL, write each database request you identified in Step a.c. Write the complete transaction(s).d. Write the transaction log, using Table 10.1 as your template.e. Using the transaction log you created in Step d, trace its use in database recovery.
A relational database could be able to cut down on the amount of columns in a table that are required to satisfy certain criteria by using an operation known as select.Which is it: the proper or the erroneous interpretation?
Consider the following shorthand representation of a relational database used by a book publisher to answer the following questions.BRANCH (BRANCH_NUM, COUNTRY, NUM_EMPLOYEES) WRITER (WRITER_NUM, LAST_NAME, FIRST_NAME, BOOK_NUM) BOOK (BOOK_NUM, TITLE, TYPE, PRICE, WRITER_NUM) INVENTORY (BOOK_NUM, BRANCH_NUM, ON_HAND)2.3 List the number of employees for each branch in South Africa. 2.4 List the book code and title of each book of type “Romance”. 2.5 For each type of book list the type and the average price. 2.6 Find the title for each book written by “Bob Builder”. 2.7 List the name of all books in South Africa written by “Hans Anderson“ 2.8 Count the number of books (AS NumOfBooks) written by each author
Consider a database that consists of the following relations.SUPpLIER(Sno. Sname)PART(Pno, Pname)PROJECT(Jno, Jname)SUPPLY(Sno, Pno, Jno)The database records information about suppliers, parts, and projectsandincludes a ternary relationship between suppliers, parts, and projects.Thisrelationship is a many-many-many relationships. Specify and execute thefollowingqueries using the relational algebraRetrieve the part numbers that are supplied to exactly two projects.b. Retrieve the names of suppliers who supply more than two parts toproject J11c. Retrieve the part numbers that are supplied by every supplier.d. Retrieve the project names that are supplied by supplier S1' only.e. Retrieve the names of suppliers who supply at least two different partseach to at least two different projects.

SEE MORE QUESTIONS

Recommended textbooks for you

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

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

SEE MORE TEXTBOOKS