Thursday, 21 January 2021

CS614-Data Warehousing Quiz MCQs Lecture 23-45 Finalterm Objective Questions | SUPERSTARWEBTECH



CS614-Data Warehousing Quiz MCQS #Objective #Questions #FinalTerm

1. Which of the following is NOT one of the variants of Nested-loop join?
2. ___ lists each term in the collection only once and then shows a list of all the documents that contain the given term
3. The optimizer uses a hash join to join two tables if they are joined using a equijoin and 
4. In nested-loop join case, if there are 'M' rows in outer table 'N' rows in inner table, time complexity is 
  • O (M log N)
  • O (log MN)
  • O (MN)
  • O (M + N)

Monday, 18 January 2021

MGT610-Buisness Ethics Quiz MCQs Lecture 23-45 Finalterm Objective Questions | SUPERSTARWEBTECH



MGT610-Buisness Ethics Quiz MCQS #Objective #Questions #FinalTerm

1. The antitrust view is based on a number of assumptions. Who has summarized the basic propositions this traditional view is based on?
2. Which of the following view argues that prices nd profits in highly concentrated industries are higher than they should be?
3. Water pollution comes from all except?
4. Fossil fuels include all except?
  • Oil
  • Coal
  • Wind
  • Natural gas
5. Which of the following is TRUE regarding acid rain?
6. Which of the following statement is TRUE?
7. Which of the following refers to the saving or rationing of natural resources for later use?
8. Which of the following views claims that the power of oligopolies is not as large as it appears?
9. How much pounds of plutonium waste has been produced by each nuclear reactor every year?
  • 255
  • 260
  • 265
  • 275
10. Resource depletion may be in any form except?

Thursday, 7 January 2021

CS619 Final Project Phase 1 Gathering and Analysis Requirements | How to make SRS? | System Requirements Specifications (SRS) | SSWT

 Dear Students!

In this post you will learn How to make SRS document? for your final project CS619. As we know that the students of BSCS/BSSE/BSIT in 7th/8th Semester and MIT/MSCS in 3rd/4th Semester have to select CS619 Project. This project is a must to get Degree. It carries 6 credit hours. So, here we will guide you about the first step of CS619 Project i.e. Gathering and Analysis Requirements.



PHASE-1 Gathering and Analysis Requirements

In this phase you are required to make SRS Document.

What is SRS?


SRS stands for Software Requirements Specification. It is a detailed document that tells about how the system is expected to perform. In this document, following topics are covered:
  • Scope of the Project
  • Software Requirements
    •   Functional requirements
    •   Non-Functional requirements
  • Use Case Diagram
  • Usage Scenarios
  • Adopted Methodology
  • Work Plan
