Question:Q1. A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid-19 lockdown the respective shops recorded sales as follows:High Street BranchQuarterQ1Q2Q3Sales48,000 50,00058,000 | 60,00049,000 58,00051,000 61,00042,00052,00046,00050,000Q4Mall BranchQuarterQ1Q2Sales63,000 60,00067,000 72,00065,000 62,00069,000 75,00057,00070,000Q3Q467,00072,000As a programmer hired by the shops' owner, write a java program to calculate:(a) the monthly combine sales figures for both shops;(b) the respective shops annual sales figures;(c) the grand annual combine total sales figures.Note: Your program must be implemented with arrays.

Answered: Q1. A shop owner has 2 outlets namely a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

(d) A sample of 800 workers indicated whether they are single or married and whether they work morning shift, afternoon shift, or night shift. The information obtained appears in the following two-way classification table. Marital status Single Married Morning 160 360 Afternoon 60 100 Work shift Night 80 40 (i) Explain the following terms based on 2(c) above. ORC: ERC :
Answer 5-10
1. The Database contains 4 transactions. Find the association rules exact from these set using Apriori, assume the minimum support is 60% and minimum confidence is 80% Transaction ID Item Bought 001 K, A, D, B 002 D, A, C, E, B 003 C, A, B, E 004 B, A, D a) Make Tabular Binary Representation b) Find Frequent item set using Support For 1-item set For 2-item set For 3-item set c) Extract rules and calculate their confidence
Using C. This question deals with processing the semi-annual sales for a drug store. The drug storesells four types of items, namely Cosmetics, Drugs, Stationery, and Confectionery. You havebeen presented with the following set of data which shows sales for the January to June periodfor the various item types. Item Type January February March April May June Cosmetics 8723.19 7397.21 5982.15 8319.54 7298.31 7490.02 Drugs 9384.12 9740.98 8940.34 8876.34 7093.23 9830.11 Stationery 938.25 834.98 976.29 994.56 912.05 849.12 Confectionery 1832.65 972.34 983.65 1289.28 1197.30 989.41 Your job is to develop a program which accepts as inputs the above sales figures and whichdetermines the total sales for the six month period in each category as well as average monthlysales in each category. In addition, your program should also determine the total sales for eachmonth. Your program should produce as output a report with the following format:
4. Suppose a company has employee annual salary data as follows. - For the interval $\$ 1$ to $\$ 25,000,5$ employees; for the interval $\$ 25,001$ to $\$ 50,000,15$ employecs; for the interval $\$ 50,001$ to $\$ 75,000, 25$ cmployees; - for the interval $\$ 75,001s to $\$ 100,000,25$ employecs; - for the interval $\$ 100, 001$ to $\$ 125,000, 35$ employees; - and for the interval $\$ 125,001$ to $\$ 150,000,30$ employees. (a) Which direction, if any, is this data skcwed? [Hint: Draw a graph of the distribution. Sec if that gives you an insight.] (b) Which is likely larger for this dataset, the mean or the median? S.P.PB. 251
The questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…
Q.4 Consider the below two tables STUDENT EMPLOYEE STUDENT_ID STUDENT NAME EMPLOYEE_ID ΕMPLOYΕE NAME 1001 A 1001 1002 1002 1003 C 1003 D 1004 1004 E 1005 E 1005 Give output for the following given relational algebra expression I. I Istudent_id (Ostudent_name='C' and (Ostudent_id=1001 (STUDENT)) UTlemployee_id (Oemployee_name='E' (EMPLOYEE)) II. I lstudent_id,student_name (STUDENT) OIlemployee_id, employee_name (EMPLOYEE) III. Ilemployee_name (Oemployee_name 'B' (EMPLOYEE)) - IIstudent_name (Ostudent_id >1003 (STUDENT)) IV. IIstudent_id, student_name (Ostudent_id=1001 (STUDENT)) * Oemployee_name 'B' (EMPLOYEE) V. STUDENT U EMPLOYEE
Normalize the following table, given 1NF, 2NF and BCNF: 2nd Teacher Students School Group А, В Subject Name 1st Teacher Class Arabic Lang Ali Ahmed 6th 50 Markazia Islamic Edu Ahmed Ali 5th B. 45 Markazia
344 Q2 (No HANDWRITING):
Q.1 Convert following table in third normal form called: ACCOUNT AND TRANSACTION and establish constraints Account No varchar(20) Name varchar(50) City varchar(50) SSN varchar(10) State char(2) Country varchar(20) Transaction No int Transaction Date datetime Debt numeric(16,2) Credit numeric(16,2) Balance numeric(16,2)
Consider these factors while determining the sentinel value you want to use.

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS