Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

  • Home   /  Question Papers   /  
  • Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data
24
Feb, 2023

Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

Essentials of IT

 
  1. Create a Pivot Table based on the information given in the worksheet which depicts the sales (in thousands) of Haidari ice-cream flavors across cities in the month of April. Create a standalone PivotChart based on the given information. Present the total and sales across the different cities (10 Marks)
 
TABLE BELOW
Flavors 
City A 
City B 
City C 
City C
Butterscotch 
25 
25 
35 
63
Vanilla 
36 
36 
24 
45
Strawberry 
24 
45 
35 
87
Chocolate 
45 
64 
83 
36
Kesar-Pisa 
64 
63 
69 
24
Blackcurrant 
35 
85 
45 
35
Choco-Almond 
85 
69 
87 
85
Tender  
Coconut 
69 
57 
35 
69
Mango 
57 
36 
52 
24
Guava 
63 
24 
45 
45
Kala Jamun 
45 
45 
64 
64
Chicco 
87 
64 
63 
75
  1. Refer to the table below to perform the tasks mentioned below: (10 Marks)
 
a. Use Conditional formatting to highlight the quantity which is greater than 200
b. Use the slicer tool to filter data based on the item weight
c. Use an appropriate text function to combine the first name and the last name and display the results
d. Use the color scale option and format the Item Weight. What does this indicate?
e. Use the strikethrough option ti mark out those dates that are between 07-05-2020 and 14-08-2020
f. Explain the difference between SUM (), SUMIF () and SUMIFS () with an example
REFER TO THE TABLE BELOW
First  
Name
Last  
Name 
Region 
Met Sale  Goal 
Item # 
Quantity
Item  
Weight
Item  
Manufactured  on
Anurag 
Shah 
West 
Yes 
115-74 
15 
8 
07-05-2020
Vedanta 
Patel 
East 
No 
105-70 
958 
7 
15-04-2020
Semithin 
Rastogi 
South 
Yes 
117-74 
22 
10 
14-08-2020
Jaspreet 
Nair 
North 
Yes 
121-49 
69 
12 
30-04-2020
Perak 
Iyer 
West 
Yes 
121-54 
3 
7 
10-05-2020
Keshav 
Hari 
East 
No 
122-71 
71 
10 
02-05-2020
Pavan 
Sathe 
North 
Yes 
120-49 
113 
8 
14-08-2020
Tushar 
Rego 
East 
No 
122-71 
532 
7 
14-08-2020
Shezil 
Malhotra 
North 
Yes 
119-36 
212 
11 
13-04-2020
Hiren 
Bhatia 
West 
No 
107-35 
371 
10 
02-05-2020
Shailendu 
Shroff 
East 
Yes 
104-55 
147 
10 
13-04-2020
Pratik 
Patel 
West 
Yes 
113-65 
79 
8 
10-05-2020
Mihir 
Ashar 
South 
Yes 
104-36 
48 
8 
14-08-2020
Utkarsh 
Chajjed 
North 
Yes 
114-68 
78 
12 
23-04-2020
Jigar 
Nath 
West 
No 
120-37 
54 
8 
17-04-2020
  1. Answer the questions that follow:
  2. Explain the difference between data and information. Explain the need for databases.  What are the advantages of using Database Management Systems (DBMS) to manage data? (5 Marks) 
  3. Write a note on Database Languages that are used to perform different types of operations on an existing database (5 Marks)

Narsee Monjee Assignments April,May 2023-Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

Explain the difference between data and information. Explain the need for databases. What are the advantages of using Database Management Systems (DBMS) to manage data

Welcome to Case Study Help

We at Case Study offer all types of online academic assistance, be it homework help, coursework help, case study help, Assignment help, Project Reports, Thesis, Research paper writing help.
And for each service, each subject and each topic, we dedicate an expert writer who has knowledge in that specific field of study. Experience impeccable academic writing service like never before.
Our experts understand that the time of the customers is very precious. The professors of universities and colleges are very rigorous about the submission deadlines of projects or assignments. Hence, the key objective of our case study help service is to deliver the assignments to the customers even before the promised submission deadlines.
We keep the quality measures for all papers which mean we will provide best essays. Our editing services are also excellent. Before submitting any essays, we will check whether the papers writer well or not. The high standards of academic writing will exceed your expectations. With our quality service, we have satisfied more number of people across the world and also work with different universities in Australia, UK, USA, Dubai, Oman, etc.

info@casestudyhelp.in

info.casestudyhelp@gmail.com

https://www.casestudyhelp.in

+91-9902787224

Leave a Reply

Your email address will not be published. Required fields are marked *