Answered: 22. Write a Scheme function, count that…

22. Write a Scheme function, count that returns the total count of number of element in a list (where sub lists are a single element (count (1 2 3)) -> 3 (count (1 2 3 4 5 6))) =>4

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

Similar questions

1 Context write SQL statements for given questions in order to get familiar to basicSQL data manipulation and definition statements by(Using MYSQL Application) using insert using update using alter create table create view 1. DEFINE TABLE AUTHORS WITH COLUMNS AUTHORID INT AND AUTHORNAME VARCHAR(30) -- ADD COLUMN LEVEL PRIMARY KEY CONSTRAINT FOR AUTHORID-- ADD COLUMN LEVEL NOT NULL CONSTRAINT FOR AUTHORNAME -- (NOT NULL CAN ONLY BE DEFINED AT COLUMN LEVEL) -- INSERT SOME VALUES TO AUTHORS TABLEINSERT INTO AUTHORS VALUES(3,'İLBER ORTAYLI');INSERT INTO AUTHORS(AUTHORNAME, AUTHORID) VALUES ('JULES VERNE',4);INSERT INTO AUTHORS VALUES(5,'STEPHEN HAWKING');INSERT INTO AUTHORS VALUES(6,'GEORGE ORWELL');-- CHECK RECORDS ON TABLESELECT * FROM AUTHORS;-- 2. DEFINE TABLE PUBLISHERS WITH COLUMNS -- PUBLISHERID INT AND PUBLISHERNAME VARCHAR(30)-- ADD TABLE LEVEL PRIMARY KEY CONSTRAINT FOR PUBLISHERID-- ADD TABLE LEVEL UNIQUE CONSTRAINT FOR PUBLISHERNAME -- INSERT SOME VALUES TO PUBLISHERS…
1. Normalize the following table into first (1NF), second (2NF) and third (3NF) Normal form. Identify the primary key for each table and set the foreign key to link the table. Travelar Travelar Travelar Travelar Travelar COVID TestingUnit TestingUnit Nationality Nationality Address TestDate ID ID Name Gender Age Name ID Name 1 Ali Male 35 Sohar 25/01/20 10 Health Center100 Omani 18/04/20 20 Star Care 30/04/20 30 Aster 2 Raja Female 29 Saham 03/02/20 10 Health Center|200 Indian 20/02/20 30 Aster 3 Aziz Male 73 Shinas 19/04/20 40 Lifeline 100 Omani 03/05/20 10 Health Center 14 Mustafa Male 43 Liwa 10/04/20 40 Lifeline 300 Eygptian 24/04/20 20 Star Care Travelar_TestingUnit Table
Insert the following records into the tables CLIENT and CLIENT_DETAILS CLIENT Client_no Client_Name Address Order Date C100 DELL AMERICA 05-05-2018 C101 SANDISK KINGDOM 10-10-1998 C102 SAMSUNG KOREA 12-08-2010 C103 LENOVO JAPAN 10-07-1998 CLIENT_DETAILS Client_no Order_No Product Cost Quantity Status C100 R001 JIOCLASS 100.40 3000 PROGRESS C101 R002 SMARTWATCH 300.50 4000 DELIVERED C102 RO01 SPYCAMERA 600.10 2000 PROGRESS C103 R003 IROBOT 4000 DELIVERED C104 R002 RADAR 500.00 400 PROGRESS
Having trouble with my SQL statements returning errors for these. Guidance would be awesome.
Q: Why do we use LINQ ? Explain it with some examples.
Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME 1565 Emre 1789 Akif 1265 Eyup 4537 Fatih 6542 Murat CITY CITY_ID CITY_NAME 1 Gaziantep 2 Balıkesir 3 Edirne 4 Van 5 Rize 6 Kayseri ORDER ORDER_ID ORDER DATE 1 05.08.2012 2 11.04.2015 3 12.06.2013 4 02.05.2015 5 02.09.2014 ADDRESS CITY_ID CITY_NAME Gatem 2 Rasaf yolu 1 Damlacık 6 köyü Seyrantepe 1 Sarıgüllük PRODUCT PRODUCT_ID PRODUCT_NAME PRICE (TL) 1 Bilgisayar 3250 2 Telefon 1800 3 Monitör 650 4 Klavye 45 5 1200 Televizyon Masa 6 60 CUSTOMER_ID 1565 1265 4537 6542 1565 ORDER_DETAIL ORDER_ID PRODUCT_ID 1 1 1 3 1 4 2 4 3 4 3 5 4 1 4 3 4 5 4 6 5 1 5 3
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
Please provide answer and explanation as well
QUESTION 2 Candidate keys Chosen as preferred way to identify a row All of these None of these O Uniquely identify a row in the table within which it resides O Enforce referential integrity
What are the general weaknesses and SQL injection enablers:
Write the MySql Queries. Proving yourself worthy of being able to handle bigger tasks, the tech lead has decided to give you a challenging job. However, this time, the data that you would be handling is very sensitive and no one wants this data to be leaked. Therefore, instead of getting the entire table, the tech lead has given you the list of attributes that the table contains and the table name. The information given is as follows: You are tasked with building the MySql queries to retrieve the following information: 1. Find the first_name, last_name, email, phone_number, hire_date, and department_id of all the employees with the latest hire_date. 2. Find the first_name, last_name, employee_id, phone_number, salary and department_id of all the employees with the lowest salary in each department. 3. Find the first_name, last_name, employee_id, commission_pct and department_id of all the employees in the department 'DPT007' who have a lower commission_pct than all of the…