Now let's discuss them one by one in detail.

    Scope of the Project


    What is scope?

    The scope of the project defines the necessary information required to start a project. It basically answers to the following questions:
    • What are the needs?
    • What is your goal?
    • How the system will fulfill the user needs?
    • Why user should use this system?

    For example:

    Here is an example of scope of the project: An online departmental store.
    👉 Click here to download the project file: Cash and Carry online Departmental Store

    "Cash & Carry is an Online Departmental Store where people will be offered with a wide range of both grocery and non-grocery items to buy online. It offers items to residents located anywhere in Pakistan. This store is being developed to help users to explore their daily, weekly or monthly required items. The payment gateway methods are easypaisa or cash on Delivery.

    In this project, our goal is to facilitate the users to buy grocery and non-grocery items at the ease of their home. The users will interact with our store through Website. Cash & Carry Online Store System is built in the form of Web Application which includes User registration/login system, search system, information flow charts, administration module, payment gateways etc. When the user makes a transaction and purchases an item from this store, he/she will receive items at his/her doorstep along with an invoice.

    Moreover, this system acts as power up approach for people. And also, time saving. As some people like working women/men and old age persons might not be able to go out due to some reasons like tiredness, illness or time constraint. So, Cash & Carry Online Departmental Store plays a significant Role in the life of people whether it’s a man, a woman, a student, or an elderly."

    💡 Tip: Don't need to add history and philosophy. Just write the specific content only in your own words. 

    Software Requirements


    Here you will write the functional and non-functional requirements in detail.

    Functional Requirements:

    The functional requirements state: “What a system must do?”. Their emphasis is on the user requirements. They fulfill the users desired tasks. These must be put into the system by the developers to meet users’ requirements. 

    For example:

    This example is related to the above mentioned sample project.

    GUI
    The user interface will be simple enough to navigate easily. It will contain only two broad main categories Grocery and Non-grocery items on the home page with other tools like search, add to cart, login/signup buttons, FAQ and information flow charts links etc. 

    Registration
    The customers can register themselves into our system and then login to place order. Registration is mandatory to buy and pay for the items. 

    💡 Tip: You should write all the required functionalities of your project. There may be more than these like: Search, Order Track, Save Selection etc.

    Non-Functional Requirements:

    The non-functional requirements describe: “How a system should behave?”. They specify characteristics of the system.

    For example:

    This example is related to the above mentioned sample project.

    Usability
    The usability is a key factor to facilitate the user. The system must provide a user-friendly environment to its customers. To interact with the user, system should give a proper list of categories for the user to search their required items.

    Security
    To ensure that the user’s information is safe, the system should protect the user’s data. It must refrain the hackers to unauthorized access. The system must use specific standards to secure it from malware attacks and unauthorized access.

    💡 Tip: You should write all the required non-functionalities of your project. There may be more than these like: Accuracy, Reliability, Performance etc.

    Use Case Diagram


    What is Use Case?

    A Unified Modeling Language which represents the interaction between the user and the system. It shows the relationship that exists between the system and the user. The user/actor is involved in different use cases like: login, registration, search, add to cart etc. 

    For example:

    Here is an example Use case diagram of the departmental store 


    Click here to learn more on: How to make Use Case Diagram? 

    Usage Scenarios


    What are usage scenarios?

    They describe the events/actions that occur when the user interacts with the system. They show the real world example that how the people or users interact with the system, What actions do they perform?, What are the conditions?, What will be the exceptions if the action does not meet the desired conditions?

    So here in this section you are required to write the usage scenarios of all cases in the table format which explains:
    • Use Case title
    • Use Case Id
    • Actions Description
    • Alternative Path
    • Pre-conditions
    • Author
    • Exceptions
    • Post-conditions
    You are supposed to provide usage scenario for each use case present in your use case diagram. So basically it explains each use case in detail.

    For example:

    Here is a sample of Usage Scenario from the Online Departmental Store Project.

    Use Case Title

    Register

    Use Case Id

    UC 1.1

    Actions

    A registration Page will open

    Description: A user can register themselves by providing his/her information like: Name, Username, Email, Phone Number, Address, and Password.

    Alternative Path: The user must register to place an order and add items to cart.

    Pre-conditions: The system should provide a proper form for user to fill their required information.

    Author

    Exceptions

    Unregistered User

    If the user leaves any field empty or inputs wrong email/phone number or the inserted password does not match the requirements then user registration will not take place.

    Post Conditions: A success message should be displayed on successful registration.


    🖉 Note: This is only one scenario from the use case diagram. You have to write scenarios for each use case present in the Use case Diagram.

    Adopted Methodology


    Here you will write in detail about which Software Development Lifecycle SDLC Model you adopted for this project. In short you will write about Waterfall Model and Spiral Model with diagrams. And then you will write VU Process Model which is a combination of Waterfall Model and Spiral Model proposed by Virtual University of Pakistan.

    Waterfall Model

    What is waterfall model?

    Waterfall model is a SDLC approach used to make a linear system sequentially. It was the very first process model. This model divides the software development life cycle into different steps or phases. Each phase has its responsibilities and different objectives. This model is unidirectional. Each phase is dependent on the deliverables of the previous phase. The consequences of one phase are the inputs for the next phase. The main advantage of this model is that it is easy to understand and use. It is best for small projects when requirements are known. But there is high amount of risk of waterfall model and it is not suitable for the projects that have changing requirements.




    Spiral Model

    What is Spiral Model?

    The spiral model is a SDLC risk-driven method. It combines the iterative models with elements of Waterfall model. The model works well for large projects. In this model each next stage is link to the previous so commutation flow can go in both directions and if changes come then they can easily be adjusted. This guarantees that there is no conflict with the previous requirements.


    VU Process Model

    What is VU Process Model?

    VU process model is called hybrid approach of website development. It is the combination of both waterfall and spiral model. This model is easy to understand. It is proposed by Virtual University of Pakistan. This model will maximize the quality of the website and reduce the risk because waterfall avoid overlapping which makes it easy to understand and spiral uses for critical projects. We need both functionalities for our project so that’s why we use VU process model because it’s a combination of both spiral and waterfall process Models.



    Work Plan


    Here you will provide Gantt chart of your final project. 

    What is Gantt Chart?

    It is a type of horizontal bar chart which tells the timeline of the project. It shows the starting and finishing time of your project phases. See below to get an idea.

    For example:



    We hope you understood these concept clearly. Feel free to ask any question. 

    You can contact us on:
    or 

    Thursday, 31 December 2020

    CS614-Data Warehousing Quiz MCQs Lecture 1-22 Midterm Objective Questions | SUPERSTARWEBTECH



    CS614-Data Warehousing Quiz MCQS #Objective #Questions #MidTerm

    1. Data warehouse stores ___
    2. The ___ dimension represents data correctness
    3. Which of the following is not a Data Quality Validation Technique?
    • Referential Integrity
    • Using Data Quality Rules
    • Data Histograming
    • Indexes
    4. Which of the following is an example of Non-Additive Facts?
    5. Which is the most complex type of transformation in the following?
    6. Serious ___ involves decomposing and reassembling the data
    7. ___ is the degree of utility and value the data has to support the enterprise processes that enable accomplishing enterprise objectives
    8. In a decision support system ease of use is achieved by:
    9. Assume a company with a multi-million row customer table i.e. n rows. Checking for Referential Integrity (RI), using a smart technique with some kind of tree data structure would require ___ time
    10. Which of the following is NOT an example of a typical grain?
    11. Most DWH implementations today do not use ___ enforced by the database, but as TQM methods improve overall data quality and database optimizers
    12. Suppose in system A, the possible values of "Gender" attribute were "Male" & "Female", however in data warehouse, the values stored were "M" for male and "F" for female. The above scenario is an example of:
    13. Development of data warehouse is hard because data sources are usually ___
    14. A/an ___ is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension
    • Junk dimension
    • Slowly changing dimension
    • Multi-valued dimension
    • Simple dimensions
    15. ROLAP provides access to information via a relational database using
    16. The typical availability of OLTP system is 24/7, while that of data warehouse is ___
    • 6/12
    • 7/12
    • 1/24
    • Twice a week
    17. In ___ nested-loop join of quadratic time complexity does not hurt the performance
    18. If actual data structure does not conform to documented formats then it is called:
    19. Which of the following is not a CUBE operation?
    20. The data has to be checked, cleansed and transformed into a ___ format to allow easy and fast access
    • unified
    • predicted
    • qualified
    • proactive
    21. Which is not a/an characteristics of data quality?
    22. The extent to which data is in appropriate languages, symbols, and units, and the definitions are clear is known as ___
    23. In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called
    • Ranking
    • Prioritization
    • Element Selection
    • Measurement Selection
    24. In OLTP environments, the size of tables is relatively ___
    • Large
    • Fixed
    • Moderate
    • Small
    25. Change Data Capture (CDC) can be challenging task because
    26. ___ is the extent to which data is regarded as true and credible
    27. The relation R will be in 2nd Normal Form if 
    28. ___ is the degree to which data accurately reflects the real-world object that the data represents
    29. Web scrapping is a process of applying ___ techniques to the web
    30. In which class of aggregates AVERAGE function can be placed?
    31. Which of the following is not an "Orr's Law of Data Quality"?
    32. The ___ operator proves useful in more complex metrics applicable to the dimensions of timeliness and accessibility
    • Max
    • Min
    • Min or Max
    • None
    33. Which is not a/an Data Quality Validation Technique?
    34. Assume a company with a multi-million row customer table i.e. n rows. Checking for Referential Integrity (RI) using a naïve approach would take ___ time.
    • O(n)
    • O(1)
    • O(log n)
    • None

    Sunday, 27 December 2020

    MTH603-Numerical Analysis Quiz MCQs Lecture 1-22 Midterm Objective Questions | SUPERSTARWEBTECH



    MTH603-Numerical Analysis Quiz MCQS #Objective #Questions #MidTerm

    1. If n x n matrices A and B are similar, then they have the ___ eigenvalues (with the same multiplicities)
    • same ✔
    • different
    2. If the product of two matrices is an identity matrices that is AB = I, then which of the following is true?
    • A is transpose of B
    • A is inverse of B ✔
    • A is singular
    • B is singular
    3. Iterative algorithms can be more rapid than direct methods.
    • False 
    • True ✔
    4. While using Relaxation method, which of the following is the largest Residual for 1st iteration on the system; 2x + 3y = 1, 3x + 2y = -4?
    • -4 ✔
    • 3
    • 2
    • 1
    5. Which of the following systems of linear equations has a strictly diagonally dominant coefficient matrix?
    • -2x+7x+2x=5, 6x-2x+3x=1, x+x-5x=-13
    • -2x+7x+2x=5, 6x-2x+3x=1, x+x-5x=-13
    • x+x-5x=-13, 6x-2x+3x=1, -2x+7x+2x=5
    • 6x-2x+3x=1, -2x+7x+2x=5, x+x-5x=-13 
    6. In the context of Jacobi's method for finding Eigen values and Eigen vectors of a real symmetric matrix of order 2*2, if |-5| be its largest off-diagonal then which of the following will be its corresponding off-diagonal values of Orthogonal Matrix?
    • Cos(theta), -Cos(theta) 
    • Sin(theta), Cos(theta)
    • Sin(theta), -Sin(theta)
    • -Sin(theta), Cos(theta)
    7. While using power method, from the resultant normalize vector
    8. Every non-zero vector x is an eigenvector of the identity matrix with Eigen value___
    • one
    • two
    • three
    • four
    9. Which of the following systems of linear equations has a strictly diagonally coefficient matrix?
    • -x+12x+5x=8, 9x+5x-3x=12, 2x-4x+7x=-15
    • 9x+5x-3x=12, -x+12x+5x=8, 2x-4x+7x=-15
    • 2x-4x+7x=-15, -x+12x+5x=8, 9x+5x-3x=12
    • 9x+5x-3x=12, 2x-4x+7x=-15, -x+12x+5x=8
    10. Let[A] be a 3 x 3 real symmetric matrix with |a| be numerically the largest off-diagonal element of A, then we can construct orthogonal matrix S1 by Jacobi's method as
    11. If the pivot element happens to be zero, then the i-th column elements are searched for the numerically ___ element
    • Smallest
    • Largest ✔
    12. Exact solution of 2/3 is not exists
    • True ✔
    • False
    13. A and its transpose matrix have ___ eigenvalues
    • same ✔
    • different
    14. If n x n matrices A and B are similar, then they have the different eigenvalues (with the same multiplicities)
    • True ✔
    • False
    15. Power method is applicable if the eigen values are real and distinct
    • True ✔
    • False
    16. By using determinants, we can easily check that the solution of the given system of linear equation ___ and it is ___
    • exists, unique ✔
    • exists, consistent
    • trivial, unique
    • nontrivial, inconsistent
    17. Power method is applicable if the eigen vectors corresponding to eigen values are linearly ___
    • independent ✔
    • dependent
    18. When the condition of diagonal dominance becomes true in Jacobi's Method. Then its means that the method is ___
    • Stable
    • Unstable
    • Convergent ✔
    • Divergent
    19. While using Jacobi method for the matrix

    A = [11/41/3]
    1/41/31/2
    1/31/21/5
     the value of 'theta Θ' can be found as 
    • tan 2Θ = 2a13/a11-a33
    20. While using Jacobi method for the matrix
    A = [11/41/2]
    1/41/31/4
    1/21/41/5
    and 'theta Θ=0.4480' the orthogonal matrix S1 will be given by
    • S1 = [cos 0.44800-sin 0.4480]
      010
      sin 0.44800cos 0.4480
    21. Full pivoting, in fact, is more ___ than the partial pivoting
    • Easiest
    • Complicated ✔
    22. While using the Gauss-Seidel Method for finding the solution of the system of equation, the following system
    x + 2y + 2z = 3
    x + 3y + 3z = 2
    x + y + 5z = 2
    • x = 3 - 2y - 2z, y = 2/3 - x/3 - z, z = 2/5 - x/5 - y/5
    23. By using determinants, we can easily check that the solution of the given system of linear equation exists and it is unique
    • True ✔
    • False 
    24. While using Jacobi method for the matrix
    A = [11/41/3]
    1/41/31/2
    1/31/21/5
    and 'theta Θ= 0.7191' the orthogonal matrix S1 will be given by
    • S1 = [cos 0.71910-sin 0.7191]
      010
      sin 0.71910cos 0.7191
    25. The linear equation x + y = 1 has ___ solution/solutions
    • no solution
    • unique ✔
    • infinite many
    • finite many
    26. For a system of linear equations, the corresponding coefficient matrix has the value of determinant; |A|=-3, then which of the following is true?
    • The system has unique solution ✔
    • The system has finite multiple solutions
    • The system has infinite many solutions
    • The system has no solution
    27. In Gauss-Jacobi's method, the corresponding elements of xi(r+1) replaces those of xir as soon as they become available
    • True
    • False ✔
    28. An augmented matrix may also be used to find the inverse of a matrix by combining it with the ___ matrix
    • Inverse
    • Square
    • Identity ✔
    • None
    29. Power method is applicable it the eigen vectors corresponding to eigen values are linearly independent
    • True ✔
    • False
    30. While using the relaxation method for finding the solution of the below given system, which of the following increment will be introduced?
    6x1 - 2x2 + 3x3 = 1
    -2x1 + 7x2 + 2x3 = 5
    x1 + x2 - 5x3 = -13
    • dx3 = R3/a33
    31. Let |A| be a 3 x 3 real symmetric matrix with |a23| be the numerically largest off-diagonal element then using Jacobi's method the value of theta can be found by
    • tan 2 Θ = 2a23/a22-a33 
    32. The linear equation; 0x+0y=2 has ___ solution/solutions
    • unique
    • no solution ✔
    • infinite many
    • finite many
    33. The root of the equation xex-5=0 is bounded in the interval
    • [-2, 1]
    • [-1, 1]
    • [0, 1] ✔
    • [1, 2]
    34. Which of the following is a forward difference table for the given values of x and y?
    x   0.1   0.5   0.9
    y   0.003   0.148   0.370
    • xyΔyΔ2y
      0.10.0030.1450.077
      0.50.1480.222
      0.90.37
    35. In ___ method, a system is reduced to an equivalent diagonal form using elementary transformations
    • Jacobi's 
    • Gauss-Seidel
    • Relaxation
    • Gaussian elimination ✔
    36. If the determinant of a matrix A is not equal to zero then the system of equations will have ___
    • a unique solution ✔
    • many solutions
    • infinite many solutions
    • None
    37. A 3 x 3 identity matrix have three and ___ eigen values
    • same ✔
    • different
    38. Numerical methods for finding the solution of the system of equations are classified as direct and ___ methods
    • Indirect
    • Iterative ✔
    • Jacobi
    • None
    39. Which of the following is a forward difference table for the given values of x and y?
    x   0.1   0.7   1.3
    y   0.003   0.248   0.697

    • xyΔyΔ2y
      0.10.0030.2450.204
      0.70.2480.449
      1.30.697
    40. While using Relaxation method, which of the following is the Residuals for 1st iteration on the system; 2x + 3y = 1, 3x + 2y = 4?
    • (2, 3)
    • (3, -2)
    • (-2, 3)
    • (1, 4) ✔