FYP : Edit Data

Antara proses wajib dalam membangunkan suatu sistem yang mempunyai database adalah seperti berikut:-
 
i. Pamir data 
ii. Edit Data
iii. Tambah Data
iv. Padam Data

Untuk posting kali ini- contoh proses edit data adalah seperti di bawah.

Masih lagi dengan Database design (Microsoft sql server 2008) yang sama (seperti contoh-contoh lepas)

Page pertama iatu paparan data beserta dengan linknya adalah seperti berikut (gambar di ikuti dengan kodingnya).

Data di paparkan di ikuti link [edit] dan [delete]

koding untuk paparkan data spt di atas

[edit] pada data pertama di klik dan paparan berikut di perolehi

user lakukan perubahan data bagi Name dan Password. Klik Update untuk menyimpan perubahan. Koding bagi page dan button Update di atas adalah seperti berikut:

koding pada page (page_load)

koding pada button Update

BCS1333 OS: Exercise Chapter 3

Chapter 3 : PROCESS

1. Define what is process.
2. List and briefly explain the Process State. 
3. Each process is represented in the OS by a process block. Explain any three information that its contains.
4. Describe the differences among short-term and long term scheduling.
5. Describe the actions taken by a kernel(OS) to context-switch between processes.

BCS1333 OS: Question & Answer Chapter 2

 List five services provided by an operating system that are designed to
make it more convenient for users to use the computer system.
Answer:

• Program execution. The operating system loads the contents (or
sections) of a file into memory and begins its execution.

• I/O operations. Disks, tapes, serial lines, and other devices must be
communicated with at a very low level. The user need only specify
the device and the operation to perform on it, while the system
converts that request into device- or controller-specific commands.

• File-system manipulation. There are many details in file creation,
deletion, allocation, and naming that users should not have to
perform.  Deleting a file requires removing the name file information and
freeing the allocated blocks.

• Communications. Message passing between systems requires
messages be turned into packets of information, sent to the network
controller, transmitted across a communications medium, and
reassembled by the destination system.

• Error detection. Error detection occurs at both the hardware and
software levels. At the hardware level, all data transfers must be
inspected to ensure that data have not been corrupted in transit.



Describe three general methods for passing parameters to the operating
system.
* Question included in Assignment 1


What are the five major activities of an operating system in regard to file
management?
Answer:
• The creation and deletion of files
• The creation and deletion of directories
• The support of primitives for manipulating files and directories
• The mapping of files onto secondary storage
• The backup of files on stable (nonvolatile) storage media



What are advantages or disadvantages of virtual machine?
Answer:
Advantages:

1. You can host a guest operating system known as a VM inside your main operating system known as the host sharing the computing resources from your pc such as the CPU and memory.

This will allow you to have access to other operating systems in real time. A huge benefit if you dont want to fork out on a new computer just because you want to try the latest linux operating system or the latest macosx.

2. Testing and learning. If your a software developer, you can test software inside a VM. If the VM would or ever crash your operating system due to ur software, then the main operating system is not affected, only the VM would be. 

So its good for testing purposes. Its also good for testing a virtual network. You could set up multiple VMs and network each VM together as if they were separate machines. This would allow you to test out networking protocols and that would help to become a network engineer. 

3. If you have a server with lots of computing resources then you could create lots of webservers which are separate to each other and resell what they call 'virtual server' to customers. This means they get a slice of your computer resources. If their webserver shuts down abnormally, the machine wouldnt be affected as you they will only have access to their virtual machine.

4. If you have more than one monitor, then you can each assign a virtual machine to a monitor so each virtual machine has its own monitor :-)

5. VMs are portable. Its just a huge file. Take that file with you anywhere and you have your files and operating with u whereever you go. However you can only run it on a pc that has a Virtualisation software, software that allows you to run virtual machines.


Disadvantages:

1. Resources Hungry. It uses up more resources the more VMs that you run simultaneously.

2. If your CPU does not allow for hardware virtualization then you can run some operating systems in software virtualization but generally its slower. So slow that it would annoy you.
Some operating systems will not run in software virtualization and require that you have a CPU with hardware virtualization. So it would cost you more if you dont have a CPU with hardware virtualization.

