Ujuan 1 System Analysis & Design (BCS2413)

Ujian 1 SAD akan di adakan pada ketetapan berikut:-

Tarikh : 5/10/2011
Masa : 3:00 pm
Tempat : L22
Topik : Chapter 1 hingga 5

Sila klik pautan ini untuk format dan contoh soalan.

FINAL YEAR PROJECT SCHEDULE DNT3054

Tarikh-Tarikh Penting:

Project Progress Presentation 05/10/2011 (Week 9)
Draft Report Submission 19/10/2011 (Week 11)
Project Presentation, Report and Log Book Submission 2/11/2011 (Week 13)

Maklumat Pemarkahan dan Borang Pemarkahan:

i) Effort 10% (Supervisor) P1
ii) Proposal Report 20% (Supervisor) P2
iii) Proposal Presentation 5% (Committee) P3
iv) Progress Presentation 5% (Committee) P4
v) Final Project Report 15% (Supervisor) P5
vi) Final Project Presentation 45% (Committee) P6
(Final project copy, final project report and presentation)


Senarai Tajuk Projek dan Penyelia:

BCS2233 OOP Contoh Test 1

Chapter : 1 to 5
Date : 4/10/2011
Time : 8:30 am (L22)
[ OPEN BOOK (only Liang's slide / book) ]





1. What is debugging? [3 marks]

2. What is the difference between a constant and a variable? [3 marks]

3. What is Overloading Methods? [3 marks]

4. Which of the following are invalid identifiers, why? [8 marks]

a) one
b) hello
c) my Window
d) JAVA
e) 1234
f) hello,there
g) acct122
h) DecafeLattePlease


5. Evaluate the following expressions: [4 marks]

a) 3 + 5 / 7
b) 3 * 3 + 3 % 2
c) 3 + 2 / 5 + -2 * 4
d) 2 * (1 + -(3/4) / 2) * (2 - 6 % 3)


6. Evaluate the following boolean expressions. Assume x, y, and z have some numerical values.
[3 marks]

a) 4 < 5 || 6 == 6
b) 2 < 4 && (false || 5 <= 4)
c) !(z != z)

7. Write a while statement to add numbers 11 through 20. [5 marks]

8. Write a while statement to continuously read in real numbers and stop when a negative number is entered. [5 marks]

9. For each of the following loop statements, determine the value of sum after the loop is executed. [6 marks]

a. int count = 0, sum = 0;
while ( count < 10 ) {
sum += count;
count++;
}


b. int count = 1, sum = 0;
while ( count <= 30 ) {
sum += count;
count += 3;
}


c. int count = 0, sum = 0;
while ( count < 20 ) {
sum += 3*count;
count += 2;
}

10. Write a do–while loop to compute the sum of the first 30 positive odd integers. [5 marks]

11. Write a for loop to compute. [9 marks]

a. the sum of 1, 2, . . . , 100.
b. the sum of 2, 4, . . . , 500.
c. the product of 5, 10, . . . , 50.


12. Write method headers for the following methods: [6 marks]
a. Computing a CPA, given the Number of Credit and the Total Points.
b. Printing the calendar for a year, given the year.
c. Computing a square root.
d. Testing whether a number is odd, and returning true if it is.
e. Printing a message a specified number of times.
f. Computing the monthly payment, given the loan amount, number of years, and annual interest rate.

OOP( LATIHAN CHAPTER 5)

Write method headers for the following methods:

• Computing average, given 2 integers.
CONTOH JAWAPAN : public static double avg(int N1, int N2)
• Find maximum, given 3 integers.
• Computing a sales commission, given the sales amount and the commission rate.
• Printing the calendar for a month, given the month and year.
• Computing a square root.
• Testing whether a number is even, and returning true if it is.
• Printing a message a specified number of times.
• Computing the monthly payment, given the loan amount, number of years, and annual interest rate.
• Finding the corresponding uppercase letter, given a lowercase letter.

'Display Data' & 'Add Data' (MS SQL , ASP.NET)

Proses menyambung ASP.NET (web development) kepada database MS SQL Server agakmengelirukan kerana banyak objek yang perlu di guna dan terdapat pelbagai teknik.

Berikut di sertakan 2 contoh:-

1. Paparkan data
2. Tambah data


Interface saya adalah seperti berikut


Koding bagi dua button di atas seperti berikut:-

Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
'berjaya pamir data
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As SqlDataAdapter
Dim ds As New DataSet ' yang ni kena ada Imports System.Data
Dim i As Integer
connetionString = "Server =4MEI-PC\MEMO; Database =dbmemo; Trusted_Connection =True;"
connection = New SqlConnection(connetionString)
Try
connection.Open()
adapter = New SqlDataAdapter("Select * from users", connection)
adapter.Fill(ds)
connection.Close()

For i = 0 To ds.Tables(0).Rows.Count - 1
Response.Write(ds.Tables(0).Rows(i).Item(1) & " ")
Response.Write(ds.Tables(0).Rows(i).Item(2) & "
")
Next
Catch ex As Exception
Response.Write(ex.ToString)
End Try
End Sub



Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
'berjaya TAMBAH DATA
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As New SqlDataAdapter
Dim sql As String
connetionString = "Server =4MEI-PC\MEMO; Database =dbmemo; Trusted_Connection =True;"
connection = New SqlConnection(connetionString)
sql = "insert into users (uname,pass) values('ISA','4455')"
Try
connection.Open()
adapter.InsertCommand = New SqlCommand(sql, connection)
adapter.InsertCommand.ExecuteNonQuery()
MsgBox("Row inserted !! ")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub


Berikut adalah maklumat MS SQL server dan Table yang di guna

BCS2413SAD LAB (interface design)

Berikut adalah cara memaparkan gambar(dalam picturebox) dari senarai (listbox). Menggunakan Visual Basic.NET Windows Application.





Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged

If ListBox1.SelectedIndex = 0 Then
PictureBox1.Load("c:\image1.jpg")
End If


If ListBox1.SelectedIndex = 1 Then
PictureBox1.Load("c:\image2.jpg")
End If


If ListBox1.SelectedIndex = 2 Then
PictureBox1.Load("c:\image3.jpg")
End If

'note: 3 image (di beri nama image1.jpg, image2.jpg dan image3.jpg ) di simpan dalam root c:

BCS2233 18/9/ 2011 Lab OOP LOOPING

Review Questions




1. How many times is the following loop body repeated? What is the printout of the loop?

a)
int i=1;
while(i>10)
if((i++) % 2 ==0)
system.out.println(i);

b)
int i=1;
while(i10)
if((i++) % 2 ==0)
system.out.println(i);


2. What are the differences between a while loop and a do-while loop?

3. Do the following two loops result in the same value in sum?
a)
for( int i = 0; i<10;++i) {
sum += i;
}

b)
for( int i = 0; i<10;i++) {
sum += i;
}

4. What are the three parts of a for loop control? Write a for loop that prints the numbers from 1 to 100.

5.What does the following statement do?

for ( ; ; ) {   do something; }
6. If a variable is declared in the for loop control, can it be used after the loop exits?
7. Can you convert a for loop to a while loop? List the advantages of using for loops. 
8. Convert the following for loop statement to a while loop and to a do-while loop:

long sum = 0;
for (int i = 0; i <= 1000; i++)
 sum = sum + i;

Programming Exercises
 1* (Repeating additions)
Listing 4.1, SubtractionTutorLoop.java, generates ten random subtraction questions.
Revise the program to generate ten random addition questions for two integers between 1 and 15.
Display the number of correct answers and test time. 

2* (Counting positive and negative numbers and computing the average of numbers)
Write a program that reads an unspecified number of integers,
determines how many positive and negative values have been read, and computes the total and
average of the input values, not counting zeros. Your program ends with the input 0.
Display the average as a floating-point number. (For example, if you entered 1, 2, and 0, the average should be 1.5.) 

Web Application Development Tools

Bila anda ingin membangunkan suatu sistem komputer- anda perlu memilih satu bahasa yang akan di pakai untuk mengarahkan komputer membuat kerja yang anda kehendaki. Di TATiUC hampir semua pelajar (termasuk bukan bidang IT) akan mengambil subjek Programming (pengaturcaraan). Jika anda berhasrat untuk membangunkan sistem web - anda boleh menggunakan teknologi ASP.NET yang di sediakan oleh microsoft dan memilih bahasa seperti VB.NET atau C#. Bagi menympan data (database) - anda boleh memilih MS SQL SERVER (juga produk microsoft).

BCS2413SAD Chapter 4 Exercise

T/F

1. Systems analysis is the second of five phases in the systems development life cycle.

2. The role of a Recorder is to document the results of JAD sessions.

3. Compared with traditional methods, JAD is less expensive.

4. The requirement that data entry screens must be uniform is an example of an output requirement.

5. In an informal structure, some people have more influence and knowledge than appears on an organizational chart.


Multiple Choice

6. ____ are the logical rules that transform data into meaningful information.
a. Inputs
b. Outputs
c. Processes
d. Controls

7. ____ skills are used to communicate and interact effectively with other people.
a. Acting
b. Interpersonal
c. Interactive
d. Analytical


8. A planned meeting where you obtain information from another person is a(n) ____.
a. office visit
b. focus group
c. summit
d. interview

9. A question where the answer is unstructured is considered to be a(n) ____ question.
a. closed-ended
b. open-ended
c. leading
d. range-of-response


10. Observing a system in use at another location is called a(n) ____.
a. operational visit
b. system visit
c. site visit
d. technical visit

BCS2233 OOP Exercise Chapter 3 (Selection)

3.1 List six comparison operators.


3.2 Assume that x is 1, show the result of the following Boolean expressions:

(true) && (3 > 4) (answer: FALSE)
!(x > 0) && (x > 0)
(x > 0) || (x < 0)
(x != 0) || (x == 0)
(x >= 0) || (x < 0)
(x != 1) == !(x == 1)



3.10 Suppose x = 3 and y = 2, show the output, if any, of the following code.
What is the output if x = 3 and y = 4?
What is the output if x = 2 and y = 2?
Draw a flowchart of the following code:

if (x > 2) {
if (y > 2) {
int z = x + y;
System.out.println("z is " + z);
}
}
else
System.out.println("x is " + x);


Due Date: 12 sept 2011 before 4:00 pm (by email (nazri.ibrahim@gmail.com) or hard copy)

MS SQL SERVER 2008 Error Message

MS SQL Server adalah "relational database applicatation" (applikasi) bagi menyimpan data.

Jika anda membangunkan satu applikasi komputer dan memerlukan tempat bagi menyimpan data yang banyak- maka MS SQL Server adalah antara pilihannya.

Berikut adalah pengalam saya semasa 'bekerja' dengan MS SQL.

Bila anda melakukan perubahan pada design table - kemungkinan muncul error message berikut:-

"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created."

ini adalah langkah keselamatan yang di ambil oleh ms sql supaya data yang telah sedia ada tidak terganggu dengan perubahan (database design) yang anda lakukan. Anda perlu mengubah setting pada ms sql bagi membolehkan "saving changes is permitted".


Klik Tools -> Options -> Designers-> Uncheck "Prevent saving changes that require table re-creation".

BCS2413 System Analysis and Design (Assignment 1)

Based on real life scenario on any local company/ organization which you are very familiar, define the problem that could be addressed through systems analysis and design. The assignment response should contain the following:

Problem definition. The problem definition should be brief. The problem definition should be clear to someone not familiar with the setting.

Identifying a problem. The problem should be associated with an information system with which you are familiar. If possible, the problem should be within an organization that would support a team in conducting a systems analysis project during this semester.

Describing the setting of the problem. Provide a very brief (one paragraph) description of the setting in which the problem occurs. If an information system (computerized or manual) is already in place, briefly describe it.

Describing the problem. Try to specify the problem, rather than just describing the symptoms associated with the problem. You may use the symptoms to demonstrate that the problem is significant.

Defining the scope of the problem. Scope may be defined in terms of the people involved in the system processing, the people who control data involved in the system, the amount of data involved in the processing, or the costs of system failure.

Defining the goals/objectives of the analysis/design project. Establish criteria for the success of the project. Essentially, you will identify criteria for recognizing that the problem is solved. Also provide a brief justification for working on the problem.

What information you need together, and why it is important?This may include information about existing processes or data, the expected users, the environment of the new system, any constraints on your design, standards or “best practices” that may be pertinent, products or equipment, etc.

Where you will seek the information? This may include people (known, or known only by job title), vendors, other places with similar situations, research literature or trade journals, the site itself, etc.

How you will get the information? This may include types of interviews or observations, arti-facts you want to collect, searching through indexes or on the Web, etc. Make a list of questions, and conduct the interview. Write the list of questions prepared by you along with responses from the interviewer as part of your assignment. Also, write the procedure, in your own words, on the basis of your understanding of the responses to the questions asked by you.

How you plan to record and organize the information?This may include the models that you think will be useful, notes or sketches, etc. Your schedule for gathering and organizing information.