Skip to content
  • 0 Votes
    3 Posts
    1k Views
    zaasmiZ
    Graphics library for 64 bit Dev CPP.rar
  • 0 Votes
    5 Posts
    2k Views
    zaasmiZ
    @Faaizaa said in CS614 Assignment 2 Solution and Discussion Spring 2020: Re: CS614 Assignment 2 Solution and Discussion Assignment No. 2 Semester: Spring 2020 CS614 – Data Warehousing Total Marks: 15 Due Date: June 17, 2020 Objectives: After completing this assignment, the students will be able to: • De-Normalize the given table using horizontal splitting technique • Calculate the Total space used with normalization. • Calculate the Total space used after de-normalization. Instructions Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: • Assignment is submitted after due date. • Submitted assignment does not open or file is corrupt. • Assignment is copied (From internet/ to from students). • Assignment is submitted other than word format (.doc, .docx). Assignment Question No. 1 Consider the following table having the information of students of a university: Student ID Student Name Campus ID Student Age Degree Program 1 Ali VLHR01 27 MS 2 Kamran VISB01 24 BS 3 Akmal VRWP01 24 BS 4 Ahmad VLHR01 26 MS 5 Rehan VISB01 23 BS 6 Rizwan VRWP01 29 MS 7 Umer VISB01 25 BS 8 Javed VLHR01 26 MS You are required to completely de-normalize the above table using “horizontal splitting” on the basis of Degree Program. Question No. 2 Consider the following normalized tables for a telecommunication company showing the daily call record details of customers: Customer Info 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 record detail Call_ID Customer_ID Dialled 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. Deadline: Your assignment must be uploaded on VULMS on or before June 17, 2020. While June 18, 2020 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email. Solution file link
  • 0 Votes
    1 Posts
    143 Views
    No one has replied
  • 0 Votes
    1 Posts
    298 Views
    No one has replied
  • 0 Votes
    2 Posts
    1k Views
    zaasmiZ
    [image: FunxESE.png] [image: YiColub.png] [image: 4SPCXOW.png] [image: 5Z2m778.png] [image: kIVrzom.png] [image: MjnmWsS.png] [image: dPRmOjq.png]
  • 0 Votes
    3 Posts
    784 Views
    zaasmiZ
    @zaasmi said in CS408 Assignment 2 Solution and Discussion Spring 2020: Question No. 2 05 Marks Following table consists some scenarios related to Design principles. You are required to write down the design principle related to the particular scenario. S.No. Scenario Design Principle In older version of a work processor, one problem often encounters, when needed to set the properties of a word document, the option of properties should be in the File menu, and often seen it there. But once, file menu opened, it could not show there, it was so confusing. However, when a click on a small arrow at the bottom of file menu, it shows properties option again. In a website or any app. graphical elements like button, icon, links, and scroll bars are talked about obvious use like as icons should be designed to clicking, scroll bars to moving up and down, buttons to pushing. A common design practice in graphical user interfaces is to deactivate certain menu options by shading them, thereby restricting the user to only actions permissible at that stage of the activity. On a computer keyboard, the up and down arrows used to represent the up and down movement of the cursor, respectively. In a graphical user interface, the same input action always done to highlight any graphical object at the interfaces, such as always clicking the left mouse button to select the icons. [image: 4XZ0ezq.png] [image: n55zfc4.png]
  • 0 Votes
    3 Posts
    877 Views
    zaasmiZ
    main.adb with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; with per; use per; with Mn; use Mn; procedure main is -- Creating object of type Men men1 : Men; len: Natural; Begin -- Taking input ID Put_Line("Enter ID : "); Get_Line(men1.ID, len); -- Taking input Name Put_Line("Enter Name : "); Get_Line(men1.Name, len); -- Taking input Gender Put_Line("Enter Gender : "); Get_Line(men1.Gender, len); -- Taking input Height Put_Line("Enter Height : "); Get(men1.Height); -- Taking input Age Put_Line("Enter Age : "); Get(men1.Age); new_line(2); -- Print Function calling print(men1); new_line(3); end main; per.ads package Per is type Person is tagged record Name: String(1..30):= " "; Age: Integer :=0; Gender: String(1..10) := " "; end record; procedure print(Self : in out Person); end Per; main.adb with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; package body Per is procedure print(Self : in out Person) is begin Put_Line("Name is " & Self.Name); Put_Line("Age is " & Integer'Image (Self.Age)); Put_Line("Gender is " & Self.Gender); end print; end Per; mn.ads with per; use per; package Mn is type Men is new Person with record Height: Float := 0.0; ID: String(1..15) := " "; end record; overriding procedure print(Self : in out Men); end Mn; mn.adb with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; with per; use per; package body Mn is procedure print(Self : in out Men) is begin Put_Line("ID is " & Self.ID); Put_Line("Name is " & Self.Name); Put_Line("Age is " & Integer'Image (Self.Age)); Put_Line("Gender is " & Self.Gender); Put_Line("Height is " & Float'Image (Self.Height)); end print; end Mn;
  • 0 Votes
    1 Posts
    317 Views
    No one has replied
  • 0 Votes
    5 Posts
    1k Views
    cyberianC
    @zaasmi said in CS604 Assignment 2 Solution and Discussion Spring 2020: Re: CS604 Assignment 2 Solution and Discussion Operating Systems (CS604) Assignment # 02 Spring 2020 Total marks = 15 Deadline Date 14th June 2020 Please carefully read the following instructions before attempting assignment. RULES FOR MARKING It should be clear that your assignment would not get any credit if:  The assignment is submitted after the due date.  The submitted assignment does not open or file is corrupt.  Strict action will be taken if submitted solution is copied from any other student or from the internet. You should consult the recommended books to clarify your concepts as handouts are not sufficient. You are supposed to submit your assignment in .doc or docx format. Any other formats like scan images, PDF, zip, rar, ppt and bmp etc will not be accepted. Objective: • The objective of this assignment is to learn scheduling algorithm. • To learn and understand different Operating System structure. NOTE No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date. If you find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard. For any query, feel free to email at: cs604@vu.edu.pk Question No 01 15 marks Consider the following set of processes, with the CPU burst time given in milliseconds: Process Burst Time P1 10 P2 1 P3 2 P4 1 P5 5 The processes are arrived in the order P1, P2, P3, P4, P5, all at time 0. A. Draw Gantt chart showing the execution of these processes using FCFS and SJF scheduling. B. Calculate the turnaround time of each process for FCFS scheduling algorithm as per part Calculation of part A? C. Calculate the waiting time of each process for SJF scheduling algorithm as per calculation of Part A? Wish you very Best of Luck! CS604_2_Sol_S20_cyberian.pk_.docx
  • 0 Votes
    2 Posts
    576 Views
    zaasmiZ
    CS001 VU-Computer Proficiency License Assignment 2 Solution & Discussion Spring 2020 CS001 Assignment 2 Solution idea: Computer Proficiency License (CS001) Assignment # 02 Total marks = 15 Deadline Date 15th June 2020 Question No 01 7 marks Suppose you are working as an IT manager in an IT and electronics company; you are required to write a commercial sales letter to one of your customers (Letter format has been well explained through a template/figure below) using Microsoft Word. Consider the following requirements while writing the letter: Insert the system date at the specified location. Insert a permission request for your team for the installation of the network and UPS. Insert a table stating the customer’s complete order details. Solution: Dear Sir, Wednesday,June 10,2020 Thank you for your electronics goods order Sr. No Description Unit Price Quantity Total Price 1 Hp Laptop i7 70,000 10 700,000 2 APCSmart-UPS 1500VA 2U Rack Mount 18,000 2 36,000 Total 736,000 The two person team bearer of this letter is deputed to attend the installattion and networking, work at your premises, kindly extent them necessary and oblige. Your faithfully, Name VU ID IT Manager, XYZ electronics, Rawalpindi. Question No 02 8 marks Write the keyboard shortcut keys for the following actions in Microsoft Word: Solution: Sr. No Action Shortcut key 1 Search a document Ctrl+F 2 Justify a paragraph Ctrl+J 3 Decrease font size Ctrl+[ 4 Bulleted list Ctrl+Shift+L 5 Open the Font dialog box Ctrl+Shift+F 6 Increase font size Ctrl+] 7 Switch to the next window Alt+Tab 8 Insert a copyright symbol Ctrl+Alt+C
  • 0 Votes
    1 Posts
    451 Views
    No one has replied
  • 0 Votes
    2 Posts
    643 Views
    zaasmiZ
    https://www.youtube.com/watch?v=Ydpw1c3SjkI
  • 0 Votes
    1 Posts
    318 Views
    No one has replied
  • 0 Votes
    2 Posts
    620 Views
    Heer NaqviH
    Plz send Cs507 assignment 2
  • 0 Votes
    1 Posts
    627 Views
    No one has replied
  • 0 Votes
    9 Posts
    6k Views
    zaasmiZ
    Cs403 Assignment 2 Solution.docx
How to Build a $1,000/Month PAK VS BAN Live Live Cricket Streaming
File Sharing

0

Online

3.0k

Users

2.8k

Topics

8.2k

Posts
| |