3. If you want to own your own server and intend to resell a virtual server then you generally need a fair bit of money to set it all up. This could mean a purchase of 64-bit hardware with multiple cpus and multiple hard drives. 

DCT1133 Chapter 5 OS

Check Your Understanding
You can find the answers to these questions in the appendix, “Answers to Check Your
Understanding Questions.”

1. Which open-source operating system is available on multiple hardware platforms?
a. Linux
b. Mac OS X
c. Windows 2000
d. Windows XP

2. Which registry file contains information about the hardware and software in the computer
system?

a. HKEY_CLASSES_ROOT
b. HKEY_CURRENT_USER
c. HKEY_LOCAL_MACHINE
d. HKEY_USERS

3. How can the command line be accessed in Windows XP?
a. Start > Run > Prompt
b. Start > Run > cmd
c. Start > Control Panel > Prompt
d. Start > All programs > Accessories > Terminal
e. Start > Run > Terminal
4. Which file system is recommended for Windows XP for large file support and
enhanced security?
a. DirectX
b. DOS
c. FAT32
d. HPFS
e. NTFS

5. What is the purpose of the Microsoft Hardware Compatibility List?
a. It lists all the hardware that runs Microsoft Office software.
b. It lists the Microsoft software that runs on the listed hardware.
c. It lists hardware that is supported by a Microsoft operating system.
d. It lists hardware that works together.

6. What should be done before upgrading from Windows 2000 to Windows XP?
a. Back up all the data files.
b. Update all the device drivers.
c. Detach all the peripheral devices.
d. Download a legitimate XP authentication key.

7. Which key or key sequence will enable a user to start Windows XP in Safe Mode?
a. Alt+B
b. Alt+X
c. Alt+Z
d. F1
e. F8
f. The Windows key

8. What is a good example of an open-ended question that a technician can ask the user to
learn more about conditions before the failure?
a. What software has been installed recently on the computer?
b. Does the computer boot into the operating system?
c. Are there any beeps when the computer boots?
d. Has anybody else used the computer recently?
e. How many users were logged on to the network when the failure occurred?

Latihan Chapter 3 Selections.

Latihan Chapter 3  Selections.

Sila buat latihan untuk soalan nombor 3.3,3.4,3.6, dan 3.15

BCS1333 LAB 24/2/2013

CLI - MSDOS

LAB 24/2/2013

FYP : Delete Data

Dalam membangunkan suatu sistem komputer yang mempunyai 'database' .Proses berikut adalah proses yang wajib:

i. Pamir data  <-- a="" href="http://mohdnazri.blogspot.com/2013/02/fyp-database-connection.html">sila lihat entry sebelum ini

ii. Edit Data
iii. Tambah Data
iv. Padam Data

Untuk posting kali ini saya akan memberikan contoh untuk memadam data.

Database design (Microsoft sql server 2008) adalah seperti berikut:

Database Design

Interface design adalah seperti berikut:

page untuk paparkan semua data dan hyperlink [edit] dan [delete]

Koding bagi page di atas dan button  "Display data" di atas adalah seperti berikut:-

koding untuk page di atas

 

Koding bagi page confirmdelete.aspx adalah seperti berikut:-

koding untuk operasi delete

BCS1243 PP Lab 20 feb 2013 (selection)

1. Read three integers and find the largest.

import java.util.Scanner;
/**
 * @(#)tbsr3no.java
 *
 * tbsr3no application
 *
 * @author
 * @version 1.00 2013/2/20
 */

public class tbsr3no {
   
    public static void main(String[] args) {
       
        int N1,N2,N3,TBSR;
        Scanner input = new Scanner(System.in);
        N1 =input.nextInt();
        N2 =input.nextInt();
        N3 =input.nextInt();
       
        if(N1>N2)
        {
         TBSR=N1;   
        }
        else
        {
         TBSR = N2;
        }
  
      
           if(N3>TBSR)
           {
             TBSR=N3;
           }  
    
       System.out.println("Nilai tersebar antara 3 nilai ialah " + TBSR);
   
    }
}


2. Write a java program that reads the user’s age and then prints “you are a child” if the age <18 18="" adult="" age="" an="" and="" are="" citizen.="" if="" ou="" senior="" you="">=65. *(some characters not displayed correctly here)

