Please post your questions here https://cyberian.pk/topic/1126/edu406-assignment-2-solution-and-discussion

Solution idea

@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

@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 (X)= a, b, $ Follow (Y)= a, b, $ Follow(Z)= a, b, $

@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.

@zareen said in CS409 Assignment 2 Solution and Discussion: Consider the given below the ERD

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”.

Please share idea

Please share idea

Please share idea solution

@zaasmi sir plz solution bta dyn stat404 k

Pease star idea solution

Please share idea

@zaasmi said in CS312 Assignment 2 Solution and Discussion: In continuation of assignment 1 of CS312, by using system requirements, we identified following entities in the system under observation; Admin / Owner Tour Plan Sites Activity Visitor Guide By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side that would result in deduction of marks. So, your Task is to; TASK: [Marks = 10 + 10 = 20] Draw ER diagram containing entities, assumed attributes and cardinalities between these entities.

#include<iostream> using namespace std; class Question { private : int QuestionID; string QuestionType; int QuestionMarks; public : Question() { cout<<"Enter Question ID : "; cin>>QuestionID; cout<<"Enter Question Type : "; cin>>QuestionType; cout<<"Enter Question Marks : "; cin>>QuestionMarks; } void setQueID(int id) { QuestionID=id; } void setQueType(string type) { QuestionType=type; } void setQueMarks(int marks) { QuestionMarks=marks; } int getQueID() const { return QuestionID; } string getQueType() const { return QuestionType; } int getQueMarks() const { return QuestionMarks; } }; class Exam { private : string ExamType; string CourseCode; static const int NoOfQuestions=2; Question *questions[NoOfQuestions]; public : Exam(string EType, string CCode) { ExamType=EType; CourseCode=CCode; for(int i=0; i<NoOfQuestions; i++) { cout<<"\n***** Enter Data of Question No. "<<i+1<<" *****\n"; questions[i] = new Question(); } } void DisplayInfo() { cout<<"----------------------------\n"; cout<<"**** Displaying Exam Information ****"; cout<<"\n----------------------------"; cout<<"\nExam Type : "<<ExamType; cout<<"\nCourse Code : "<<CourseCode; cout<<"\nTotal No of Questions for Exam : "<<NoOfQuestions; cout<<"\n----------------------------\n"; cout<<"**** Displaying Question Information ****"; cout<<"\n----------------------------"; for(int i=0; i<NoOfQuestions; i++) { cout<<"\nQuestion No. : "<<i+1; cout<<"\nQuestion Id : "<<questions[i]->getQueID(); cout<<"\nQuestion Type : "<<questions[i]->getQueType(); cout<<"\nQuestion Marks : "<<questions[i]->getQueMarks(); cout<<"\n----------------------------"; } } }; main() { cout<<"\n\t\tCS304 Assignment No. 2 Solution \n"; cout<<"\nPlease Subscribe Cyberian Youtube Channel to get Solutions of all Programming Assignments\n\n"; string type, code; cout<<"Enter Exam Type : "; getline(cin, type); cout<<"Enter Course Code : "; getline(cin, code); Exam exm1(type,code); exm1.DisplayInfo(); }