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
- Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech levelTable name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…Use the university schema for the following questions student takes ID ID course id sec id name dept_name tot ged semester vear grade section course course id sec id department course id advisor title dept_name credits dept name s id semester Year building room number time slot id building budget time_slot time slot id day start time end time prereq instructor classroom couTse id grereg id ID building room_number name dept_name salary сараcity teaches ID course id sec id semester year Figure 2.9 Schema diagram for the university database. Use the online SQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL statement under each question and upload the document to Canvas. 1. Display the name and total institution credits taken (not tot_cred which includes transfer credits) of students that do not have an assigned advisor (across all years). a. Hint: link takes with courses and student, for students not in advisor, project the name…
- The State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalitiesUse the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'
- The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 600 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation() to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and…Guest House Paradiso The Guest House Paradiso used to be a splendid place to stay. But things haven't been updated in a while. Including the way that room bookings are recorded. At the moment they're recorded in a spreadsheet like this: Bookings Table Room Number Number of Nights Arrival Date Departure Date Guest Last Name Guest Phone Number Optional Extras 203 Mar 18 2022 Mar 20 2022 Howard 555-2381 bug-free bed 101 Mar 18 2022 Mar 21 2022 3 Gallagher 555-3619 clean towels, hot water 302 Mar 18 2022 Mar 19 2022 1 Mortimer 555-0856 bug-free bed, clean towels 103 Mar 18 2022 Mar 23 2022 5 McQueen 557-2428 hot water ... 203 Mar 20 2022 Mar 23 2022 3 Carraclough 554-8652 clean towels, hot water Optional Extras There are three types of 'Optional Extras' available in all rooms, and guests can order any combination of these: • hot water • bug-free bed • clean towels NOTE: For this scenario we will assume that a guest's phone number never changes and is unique.The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique firefighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieutenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervisors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.
- Table EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))Alreej College Computer Application Student Name Student_ID Math En Ahmed Omar Huda 20f20 45 10 35 20f21 50 45 45 Muhmmed 20f22 20f23 20f24 20f25 46 20 50 Amira 50 35 50 Huda Ahemd 20 50 33 Noora Ali 33 45 46 Figure-1 1) Prepare and format your MS-Excel Document as shown above. 2) The total number of student marks for each Module during the semester needs to be calculated. Explain how you will do it. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations. 3) Explain how you will calculate the Average for each students. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations.