OSK Final Exam Study Guide...

progamming part:
- compare
- set flag
- correspoding jump
- use procedure(call/return)

Database Tips

Structured Question:

ERD - enhancement(ERM)

Logic Database Design (conversion from conceptual to logical)
- Conversion from conceptual to logical
- Write relation scheme

Normalization(15%)
1NF, 2NF, 3NF

SQL Statement
(no data definition, but data manipulation)
-"join" is included.
-Refer SQL slide from slide 3 to 5.

Case Study(total = 25%)
- (ER diagram - draw)(13%)
- write relational scheme(12%)

Normalization Exercise (Answer)

Software Engineering Tips

Architecture (style/design) (chapter11)
OO design (Chapter 14)
Validation and Verification (Chapter 22 ,23)
Software Testing
-White-box
strategy: Basis Path
-Black-box
strategy: Equivalence Partitioning, Boundary Value Analysis(BVA)
Sequence Diagram
Test case - testing & VV

PT II works

Please download the completed work from here...
Every assigned work would be uploaded and updated from time to time.
So come visit this blog for latest update.
Hope everyone is giving cooperation to ease down our burden doing assignment, and submit your work to: cshen12345@gmail.com
as soon as possible.

Chapter 9,10,11 Ex1,1: 1,1
Chapter 9 Ex1 : 2,3,4
Chapter 9 Ex2 : 1,2,3
Chapter 9 Ex2 : 4,5
Chapter 9 Ex2 : 6
Chapter 9 Ex3 : 1
Chapter 9 Ex3 : 2,3
Chapter10 Ex1 : 2,3
Chapter10 Ex2 : 1,2,3,4
Chapter10 Ex3 : 1,2 <--
Chapter11 Ex2 : 1,2
Chapter11 Ex2;3 : 5;3
Chapter11 Ex2 : 3
Chapter11 Ex2;3 : 6;2
Chapter11 Ex3 : 1
Chapter11 Ex3 : 4
Chapter11 Ex3 : 5
Chapter11 Ex3 : 7
Chapter11 Ex3 : 8
Chapter11 Ex3 : 9

New Updates:
1. Chapter 10 Ex3 question2, 3 changed to 1, 2 (mistake)
2. New NameList, download HERE.
(Those who submitted work would be indicated by redly coloured name).

SE ebook available at elearning!!

As I met lecturer this evening, she mentioned that she have uploaded some ebook about SE at elearning, there will be expiry date for the availability of the ebook, because of the ebook is(are) quite big in size.
So?
Go download it be4 "time's up".

PT II work assign

Since we have total 41 questions from Chapter 9 question 1 until Chapter 11 last question.
To ease our sufferance of all those projects and assignments, we work all in one to finish this assignment altogether for everyone's good.
If you have problem, feel free to post your comment here.

and our compiling date would be on this friday(3rd of April).
Assignment due date: 10th of April.
(Early compilation date is to spare longer time for modification of code/answer to prevent same answer.)

Do the code in softcopy 1st, so everyone can have it refered in pc.
Done the two questions by friday~
All the best to y'all...
and,
Send your finished work to this address:
cshen12345@gmail.com

Thank you very much for all ur cooperation

Name list would uploaded soon, lousy internet connection delayed upload time.

updates:
Download the NameList here.

Summary:
- compiling date : this friday(3rd of April)
- Assignment due date: 10th of April.
- Answer questions in softcopy
- Send work by friday: cshen12345@gmail.com
- Post comment here if there is any enquiry or needed help

Database & Programming Tips

Database
19/2/2009
8.oopm-10.oopm
MSI

Tips

a.intro
-ANSI-SAAPL architecture
-file base system and db system
-data model

b.conceptureall db design
-factor in db design
-step in conceptual design
-key

c.ERD
-cardinality/participation/multiplicity
-entity/relation/attributes

d. relation(model)
-properties of relation
-view
-relational db integraty
-relational scheme
-primary key/foreign key

e.SQL/DDL-create table
-insert data
-simple part using select-from-where
-delete and update record

Programming
21/2/2009
9.00am-11.30am
MSI

Tips
Subjective:
i. linux
draw directory tree, regular file names, name of directory, how many directory files, commands.
ii. C++
strcpy, strcat, given command identify output, fill in the blanks (code), modify program, given errors/explain errors/correct the errors, draw memory layout, initialize value/explain, given input write output, convert normal program into program using pointers.

long question:
string and pointers (no linux), input name and display name backwards.
*please finish the long question assignment mr.V gave. It would somehow help u in answering the long question because he just change something in the question.

Give the test your best shot!