sol b mily ga kia?
CS403 Database Management Systems Assignment No 4View more random threads:
- MGT603 Assignment#1 Fall 2010 Idea Solution just edit it
- International Business (MGT520) Assignment No.1 Last Date...
- SOC401 Cultural Anthropology Assignment No.1 Solution...
- ISLAMIC MODES OF FINANCING (FIN624) ASSIGNMENT NO # 01 Last...
- ENG 301 BC Asignment Business Communication (May,3,2010)
- Principles of Management (MGT503) Assignment # 1 Solution...
- All Past Assignments with Solutions Of STA630 Research...
- SOC101 Introduction to Sociology Assignment No.1 Solution...
- CS301 Data Structures Assignment No. 1 Solution and...
- PSY405 Personality Psychology Assignment No. 1 Fall 2014...
Spring 2010
Total Marks: 20
Due Date: 29/06/2010
[Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10
STUDENT(A, B, C, D, E, F, G, H) Where A, B, C and so on are the attributes of the relation STUDENT.
A, B -> C, D, E
C -> F
D -> G
E -> H
Note: Also mention why the relation is in that normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
You are required to normalize this relation into Third Normal Form (3NF).
Upload Instructions:
Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.
sol b mily ga kia?
zaroor milay ga bhai just wait na. bana rahay han.
Allah bhla kry g ap ka
Sponsored Links
Ameen aur app ka bhi. what is ur name and where u from? introduce tu karwa den.
[Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10
Answer:
No normal form exist here because here is functional dependency and starting form first normal form we have to remove the functional dependency. That’s why relation is in no normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
Answer:
3rd normal form:
Address ---------------------------------------------- Tel_No
New Garden Town, Lahore---------------------------042-4466375,042-4586975,042-4554668
Blue Area, Islamabad---------------------------------- 051-5546584,051-4687458
Address is taken as forigen key in 3rd normal form.
:o:o--------------------------------------------------------------------------------------:o:o
[B]The more knowledge you have, the greater will be your fear of Allah.[/B]
Please Join My [B]Group Vuhelp[/B][B], Birthday Wishing, Daily Hadees[/B] [CODE][B]http://vuhelp.net/groups/vuhelp.html[/B]
[B]http://vuhelp.net/groups/birthday-wishing.html[/B]
[B]http://vuhelp.net/groups/daily-hadees.html[/B][/CODE]
[CENTER][B][COLOR="Red"][SIZE="4"]Email: [email]viki@vuhelp.net[/email][/SIZE][/COLOR][/B][/CENTER]
There are currently 1 users browsing this thread. (0 members and 1 guests)