An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel H4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. ii. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.
Q: SeriResort has four type of room packages, The rate for each package is shown in the following…
A: A flow chart shows the pictorial representation of an algorithm. The flowchart shows the sequence of…
Q: Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St Aberdeen AB2…
A: Tuple: Tuples means rows. Degree: Degree of relation means number of attributes in a table.…
Q: Panda EST 2. Monthly Sales Report - July 4 Emp. No. Name Ahmed Hassan Ali Waleed Mohammed Samir…
A: Required: to fill missing value in given excel table:
Q: SALES_REP REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 05 Susan…
A: The complete solution is attached below:-
Q: Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded,…
A: Use the following formula: =COUNTIF(range,"*txt*") =COUNTIF(C2:C11,"*ON*")
Q: Variable Label Student's identification number School (1 = SMK Puteri, 2 = SMK Cabang Tiga, 3 = SMK…
A: ANSWER: Student Highest Average Marks:
Q: Q1) you have the following table given below: CUSTOMER Customer ID - Gender phone - Address -…
A: Syntax to create view. create view viewName as select colName from tableName;
Q: FIGURE P1.5 The File Structure for Problems 5-8 PROJ_NUM PROJ_NAME EMP NUM 1 Hurricane 1 Hurricane 1…
A: The given data will not form a normalized table. The tables in the normalized form will be 1. Table…
Q: Calculate BEP for the following information. Year o Year 1 Year 2 Year 3 Total benefit 0 49561 61635…
A: Here, I have to provide a solution to the above question.
Q: Grade Calculation at CoTs Student ID J123458 Student Name Someshvar Course ID ITDB201 Course Name…
A: <!DOCTYPE html><html><head> <meta charset="utf-8"> <meta…
Q: Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded.…
A: For finding out the first part of some string text , find and left function is used. For error…
Q: Write a script to create the below table: Year Worldwide_gross Avengers 2019 2797 Avatar 2009 2790…
A: movies = {'Avengers';'Avatars';'Titanic';'Star Wars'}; Year = [2019;2009;1997;2015]; Worldwide_gross…
Q: ncome from Operations nterest Expense mcome before Income Tax Expense ncome Tax Expense 190,600 33…
A:
Q: Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St 163 Main…
A: Tuple is a single row in a relation. Degree is a number of attributes/columns in a relation.…
Q: Write a server for a client. The client sends loan information (annualinterest rate, number of…
A: The Exercise33_01Server script needs to be run before Exercise33_01Client to establish a connection…
Q: What is the SQL command for the following, using the data attached: Find the total of the balances…
A: Writing a SQL query to display data of customers whose balance are less than their credit limits and…
Q: After the successful conduct of Mid Term Examinations, the HOD of the Department of Examinations has…
A: Description of the assignment. 1- This assignment fully depends on the control statement…
Q: Company ABC in Kenya pays its employees based on a commission of the sales they make as illustrated…
A:
Q: elow, please provide the result of statement c. Select * from dept; Select * from emp; MGR DEPTNO…
A: The RIGHT JOIN keyword returns all records from the table2, and the matching records from the…
Q: SELECT EMP# FROM EMP WHERE EMP.TITLE ="PROFESSOR" OR (NOT(EMP.FNAME = "Joe") AND (EMP.FNAME= "Joe"…
A: It is defined as a database computer language designed for the retrieval and management of data in a…
Q: A large spreadsheet contains the following information about local restaurants. A sample portion of…
A: A filter is used in a spreadsheet to select which particular values need to be displayed and which…
Q: 36. Using the product and sales order detail table, find the products with total units sold greater…
A: Solution !!
Q: EMPLOYEE Fname Minit Lname Sex Salary S Address 123456789 1965-01-09 731 Fondren, Houston, TX M…
A: a-- select Fname, Bdate from EMPLOYEE where Dno = 4 and Salary > 40000; The output table will…
Q: Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales.…
A: Flowchart:
Q: Patient table PATIENTNUM NAME SURNAME APPOINTMENTDATE APPOINTMENTTIME SURGEONID W220 TONY JONES 12…
A: Hello Student, hope you are doing well, I will be trying my best to explain and fulfill your query.…
Q: 1. Count the number of Products where Price is less than 500. 3. 2. If the Total Amount is above…
A: Note: As per our guidelines, we are supposed to answer only one question. Kindly repost other…
Q: Answer the following questions according to the ERD of the Airport system: AIRPORT AIRPORTCODE…
A: According to the Question below the Solution:
Q: Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or…
A: CREATE TABLE Student_TBL(StudentID INT NOT NULL,StudentName VARCHAR(25),CONSTRAINT Student_PK…
Q: a,b a b qo q1 q2
A:
Q: North South East West Sales Area Sales Person Sales Area Salesforce Salesforce Salesforce…
A: Salespersons( Sanme varchar(50)); Courses(Cname varchar(50)); Enrollment( Sname varchar(50), Cname…
Q: esperson ID Name Salary Com_Rate Hire date 1 John 100000 2 Amy 120000 3 Mark | 65000 4 Pam 5 Alex…
A: SQL commands are instructions. It is used to communicate with the database. It is also used to…
Q: Alreej College Computer Application Student Name Student_ID Math En Ahmed Omar Huda 20f20 45 10 35…
A: 1.
Q: Q3/Consider the following table is used to truck information: Truck_num Base_code Base_city…
A: Given table contains truck information with column headings as Truck_num, Base_code, Base_city,…
Q: Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME…
A: Given different tables of: CUSTOMER CITY PRODUCT ORDER ORDER DETAIL The objective is to: Display…
Q: Given the following relation that stores details about students' activities: StudentID…
A: here have to determine functional dependencies are consistent or not.
Q: Using the information given in the table below, calculate the total amount payable by the company to…
A:
Q: The Grocery Store Transactions from December 4, 2021 3 Transaction Time Item Purchased Item Type…
A: Answer is given below-
Q: Nizwa Water distribution company delivers quality water and service to customers. They issue water…
A: Hey there, I am writing the required solution based on the above given question. Please do find the…
Q: bw0s-uit php May 0 May 05 200 10 dA 43 Dele Ve ClNT OHe 0.cas May 05 2020 10031. Delee e So New Fla…
A: I have written HTML Code and CSS code both. I used CSS for the design interface.
Q: containing two table: Passenger and Reservation Passenger Id 301 Name Rima Mazen Nathalie Rabih…
A: SQL query: To find seat number, destination, flight number for each passenger. Query: select…
Q: QTR4 TR3 TRZ TR1 14500 10000 16500 22000 14900 15000 18475 11400 40000 85000 42000 52000 60000 KPT…
A: According to the information given:- We have define brief analysis of the data found in KPT…
Q: Problem 2 Grade Report Student # Student Name Major Course Course Title Instructor Name Instructor…
A: First normal form1NF It states that every attribute must have only atomic values. Multivalued…
Q: An employee has only one job code, but a job code can be held by many employees. ERD
A: ERD :_--
Q: path to al cities stra in the table below. Seattle (0) 207 Boston (6) 1331 Chicago (5) 214 1003…
A: The shortest path from Boston to all other cities
Q: Write a program that allows the user to set the loan amount, loan period, and interest rate, and…
A: Program code: //Import java files import java.awt.*; import java.text.*; import javax.swing.*;…
Q: Given the ODE: =(t-1) cos(y). y(0) = 3 dt Estimate y(1) using midpoint method, h=0.5. Present your…
A: The Answer is:-
Q: The following table represents the hours worked per week for temporary staff at eachbranch of a…
A: Given the following table we have to answers the following questions.
Q: CUST ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP ID 125 Joey…
A: The given table has 11 fields(columns) and 12 records(rows) which is used to store the data of…
Q: O EMPNO ENAME 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 3 7934 MILLER CLERK JOB M... Y…
A: Hey there, I am writing the required solution of the above stated question.Please do find the…
Step by step
Solved in 2 steps
- The following shows a training company’s workshops, the number of days of each, and their registration fees. Workshop # of Days Registration FeeHandling Stress 3 $ 1,000Time Management 2 $ 800Supervision Skills 3 $ 1,200Negotiation 6 $ 1,500Interview Skills 1 $ 300The training company conducts its workplace in the six locations shown in the following table. The table also shows the lodging fees per day at each location. Location Lodging Fees per DayAustin $ 151Chicago $ 225Dallas $ 179Orlando $ 322Phoenix $ 175Raleigh $ 165When a customer registers for a workshop, he or she must pay the registration fee plus the lodging fees for the selected location. For example, here are the charges to attend the Supervision Skills workshop in Orlando. Registration: $1,200Lodging: $322 * 3 days = $966Total: $2,166Create an application that lets the user input a workshop and location from the lists. The application should display the workshop and lodging prices, calculate and display the registration…# Begin constantsCOLUMN_ID = 0COLUMN_NAME = 1COLUMN_HIGHWAY = 2COLUMN_LAT = 3COLUMN_LON = 4COLUMN_YEAR_BUILT = 5COLUMN_LAST_MAJOR_REHAB = 6COLUMN_LAST_MINOR_REHAB = 7COLUMN_NUM_SPANS = 8COLUMN_SPAN_DETAILS = 9COLUMN_DECK_LENGTH = 10COLUMN_LAST_INSPECTED = 11COLUMN_BCI = 12 INDEX_BCI_YEARS = 0INDEX_BCI_SCORES = 1MISSING_BCI = -1.0 EARTH_RADIUS = 6371 # Sample data for docstring examplesdef create_example_bridge_1() -> list:"""Return a bridge in our list-format to use for doctest examples. This bridge is the same as the bridge from row 3 of the dataset.""" return [1, 'Highway 24 Underpass at Highway 403','403', 43.167233, -80.275567, '1965', '2014', '2009', 4,[12.0, 19.0, 21.0, 12.0], 65.0, '04/13/2012',[['2013', '2012', '2011', '2010', '2009', '2008', '2007','2006', '2005', '2004', '2003', '2002', '2001', '2000'],[MISSING_BCI, 72.3, MISSING_BCI, 69.5, MISSING_BCI, 70.0, MISSING_BCI,70.3, MISSING_BCI, 70.5, MISSING_BCI, 70.7, 72.9, MISSING_BCI]]] def create_example_bridge_2() ->…Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’ b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’ c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’ d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’
- Create a list that shows each department name, # of employees, maximum salary, minimum salary, total salary, and standard deviation of the salaries. EMP Table: Field --------------------------------------- EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPT Table: Field ------------------------------- -------- -------------------------------------------------------------------- DEPTNO DNAME LOCin Ms excel, creat a worksheet which include Flower Types (default values: Rose, Carnation, and Statice), Blue Stalks (default values: N/A for Rose and Carnation, 0 for Statice), Pink Stalks (default values: 0 for Rose, Carnation, and Statice), Purple Stalks (default values: N/A for Rose, and 0 for Carnations and Statice), Red Stalks (default values: 0 for Rose and Carnation, and N/A for Statice), White Stalks (default values: 0 for Rose, Carnation, and Statice), and Yellow Stalks (default values: N/A for Rose, and 0 for Carnation and Statice).Given the following relation that stores details of student registration: Stu_ID Name Town Province Course RegisteredDate S101 Malak Al Nadabi Al Khuwair Western ITDR2106 02-02-2020 S101 Malak Al Nadabi Al Khuwair Western ITDR1105 14-09-2019 S102 Nadar Al Hashli Daesit Southern ITDR1102 05-02-2020 S102 Nadar Al Hashli Daesit Southern ITDR1101 05-02-2020 S103 Basit Barkat Ruwi Central ITDR1105 06-02-2020 S104 Yeshan Al Khuwair Western ITDR2106 15-09-2019 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. Stu_ID à Name, Town Town à Province Course à RegisteredDate RegisteredDate à Course Stu_ID, Course à RegisteredDate Stu_ID à Course Stu_ID
- Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00SeriResort has four type of room packages, The rate for each package is shown in the following table: Type of Package Code Rate Per Day (RM) Premium 1 300 Family 2 200 Deluxe 3 150 Standard 4 100 Each guest has to pay 10% SST. The information needed to make a reservation at the resort are the guest’s name, type of package, number of days and type of booking (o – online, M – Manual). A discount of 10% will be given for online booking For each reservation, a receipt must be printed as shown below: SERI RESORT Guest Name xxxxxxxxxxxxxxx Type of Package xxxxxxxxxxxxx Number of Days xx Total Charges (RM) : xxx.xx SST 10% (RM) : xxx.xx Total Payment : xxxxx.xx Draw a flowchart to solve the given.A restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagram
- A local veterinarian hospital keeps record about the different pets they see over time, as well as information about the owners and treatment provided.The following tables represent a sample of the information recorded about owners, pets, and treatments. Owners LastName FirstName Phone Downs Marsha 555-537-8765 James Richard 555-537-7654 Frier Liz 555-537-6543 Pets PetName Type Breed Weight King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes A veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information…A company provides reimbursement of mobile phone subscription charges toits employees belonging to the managerial cadre and above. The following recordstructure captures the details. employee number, which is designated as theprimary key, is a numerical 3-digit key. type refers to a post-paid or pre-paid classof subscription to the mobile service. subscription charges refer to thecharges incurred by the employee at the end of every month.employeenumber designation mobilenumber type SubscriptionchargesFor a sample set of records implement the file asa) an array of records (block size = 1), andb) an array of pointers to records (assume that each pointer to a record is a linkedlist of two nodes, each representing a record. In other words, each block is a linkedlist of two nodes (block size = 2)).draw ERD for these tabels The system must contain tables such as category(catNo,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo),Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity)