• ### STA301 Assignment 2 Solution and Discussion

STA301 - Statistics and Probability
2

@ghulam-hassnain said in STA301 Assignment 2 Solution and Discussion:

STA301 Assignment 2 Solution 2021.docx

• ### STA642 Assignment 2 Solution and Discussion

STA642 - Probability Distributions
1
No one has replied
• ### CS201 Assignment 2 Solution and Discussion

Solved CS201 - Introduction to Programming
4
• ### MTH101 Assignment 2 Solution and Discussion

MTH101 - Calculus And Analytical Geometry
8
• ### Edu 406

EDU406 - Critical Thinking and reflective Practice
2

https://cyberian.pk/topic/1126/edu406-assignment-2-solution-and-discussion

• ### MTH603 Assignment 2 Solution and Discussion

MTH603 - Numerical Analysis
4

Solution idea

• ### CS614 Assignment No.2 Solution and Discussion

CS614 - Data Warehousing
4

@zareen said in CS614 Assignment No.2 Solution and Discussion:

Question No. 2
Consider the following normalized tables for a telecommunication company showing the daily call record details of customers:
Customer_ID Customer Phone No. Balance
1 033XXXXX 300
2 033YYYYY 250
3 033ZZZZZZ 300
4 033AAAAA 1000
5 033BBBBB 80
6 033CCCCC 554

… …

Call_ID Customer_ID Dialed Phone Number Duration Call Charges
1 1 032ABCVD 1 minute 2 RS
2 1 032ABCVG 2 minutes 4 RS
3 1 032ABCVD 1 minute 2 RS
4 2 032ANNNN 3 minutes 6 RS
5 2 032AMMM 4 minutes 8 RS
6 3 033RRRRR 1 minute 2 RS
… … … … …

Due to certain performance factors company wants to de-normalize the tables using pre-joining technique.
Table Information is given below:
• Assume 1:4 record count ratio between customer Info (master) and Call record detail (detail).
• Assume 15 million customers.
• Assume 10 byte Customer_ID.
• Assume 50 byte header for customer Info (master) and 80 byte header for Call record detail (detail) tables.
You are required to perform the following tasks:
• Calculate the Total space in GBs used with normalization.
• Calculate the Total space in GBs used after de-normalization.

Solution:
With normalization:
Total space used = 15 x 50 + 60 x 80 = 5.55 GB

After de-normalization:
Total space used = (80 + 50 – 10) x 60 = 7.2 GB

• ### CS606 Assignment 2 Solution and Discussion

CS606 - Compiler Construction
3

@zareen said in CS606 Assignment 2 Solution and Discussion:

Assignment Marks 20
Question:
X -> aZ
X -> c
Y -> bX
Z -> Ya
Z -> XbY
a) Find First sets for above grammar. (10 Marks)
b) Find Follow sets for above grammar. (10 Marks)

Solution:

a) Find First sets for above grammar. (10 Marks)

First (X)= a, c
First (Y)= b
First (Z)= a, b, c

b) Find Follow sets for above grammar. (10 Marks)

Follow(Z)= a, b, \$

• ### PHY301 Assignment 2 Solution and Discussion

Solved PHY301 - Circuit Theory
3

@zareen said in PHY301 Assignment 2 Solution and Discussion:

Label and identify meshes in given below circuit. Use Loop/Mesh analysis to find currents through all Meshes.

• ### CS409 Assignment 2 Solution and Discussion

CS409 - Introduction to Database Administration
9

@zareen said in CS409 Assignment 2 Solution and Discussion:

Consider the given below the ERD

b715a3fa-af52-42a4-ac14-a1726d7469d4-image.png

• ### CS402 Assignment 2 Solution and Discussion

Solved CS402 - Theory of Automata
3

Develop a program that calculates Loan in C++. Your program should satisfy the following requirement:
User Input:
1 User is asked to enter name.
2 User is asked to enter number of dependent with range (0-5).
3 User is asked to enter status i.e. (Permanent or Probation).
4 User is asked to enter Salary.
5 User is asked to enter Duration at Job (in years):
o <1
o 1-2
o 2-4
o 4-7
o >7
6 User is asked how much loan is required.

Criteria:
 Loan can be given if and only if a person is on Permanent job for more than 1 years.
 Minimum salary from which a loan can be given is 35,000 per month for a person having no
dependent. Minimum salary requirement increases by 20,000 per dependent.
 If years of services is from 1 to 2 years, then max loan amount can be up to 6 salaries.
 If years of services is from 2 to 4 years, then max loan amount can be up to 8 salaries.
 If years of services is from 4 to 7 years, then max loan amount can be up to 10 salaries.
 If years of services is from 7 to 10 years, then max loan amount can be up to 12 salaries.
 If years of services is more than 10 years, then max loan amount can be up to 24 salaries.
 Add 13% interest on the approved loan amount. This amount will be payable within 8 years’
time i.e. 96 months.
 If the money to lend is more than the lend amount, then calculate the difference and show it
properly.
 For unsuccessful Loan Application: Show Message: “CUSTOMER NAME, your lend
application has not been successful this time”.
 For Successful Loan Application: Show Message: “Congratulations CUSTOMER NAME, your
lend application is successful this time. Your monthly installment will be ______ Amount
Payable for 96 months”.

• ### CS702 Assignment 2 Solution and Discussion

CS702 - Advanced Algorithms Analysis and Design
2

• ### CS405 Assignment 2 Solution and Discussion

CS405 - Database Programming using Oracle 11g
2

• ### IT430 Assignment 2 Solution and Discussion

IT430 - E-Commerce
2

• ### CS603 Assignment No. 2 Solution and Discussion

CS603 - Software Architecture and Design
2

@zaasmi sir plz solution bta dyn stat404 k

• ### CS441 Assignment 2 Solution and Discussion

CS441 - Big Data Concepts
2

Pease star idea solution