import java.util.Scanner;
/**
 * @(#)age_and_status.java
 *
 * age_and_status application
 *
 * @author
 * @version 1.00 2013/2/20
 */

public class age_and_status {
   
    public static void main(String[] args) {
        Scanner input = new Scanner(System.in);
        int Age;
        System.out.println("Sila masukkan umur!");
        Age =input.nextInt();
   
    
       
        if(Age<18 br="">        {
        System.out.println("you are a child");
        }
   
   
        if((Age>18)&&(Age<=65))
        {
        System.out.println("you are an adult");
        }
       
       
        if(Age>=65)
        {
        System.out.println("You are senior citizen");
        }
       
       
   
    }
}

3. A student’s letter grade is calculated according to the following schedule:

Numerical grade	Letter grade
90-100	A
80-89	B
70-79	C
60-69	D
0-59	F

Write a java  that accepts a student’s numerical grade, converts the numerical grade to an equivalent letter grade, and displays the letter grade. 

BCS 1333 Operating System (Assignment 1)

1. [CHAPTER 1] The issue of resource utilization shows up in different forms in different
types of operating systems. List what resources must be managed
carefully in the following settings:

a. Workstations connected to servers
b. Handheld computers (Smart phone)

2.[CHAPTER 1]Briefly  define Timesharing System and Single-User Workstation (PC).
Under what circumstances would a user be better off using a timesharing
system rather than single-user workstation?


3. [CHAPTER 1]Describe the differences between symmetric and asymmetric multiprocessing.
What are three advantages and one disadvantage of multiprocessor
systems?

4. [CHAPTER 2]Describe three general methods for passing parameters to the operating
system.

5. [CHAPTER 2]What is the relationship between a guest operating system and a host
operating system in a system like VMware? What factors need to be
considered in choosing the host operating system?

DCT1133 CM Chapter 4 Exercise

Check Your Understanding

1. Which of the following common tasks are performed during preventive maintenance?
(Choose three.)
A. Check and secure loose cables.
B. Update the RAM.
C. Clean the mouse and keyboard.
D. Update drivers.
E. Reinstall the operating system.
F. Install additional peripherals.
 
2. In which of the following situations is it recommended to ask the customer to sign a
liability release form before attempting any kind of repair? (Choose two.)
A. The technician needs to share the responsibility with the customer.
B. The information on the computer is critical.
C. The technician is unable to back up the customer information.
D. The information in the backup is confidential.
E. The customer is unable to provide a backup.
 
3. What is the first step in the troubleshooting process?
A. Gather data from the computer.
B. Gather data from the customer.
C. Verify the obvious issues.
D. Evaluate the problem and implement the solution.
E. Close with the customer.
F. Try quick solutions.
 
4. Which type of question allows the customer to completely describe the problem?
A. Closed-ended
B. Open-ended
C. Specific
D. Technical
 
5. What is the last step in the troubleshooting process?
A. Gather data from the computer.
B. Gather data from the customer.
C. Verify the obvious issues.
D. Evaluate the problem and implement the solution.
E. Close with the customer.
F. Try quick solutions.

BCS 1333 QUIZ 1

1.The service provided by an Operating System can be divided into two main categories. Briefly describe the two categories and discuss how they differ.

2. List five services provided by an Operating System that are designed to make it more convenient for users to use computer system.

3.What are the five major activities of an Operating System with regards to file management?

FYP: programmig language, IDE dan database

Pada 6/2/13 yang lalu pelajar tahun 3  BCBM telah membuat 'presentation progress  FYP'. Banyak kumpulan yang memilih untuk membangunkan 'web based system'.Di sini saya senaraikan dan terangkan secara ringkas 'item-item'  yang mungkin mengelirukan pelajaR.

1. Bahasa Pegaturcaraan

Pelajar boleh memilih bahasa pengaturcaraan seperti PHP, C# serta VBscript. 
 Bila pelajar memilih C# atau VBscript, pelajar di katakan menggunakan framework ASP.NET. ASP.NET BUKAN bahasa pengaturcaraan,

2. integrated development environment (IDE)

Untuk memudahkan pelajar menulis koding, compile dan run. Pelajar memerlukan IDE. Antara IDE yang sering di gunakan ialah Microsoft Visual Studio dan Adobe Dreamveaver.

Kedua-dua IDE ini 'support' semua bahasa yang disebut di atas. Namun saya sarankan pelajar untuk menggunakan Microsoft Visual Studio bagi C# dan VBscript kerana mereka adalah dari keluarga yang sama (Microsoft).

3. Database
Kebanyakan pelajar akan menggunakan database bagi menyimpan maklumat (kecuali satu projek yang membanggunkan apps untuk andriod).  Di antara database yang boleh digunakan ialah Microsoft Access, Microsoft SQL Server dan MySQL.


Berikut adalah rujukan yang digunakan bagi menulis maklumat di atas.
Bolehkah menggunakan MySQL dengan ASP.NET?
Bolehkah menggunakan Microsoft Visual Studio untuk koding PHP?
Apakah kaitan antara C#,.NET,ASP dan ASP.NET?
Apakah IDE?

fyp : database connection

Berikut adalah contoh koding untuk connection asp.net (vbscript) kepada database (contoh pertama menggunakan ms sql server dan contoh kedua menggunakan ms access).

1. asp.net (vbscript) dan ms sql server 2008

1.1 . Database design adalah seperti berikut

1.2 interface design adalah seperti berikut

1.3 koding adalah seperti berikut

Imports System.Data.SqlClient

Imports System.Data

Partial Class _Default

    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim constr As String

        Dim con As SqlConnection

        Dim adapter As SqlDataAdapter

        Dim ds As New DataSet

        constr = "Server =9MEI2012-PC; Database= mydb;Trusted_connection = True;"

        con = New SqlConnection(constr)

        Try

            con.Open()

            adapter = New SqlDataAdapter("Select * from tbadmin", con)

            adapter.Fill(ds)

            con.Close()

            For i = 0 To ds.Tables(0).Rows.Count - 1

                Response.Write(ds.Tables(0).Rows(i).Item(0))

                Response.Write(ds.Tables(0).Rows(i).Item(1))

                Response.Write(ds.Tables(0).Rows(i).Item(2))

                Response.Write("
")

            Next

        Catch ex As Exception

            Response.Write(ex.ToString)

        End Try

    End Sub

End Class

1.4 Output adalah seperti berikut (selepas click button Display)

3 data ini telah sedia dimasukkan

2. asp.net (vbscript) dan ms access

BCS1243 PP Assignment 1

SECTION A
1. Define the following terms:
(a) Computer Program
(b)    Programmer
(c)     Programming
(d)     High Level Language
(e)     Low Level Language
(f) Computer Bug

(f) Debugging

2.   Listed below are correct expressions and incorrect C++ expression corresponding to them. Find the errors and write corrected C++ expressions.

	Algebra	Java Expression	Answer
(ex)	2(3 ÷ a)	2(3/a)	2*(3/a)
(a)	(2)(4)+(6)(5)	(2)(4)+(6)(5)
(b)	6+18 _____ 2	6+18/2
(c)		1/1+x*x

SECTION B

PROBLEM SOLVING

Instructions:

You are required to prepare (i) Pseudocode (ii) Flowchart and (iii) JAVA  program for each of the following problems.

1. Write a program which inputs a length in inches, and outputs its equivalent in centimetres (1 inch = 2.54 centimetres)

2. Write a program that calculates mileage reimbursement for a salesperson at a rate of RM 0.50 per KM. Your program should interact with the user in this manner:

MILAGE REIMBURSEMENT CALCULATOR

Enter beginning odometer reading 13505

Enter ending odometer reading 13810

You traveled 305 KM

Your reimbursement is RM 152.50

DCT1133 CM Chapter 3 Exercise

Apakah urutan proses yang sempurna bagi pemasangan sebuah komputer?

BCS1243 PP Chapter 2 Elementary Programming

1. The following variables are invalid. Explain why.

i.Nama    Pelajar

ii Nama-Pelajar

iii.1Nama

iv. import

2. Write an evaluation tree for the following expressions

i. 2+5*3

ii 2*5+3

iii 2*5/3

iv.(2+5)*3

3. Define the following terms:-

i. Syntax Errors

ii. Runtime Errors

iii. Logic Errors