Wednesday, April 29, 2009

Database tips from SCV~!!!

full marks = 100% (take 35%)

3 Sections:

=Section A - 10 Questions (vey simple - straight forward - choose answer)

=Section B - 4 Questions (answer all)
in every question, got at least 3 sub questions
1. ERD (should knw how to draw the cases)
2. Logical data design (global)
3. Know about the relation schema
4. Wil giv table / scenario - normalize..dependency (functional)
5. SQL Codes (insert..delete...)

=Section C - 2 Questions
1. Case study...security
ERD = must knw hw to describe and design (understand the case study)
Relational Schema
Data Model

Report:
1) summary of 1 and 2 asgm (combine)

No comments: