We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Assignment No. 1
Semester Spring 2016
Total Marks: 15
Due Date: 18th May2016
The assignment has been designed to develop your ability to apply De-Normalization Techniques and principals to normalized data/tables.
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS614@vu.edu.pk
Do not post queries related to assignment on MDB.
Question 1 [15 Marks]
+ Click Here To Join also Our facebook study Group...How to Join Subject Study Groups & Get Helping Material?..
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)
Please Discuss here about this assignment.Thanks
Our main purpose here discussion not just Solution
We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.
Std_ID- Name- Address- Salt_ID- Salt- Book_ID- Bk Title- Category
Bc1121- 1 2 oracle database
3 Algo math
MC1813- 2 4
ZS1557- 2 2
Mc1383- 2 1
Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....
any one who know the solution ?
i confused in salutation table because in salutation table salutation 3 is used for mrs
not used in any other table but how we combine this table to other.
please guide me if anyone knows
Student ID-Salutation ID- Salutation- Name- Address- Book ID- Book- Title- Category
ye colums theek ha guys.>>>
Wasfa, kia ye assignment Sql mn bnani hy?
Nai naveed, ye worh
As said by instructor we have to follow the procedure of all 5 five techniques (if required) not only pre-joining
1. Collapsing tables
3. Splitting tables
4. Adding redundant columns
5. Derived attributes
it's not necessary to apply all the techniques.
Dear @Anmol Maha Please share your column sequence............
any one hv complete solution?