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!