Scribd Logo
Upload

Welcome to Scribd!

  • 143 views

    Section A: Computer Science Paper 2 6023

    Uploaded by

    Mushawatu
    The document contains information about various topics in computer science including: 1) A logic circuit diagram with a truth table describing the inputs and outputs. 2) A diagram showing the von Neumann architecture with buses connecting the central processing unit, memory, and input/output devices. 3) A trace table showing the output values of variables x, X, and A over multiple iterations of a program. 4) An outline for a recursive factorial function written in pseudocode. 5) Code snippets in C# for an interest calculator program including a button click event handler calculating interest based on investment amount. 6) An entity relationship diagram showing relationships between tables for a student registration database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Section A: Computer Science Paper 2 6023

    Uploaded by

    Mushawatu
    143 views6 pages
    The document contains information about various topics in computer science including: 1) A logic circuit diagram with a truth table describing the inputs and outputs. 2) A diagram showing the von Neumann architecture with buses connecting the central processing unit, memory, and input/output devices. 3) A trace table showing the output values of variables x, X, and A over multiple iterations of a program. 4) An outline for a recursive factorial function written in pseudocode. 5) Code snippets in C# for an interest calculator program including a button click event handler calculating interest based on investment amount. 6) An entity relationship diagram showing relationships between tables for a student registration database.

    Original Title

    PAPERTWOSAMPLE.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains information about various topics in computer science including: 1) A logic circuit diagram with a truth table describing the inputs and outputs. 2) A diagram showing the von Neumann architecture with buses connecting the central processing unit, memory, and input/output devices. 3) A trace table showing the output values of variables x, X, and A over multiple iterations of a program. 4) An outline for a recursive factorial function written in pseudocode. 5) Code snippets in C# for an interest calculator program including a button click event handler calculating interest based on investment amount. 6) An entity relationship diagram showing relationships between tables for a student registration database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    143 views6 pages

    Section A: Computer Science Paper 2 6023

    Uploaded by

    Mushawatu
    The document contains information about various topics in computer science including: 1) A logic circuit diagram with a truth table describing the inputs and outputs. 2) A diagram showing the von Neumann architecture with buses connecting the central processing unit, memory, and input/output devices. 3) A trace table showing the output values of variables x, X, and A over multiple iterations of a program. 4) An outline for a recursive factorial function written in pseudocode. 5) Code snippets in C# for an interest calculator program including a button click event handler calculating interest based on investment amount. 6) An entity relationship diagram showing relationships between tables for a student registration database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 6

    Computer science Paper 2

    6023

    SECTION A

    1(a) Logic Circuit

    C
    S

    Truth Table

    T C V NOT V T AND C V’ AND C S


    0 0 0 1 0 0 0
    0 0 1 0 0 0 0
    0 1 0 1 0 1 1
    0 1 1 0 0 0 0
    1 0 0 1 0 0 0
    1 0 1 0 0 0 0
    1 1 0 1 1 1 1
    1 1 1 0 1 0 1
    Computer science Paper 2
    6023

    (b)Von Neumann Buses

    Central
    Input/output
    processing Memory Unit
    devices
    Unit(CPU)

    Control Bus

    Adress Bus

    Data Bus
    System Bus
    Computer science Paper 2
    6023

    SECTION B

    4(a) Trace Table

    OUTPUT
    x X A
    1 2 1
    2 3 4
    3 4 9

    (b) Recursive Function

    START
    Function factorial (n)
    Input n
    While n>0 Do
    IF n=0 THEN
    Output “1”
    Else
    n= n*Factorial (n-1)
    End if
    End While
    STOP

    i. Interface Design

    (ii)Program code
    Computer science Paper 2
    6023
    Public Class Form1 ‘By Tinotenda Maisiri
    Dim amountinvested As Integer
    Dim numberofyears As Integer
    Dim interestrate As Percantage
    Dim balance As Integer
    Dim Interest As Integer

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As


    System.EventArgs) Handles Button1.Click
    amountinvested = TextBox1.Text
    numberofyears = TextBox2.Text
    If amountinvested >=500 And < =1000 Then
    interestrate= 10%
    interest= (10/100) * amountinvested
    balance = amountinvested -Interest
    If
    "amountinvested" <1000 And <=2000 Then

    interestrate= 15%
    interest= (15/100) * amountinvested
    balance = amountinvested -Interest
    Else
    "amountinvested" >2000 Then
    interestrate = 20%
    Interest = (20 / 100) * amountinvested
    balance = amountinvested - Interest
    End If
    End If
    MsgBox.Show("Interest", Interest,vbTab ,"Interestrate",
    interestrate,vbTab,"Balance",balance,vbTab,"investedamount" ,amountinvested
    vbTab,"Nember of years",numberof years)

    SECTION C
    Computer science Paper 2
    6023

    6(a) ERD Diagram

    First name Surname Surname First name

    E.C Number
    Registration
    Number
    Registration Teacher Student
    Number
    Leave days

    Salary
    Adress Class
    Adress

    Registration
    Number

    Ancillary Worker Surname

    Salary
    Adress First name

    Hours Worked

    (b) SQL Statements

    SELECT customer name, address


    FROM tblDebtors
    WHERE days =60 AND Amount >30 ORDER BY DESC

    (c) SQL Statements

    DELETE FROM tblDebtors


    WHERE customer name =Mr Mara

    (d) How to connect data base to IDE language


    Computer science Paper 2
    6023

    I created the database

    Click External data on the tool Bar

    Click here

    Then click More And CLICK OBDC DATABASE

    Click here

    You might also like