corporate profits sum The sales purchases experses profit 4% tax I profit all compares) 1000 5000 8000 68000 77500 8000 75000 90000 3000 2000 19500 1500 19500 5 Isra 3 2700 53200| 48500 | nouns 4 12000 19500 480 6. 2000 19500 7 5 right | 66000 76000 8000 2000 19500 8 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4%*: we use the following equation 2 To find the total profit for all companies we use *: the following function =480*4% 3 =SUM(G1:65) = 12000/100*4 SAM(G3:G7) =12000/0.04 all mentioned O =SUM(G3:G7) =480*0.04 O =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned

corporate profits sum The sales purchases experses profit 4% tax I profit all compares) 1000 5000 8000 68000 77500 8000 75000 90000 3000 2000 19500 1500 19500 5 Isra 3 2700 53200| 48500 | nouns 4 12000 19500 480 6. 2000 19500 7 5 right | 66000 76000 8000 2000 19500 8 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4%: we use the following equation 2 To find the total profit for all companies we use : the following function =4804% 3 =SUM(G1:65) = 12000/1004 SAM(G3:G7) =12000/0.04 all mentioned O =SUM(G3:G7) =480*0.04 O =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter7: Knowledge Management And Specialized Information Systems

Section: Chapter Questions

Problem 8SAT

See similar textbooks

Similar questions

Asiacell l. docs.google.com Float Integer Piece of sentense Symbol table is used Table for tokens Array for only integer O Table consist of only identifier The Symbol || is used for Get the Letters Get the String 24
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))
remove the value user inputted only not the key example Firstname [firstname]: John Middlename [middlename]: George Lastname [lastname]: Doe A for ADD D for DELETE Any key for END when enter 'D' lastname Firstname [firstname]: John Middlename [middlename]: George Lastname [lastname]: A for ADD D for DELETE Any key for END only the inputted will be remove not together the lastname names = {"firstname":"","middlename":"","lastname":""} choice = "A"while choice == "A" or choice == "D":print("\n\t A for ADD\n\t D for DELETE\n\t Any key for END")choice = input("\n\t Your choice: ")for k,v in names.items():print("\n\t "+k.capitalize()+" ["+k+"] : "+v)if choice == "A":key = input("\n\t Enter key: ")value = input("\n\t Enter value: ")names.update({key:value})for k,v in names.items():print("\n\t "+k.capitalize()+" ["+k+"] : "+v)elif choice == "D":delete_key = input("\n\t Enter key: ")names.pop(delete_key)for k,v in names.items():print("\n\t "+k.capitalize()+" ["+k+"] : "+v)else:print("\n\t…
Mattings View Tell me what you w to do 165 M- AlloCel AaBbCd AaBbC AaBbce AaB ABCD ABOCED A08bCD AaBbCcD ABBCCD AnBbCcl B 1 Normal No low eping ding 1 Tile Suositte Subia Em Loginsess Qu 1 Q1) If y₁ =sin(x), y2 = cos(x), y₁ = tan(x), where -
Sheet1 Sheet2 Sheet3 A В C D F K TABLE FOR EMPLOYEE SALARY 4 EMP ID EMP NAME TOTAL SALARY TAX1 TAX2 NET SALARY notes 1 TAYSEER 850 tax1 = 10% from total salary 6. 2 SARA 450 7 3 SAMAH 700 tax2= 5% from total salary if its =700 8. 4 МОНАММAD 350 9. 5 KHALED 1200 10 6 ALI 1000 11 SAMI 670 12 13 MAXIMUM NET SALARY 14 MINIMUM NET SALARY 15 insert a chart between EMP NAME and NET SALARY SUM OF THE NET SALARIES 16 AVERAGE OF THE NET SALARIES 17 SUM OF THE TOTAL SALARIES 18 10 2 3
credits Q3: Normalize the following table, given 1NF, 2NF and BCNF: Module Dept Lecturer Texts M1 D1 L1 T1,T2 M2 D1 L1 T1,T3 M3 D1 L2 T4 M4 D2 L3 T1,T5 M5 D2 L4 T6
Table 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…
ISOCode2 BS KE ML BT ΝΑ Country Name Bahamas Kenya Mali Bhutan Namibia Area1 400 44000 377000 3000 NULL Area2 3500 176000 NULL NULL NULL SELECT MAX(Areal) + MAX (Area2) SELECT MAX (Area1 + Area2) FROM Country; FROM Country; Enter the result: Ex: 12345 Enter the result: Ex: 12345
SUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 222
PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODE
STUDENT MARKS Stud id Stud Gender SQL name WebAppDev Math IT Stud Section 46J12035 Azhila 78 59 89 46S11114 Sulthan 88 78 87 46J21113 Rashid 67 69 71 1 46J22145 Mahmood 77 76 79 46S11111 Moosa 69 71 72 46S21456 Mohammed 86 78 91 1 46J14569 Reshma F 76 86 77 2. 46J24689 Fatma F 88 86 81 46J13564 Amani F 79 89 88 1 46J12456 Noor F 78 79 76 2. 1-Find out Stud section, average of SQL, average of WebAppDev, average of Math ITgroup by section?
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)