Prepare a list of customers that each of the four brokers (Benson, Kennedy, Hilda and Nat) have.
Q: For each Consultant, list the Consultant last name, the average balance of the consultant’s clients,…
A: SQL query: The query is to obtain the consultant's last name, the average balance of the…
Q: Write queries in relational algebra 1- Select all employees who either work in department 6 and make…
A: SELECT * FROM EMPLOYEE WHERE (DeptNo = 6 AND SALARY > 25000) OR (DeptNo = 4 AND SALARY >…
Q: List the vendor names and address for all the vendors who have active invoices. And the invoice…
A: SQL Inner Join Query
Q: In terms of the following relations: (Primary Key, Foreign Key) Student…
A:
Q: Write the SQL statement for the following: 1. Display the supplier name and price of all products 2.…
A: --Following are the required queries. Output of the queries are displayed in Step2 and Step3.…
Q: Update the emp table to set the commission of all employees to SR 1000 who are working as managers
A: Syntax: UPDATE table_nameSET column1 = value1, column2 = value2, ...WHERE condition;
Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…
A: A relational database contains tables. Tables are also called relations and they contain rows and…
Q: Write a query which set the following constraints in Customers table (in MySQL). First Name and…
A: We are going to add constraints to the columns in the table Customers. First we will add constraint…
Q: Solve all queries below using Relational Algebra: Schema Suppliers (sID, sName, address) Parts…
A: The Answer is in step-2.
Q: SOQL Query to find out the All the contact that are associated with the Particular account id.
A: SOQL stands for Salesforce Object Query Language. we can use SOQL to read information stored in…
Q: Solve the following queries:
A: Find the following queries in MySQL: Display all details of the item table. Select * from item;…
Q: Given the table: emp [eid, ename, salary, d_id] The following query retrieve the department name…
A: The table: emp [eid, ename, salary, d_id] The query: select d_name from dep where d_id = ( select…
Q: 1) List all products with their highest unit price, i.e. not discounted. 2) List the average unit…
A: There are following aggregate functions used in the SQL queries: To find the highest unit price,…
Q: Data Table Guide For DBMS University Ist Normalize the given Data table. Middlename…
A: 1. First normal form It states that every attribute must have only atomic values. Multivalued…
Q: List the names of customers who are from the city of “Muscat”. List the details of customers who…
A: We'll use the attribute's names to extract data from the relation.
Q: Solve the following queries: 1. Display all details of the item table. 2. Display item name, section…
A: Note: Since your question contain multiple sub-parts but we can answer only 3-subparts at a time due…
Q: What is the CIV of each of the customers?
A: We can find CIV for each like this
Q: Use SQL and TAL Distributors database to complete the following questions: List the customer…
A: SELECT statement :- It is used to retrieve information from the table or database. The syntax for…
Q: Prepare a list of customers that each of the four brokers (Benson, Kennedy, Hilda and Nat) have.
A: The given problem is related to data structure array and linked list which contains two arrays and…
Q: Q1: Create the following related tables using appropriate data field specification: (Hint: Define…
A: CREATE - This command is used to create a new table in the database. ALTER- This command is used to…
Q: Find the first five employees hired by the company using mongoDB
A: The query to find first five employee hired: First we'll sort the list using hiring date:…
Q: In SQL Repeating groups must be eliminated by making sure that each row defines a single entity.…
A: Primary Key is used to uniquely identify each row in a table
Q: List the balance characteristics of the customers who have made purchases during the current invoice…
A: SELECT CUS_CODE, CUS_BALANCE FROM CUSTOMER WHERE CUSTOMER.CUS_CODE IN (SELECT DISTINCT…
Q: Composite primary key can be defined at table level only. Select one: True False
A: As per the question asked the, the proper solution of the question is given in below step:
Q: List all current customers by region. List all new customers by region. Report all invoices by…
A: list all current customer by region SELECT * FROM CUSTOMER WHERE REGION ORDER BY CUS_ID;
Q: Q14) how many products with price < 10
A: You have asked multiple questions so we will solve the first one for you. If you want any other…
Q: sql 1. List all details of books with ‘Database’ related titles published between year 2012 to…
A: We need to perform: 1. List all details of books with ‘Database’ related titles published between…
Q: Please produce a set of normalized relations from the following table: INVOICE Invoice Customer…
A: The primary key for the given relation is {Invoice#, CustomerID#} The functional dependency possible…
Q: Consider the following Customers table and express in relational algebra each of the questions…
A: here have to determine query of given questions.
Q: From worksheet Adidas, in cell D5, count the number of models from the Sales table which has sales…
A: 1) in cell D5 count the number of models from sales table where sales during the july FORMULA :…
Q: Product(pid, name, type, manufacturer, price) Buys(cid, pid) Customer(cid, cname, age, gender) Write…
A: SQL Query : SELECT pid,manufacturer,MAX(price) AS MostExpensiveProductFROM ProductGROUP BY…
Q: How many current reservations does Colonial Adventure Tours have and what is the total number of…
A: "SELECT" command: The "SELECT" command is used to retrieve data in a database. Syntax for selecting…
Q: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office…
A: Given: write the following queries (n) Identify flats with at least three rooms and with a monthly…
Q: Use SQL and TAL Distributors database to complete the following questions: TAL Distributors is…
A: Given: Use SQL and TAL Distributors database to complete the following questions:TAL Distributors is…
Q: Relational algebra (not SQL) for the following: Total weight of transactions per year for each…
A: The relational algebra for the above question is
Q: Consider the following relation En roll (S-no, Course-no, Section) Teach (Prot, Course-no,…
A:
Q: Using excel functions,which employee were best at finding leads who then converted into customers
A: Since you have not provided with the full dataset. Best we will be able to help with the logic and…
Q: Consider tne Howing (keys Product(pid, name, type, manufacturer, price) Buys(cid. pid) Customer(cid,…
A: Dear Student, As per our company guidelines we are supposed to answer ?️only first 3️⃣ sub-parts.…
Q: Display FishermanName and Number of Transaction (obtained from the total number of transaction) for…
A: Given that, FishermanName, Number of Transaction are the attributes to be displayed which fisherman…
Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…
A:
Q: In SQL A foreign key must exist in both tables that have a relationship. Select one: a. True b.…
A: Given: In SQL A foreign key must exist in both tables that have a relationship. Select one: a.…
Q: A "transaction" can consist of more than one SQL statement. Question 35 options: 1) True 2)…
A: Transaction is the single unit of task which is used for the modification of database. The…
Step by step
Solved in 2 steps with 4 images
- Consider an array named “Student [Marks]” to store her marks for 3 subjects. Explain how a total of the three subjects can be found using pointers.Suppose you are given a list of students registered in a course and you are required to implement an array-based student list. Each student in the list has name, regNo, department and cGpa. Implement different functions for entering the data (like constructor (for setting to default values), setName, setReg, etc.). You also need to implement the following function related to the array. insertStudent( ) : It has 2 options • Asking the user for index and then insert the student at that index AND • Asking the user for name of the student where the new student is to be added (New student should be added at the index of the student whose name is entered) o If the list is full, it should create a larger list (new size should be entered by the user), copy all the data in it and make insertion as instructed o (Insertion will only be made if the reg of the new student doesn’t exist in the list) deleteStudent( ): Same as insertStudent( ) (either by asking the index or student name) sort( ): Ask…Write a function call Occurrence that receives two arguments: an array of vectors (generic type) and a generic variable called _item. The function returns the index of the vector (i.e. the index of the vector in the array of vectors) that has the highest occurrence of the_item. The function returns -1 if the element (_item) is not found on any vector.
- Write a function call Occurrence that receives two arguments: an array of vectors (generic type) and a generic variable called _item. The function returns the index of the vector (i.e. the index of the vector in the array of vectors) that has the highest occurrence of the item. The function returns -1 if the element ( item) is not found on any vector.Write a program to search anelement in an array using linearsearch where the numbers aremember of a class namedlinear_Search and the searchingis done using a memberfunction search().Instructions Redo Programming Exercise 6 of Chapter 8 using dynamic arrays. The instructions have been posted for your convenience. The history teacher at your school needs help in grading a True/False test. The students’ IDs and test answers are stored in a file. The first entry in the file contains answers to the test in the form: TFFTFFTTTTFFTFTFTFTT Every other entry in the file is the student ID, followed by a blank, followed by the student’s responses. For example, the entry: ABC54301 TFTFTFTT TFTFTFFTTFT indicates that the student ID is ABC54301 and the answer to question 1 is True, the answer to question 2 is False, and so on. This student did not answer question 9 (note the empty space). The exam has 20 questions, and the class has more than 150 students. Each correct answer is awarded two points, each wrong answer gets one point deducted, and no answer gets zero points. Write a program that processes the test data. The output should be the student’s ID, followed by the…
- Instructions Redo Programming Exercise 6 of Chapter 8 using dynamic arrays. The instructions have been posted for your convenience. The history teacher at your school needs help in grading a True/False test. The students’ IDs and test answers are stored in a file. The first entry in the file contains answers to the test in the form: TFFTFFTTTTFFTFTFTFTT Every other entry in the file is the student ID, followed by a blank, followed by the student’s responses. For example, the entry: ABC54301 TFTFTFTT TFTFTFFTTFT indicates that the student ID is ABC54301 and the answer to question 1 is True, the answer to question 2 is False, and so on. This student did not answer question 9 (note the empty space). The exam has 20 questions, and the class has more than 150 students. Each correct answer is awarded two points, each wrong answer gets one point deducted, and no answer gets zero points. Write a program that processes the test data. The output should be the student’s ID, followed by the…Min Heap of Candy — Add and Remove Using the provided code (Question04.java and Candyjava), write the add and remove methods for a min heap of Candy using an array implementation. Make sure to include all provided files in your project and write your solution in the file "Question04.java". This method should preserve the properties of a min hap, and the candies are compared based on their weight. This value can be accessed through its accessor. Solution Tests: • Does the solution compile? • Does the solution have your name in the comments? • Does the solution have a high-level solution description (150-300 words) in the comments? • Does the method preserve the properties of a Min Heap? • Does the output match the following? Testing the Add Method Candy Weight: 10.0, Candy Weight: 40.0, Candy Weight: 20.0, Candy Weight: 50.0, Candy Weight: 60.0, Candy Weight: 80.0, Candy Weight: 30.0, Candy Weight: 100.0, Candy Weight: 70.0, Candy Weight: 90.0, Testing the Remove Method Candy Weight:…Overview Implement a dictionary using a Bag—Project 4.7 in the text (modified) Instructions Use the bag ADT provided to create an array-based implementation for bags. Then use your bag to implement the dictionary ADT provided you. This means you have to implement your dictionary using the bag functions. Test your bag and dictionary implementations with the bagtestmain.cpp file provided for you. If you are not able to fully implement all the functions of the dictionary and/or bag, you may modify the tests in bagtestmain.cpp to only exercise those functions you were able to complete. You will only get credit for those methods you test and display, so be sure you don’t leave any out. Also, do not add any public functions to your bag and dictionary implementations beyond those specified in the ADTs, though you may add private functions if you want. Put the following files into a zip file named student_name_Bag_Assignment and submit them to Canvas: h // Your bag-array implementation…
- Design a generic function that returns a minimum element from an array. The function should have two parameters. One is the array of a generic type, and the other is the size of the array. Test the function with an array of int, double, and string values.Introduction For this assignment, you are to write a program which implements a Sorted List data structure using a circular array-based implementation and a driver program that will test this implementation. The Sorted List ADT is a linear collection of data in which all elements are stored in sorted order. Your implementation has to store a single int value as each element of the list and support the following operations: 1. add(x) – adds the integer x to the list. The resulting list should remain sorted in increasing order. The time complexity of this operation should be 0(N), where N is the size of the list. 2. removefirst() - deletes the first integer from the list and returns its value. The remaining list should remain sorted. Time complexity of this operation should be 0(1). 3. removelast() – deletes the last integer from the list and returns its value. The remaining list should remain sorted. Time complexity of this operation should be 0(1). 4. exists(x) – returns true if the…A cryptarithm is a mathematical puzzle for which the goal is to find the correspondence between letters and digits, such that the given arithmetic equation consisting of letters holds true when the letters are converted to digits. You have an array of strings crypt, the cryptarithm, and an an array containing the mapping of letters and digits, solution. The array crypt will contain three non-empty strings that follow the structure: [word1, word2, word3], which should be interpreted as the word1 + word2 = word3 cryptarithm. If crypt, when it is decoded by replacing all of the letters in the cryptarithm with digits using the mapping in solution, becomes a valid arithmetic equation containing no numbers with leading zeroes, the answer is true. If it does not become a valid arithmetic solution, the answer is false. Note that number 0 doesn't contain leading zeroes (while for example 00 or 0123 do).