Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and price of the job. It also maintains a file of estimates given for jobs not yet performed; this file contains a customer number, name, address, proposed date of job, and proposed price. Each file is in customer number order. Design the logic that merges the two files to produce one combined file of all customers whether past or proposed with no duplicates; when a customer who has been given an estimate is also a past customer, use the proposed data. (flowchart or pseudocode)

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: 8 An employee file contains records that show an employee's number, name, job code and pay code. The…

A: In the above question job code and job description is given in one table and in the other columns,…

Q: Put your code in the main method given below. [Hint: SQL will return all accounts from the…

A: table name AccountingDB   display all account

Q: Get the student#, course# and midterm grade of the enrollments for courses of the CS department.

A: Relational Algebra :- A procedural query language is relational algebra. It walks you through the…

Q: ntacts Database) Study the books.sql script provided in the ch17 examples folder's sql subfolder.…

A: Answer is below:

Q: aintain a database in a file: o Add a new vehicle to the fleet. Vehicle information should include…

A: Code : #include<stdio.h> void main(){    int u,d,r,l,nod,phno;    char name[100];    char…

Q: Create a subprogram called Birthday_sub that accepts today's date as default parameter and writes…

A: PROCEDURE BIRTHDAY_SUB (date); BEGIN INSERT INTO B_C_File ( first_name, last_name,…

Q: Is this statement true or false? The term "null" refers to a column in a database table that does…

A: Given: Is this statement correct or incorrect? The term "null" refers to a column in a database…

Q: Tell the commands for python jupyter pandas manipulation required for these operations. 1* Import…

A: 1.The required module for reading file is pandas and command is  import pandas as pd

Q: Sondt File Student Number Student Name Address Telephone (v) Corse File Course Number Description…

A: SELECT courseNumber, description FROM courseFile WHERE professorNumber=(select professorNumber from…

Q: You need to provide two files. 1. word/pdf report file 2. you code in *.sql/.txt file 1. word/pdf…

A: Please find the answer which is as shown below, Thankyou. Please find the required ERD as shown…

Q: // Each time a salesperson sells a car at the // Pardeeville New and Used Auto Dealership, // a…

A: Given: // Each time a salesperson sells a car at the // Pardeeville New and Used Auto Dealership, //…

Q: The file that contains ordering attributes that are not key in nature is referred to as the

A: Order characteristics allow you to define an element of an order in a way that is unique to that…

Q: Propose a method to authorize the users to SELECT from HR.EMPLOYEES table in the Oracle 18C database…

A: Access Control : Access control, some of the time called approval, is the manner by which a web…

Q: e. Create a form for the records and name it frmMovies f. Query the table to look out for movies…

A: From the following table, write a SQL query to find the name and year of the movies. Return movie…

Q: parate file should add an attribute to the table data in the file should insert data into table data…

A:

Q: Given the default schema of a database: Customers 123 Customerld noc FirstName noc LastName noc City…

A: The SQL program for the given problem is as follows: use demo;Create table Suppliers(SupplierId int…

Q: List the difference between File Allocation Table & New Technology File System in a table with at…

A: DIFFERENCE BETWEEN FILE ALLOCATION TABLE AND NEW TECHNOLOGY FILE SYSTEM:                 Features…

Q: The code shown below is designed to increment through each row in a database table. Correct the…

A: We have to increment through each row in a database table, for that we can use any of the following…

Q: Explain file allocation table.

A: It is a table that an operating system maintains on a hard disk and it will provide a map of the…

Q: In this database we have users that can be two types students or instructors. They have groups and…

A: In this question we have to write SQL QUERIES on (1) Queries involving subqueries(2) Queries…

Q: A File was sorted by key field, and then 10 records were stored in each block. Multi-level Indexing…

A: Given: A File was sorted by key field, and then 10 records were stored in each block. Multi-level…

Q: Write the SQL statements to create database objects. la. Create a table with the details shown…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

Q: PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female…

A: It is defined as a powerful general-purpose programming language. It is used in web development,…

Q: Use the DDL SQL command “CREATE” to define each of your entities

A: 1. Specialization:CREATE TABLE Specialization (SID int PRIMARY KEY, title varchar(25), DepartmentID…

Q: Show their content after: 1) Update student set sid = 9999 where sid = 5275 2) Update student set…

A: Below is the complete solution with explanation in detail for the given question about updating…

Q: In what circumstances does it make sense to assume that two select statements from the same database…

A: Introduction: Union compatibility is achieved when both tables contain the same amount of attributes…

Q: 2) Create in PL/SQL a stored procedure called 'Del Details' to delete the record of orderedProduct…

A: 2. The SQL query is given below: CREATE PROCEDURE [dbo].[Del Details] -- Add the parameters for the…

Q: Program 4: Create a PLSQL program that displays the patient's id and name along with the treatment…

A: PL/SQL (Procedural Language/Structured Query Language) is a procedural programming language designed…

Q: Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped…

A: The task at hand involves using Excel's Index and math functions to populate a table displaying the…

Q: Course Offering StudentiD : number (10) InstructoriD : number (10) CourselD : number (10) O Time :…

A: SMALLINT, INTEGER, BIGINT, NUMERIC(p,s), and DECIMAL(p,s) are the exact numeric data types.…

Q: Differentiate Nested Loop, Hash Join and Merge Join.

A: Differentiate Nested Loop, Hash Join and Merge Join

Q: Create a data file in Python using open, write and close functions.  Your data file should contain…

A: this is a basic problem of file I/O in pyhton. I will provide the code in next step. Note: If you…

Q: Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a…

A: The question asks you to create a PL/SQL anonymous block to insert a new project into the DoGood…

Q: Given the following declaration of records and the name of the records, write the full program to…

A: First we have to create table for both case then we have to input the values.

Q: EventHelpers is a company that specializes in event medical assistance. They can handle any type of…

A: ER: It is outlined as associate Entity–relationship model (ER model) describes the structure of a…

Q: I: 'Mr./Mrs '|| Iname||', '||fname as full_Name II: concat('Mr./Mrs ', Iname, fname) as full_Name I…

A: Answer of above two questions mentioned below:-

Q: QUESTION Given the sample of the GPADatabase in a file, write SQL Stored function called…

A: Steps to create a SQL stored function to calculate the semester GPA:   Step – 1: Connect to your SQL…

Q: order

A: According to the question we have to write the query listing the number and name of the customer who…

Q: | The column value descriptor (CVD) contains a description of a column value. During field-encoding,…

A:

Q: rite MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored…

A: write MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored…