We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Q: Normalize the below table up to 3rd normal form.

 

Read the Instructions (given on the next page) carefully before solving the assignment.

 

 

 

Student-ID

Student-Specialization

Student-Name

Specialization- Semester

Semester

Start-Date

Semester

End-Date

Specialization

Supervisor

Bc00001

 

SE

AI

Graphics

Ali

 

F08

Sp09

F09

15-07-08

21-12-08

Prof Khalid

15-02-09

25-06-09

Prof Ashraf

15-07-09

21-12-09

Prof Shaw

Bc00002

AI

Safdar

Sp09

15-02-09

25-06-09

Prof Ashraf

Bc00003

 

SE

Graphics

AI

Usman

 

F08

Sp09

F09

15-07-08

21-12-08

Prof Khalid

15-02-09

25-06-09

Prof Shaw

15-07-09

21-12-09

Prof Ashraf

Bc00004

 

SE

AI

Naeem

 

F09

Sp010

15-07-09

21-12-09

Prof Khalid

15-02-10

25-07-10

Prof Ashraf

Bc00005

Graphics

Naveed

Sp010

15-02-10

25-07-10

Prof Shaw

Bc00006

AI

Zaman

Sp010

15-02-10

25-07-10

Prof Ashraf

Bc00007

SE

Zeshan

Sp010

15-02-10

25-07-10

Prof Khalid

 

 

 

 

Guidelines / Instructions

 

  • Do not send the archived file (.rar etc).
  • Understand the scenario on the basis of given data only.
  • Give the reason, if relation cannot be converted in any Particular Normal Form (1st, 2nd, 3rd ).
  • Don’t convert the relation in to 3rd normal form directly. Show each normal form of the relation. 
  • Show the data along with table structure.

 


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 1117

Replies to This Discussion

thnk u very much

Database First(1st) Normal form and repeating groups

Is mei primary key kon si he student id tou bar bar repeat ho ri he or in tables ko koi foreign key b ni interlink kr ri he .Agr student id hi primary key he semester table or specialization table mei to in ko seperate krne kya zrorat he .plz anybody clear this point ..... i m waiting

thanks tariq bhai.............. ap say request hai jo programming k subject (for example cs304) hai un ka solution b jaldi upload kar diya karay..... :-)

are this assigenment solution right i have dout

plz tell me

This is not Clear solution ...... 

i also  think this not right solution

if it is not clear then give clear one.......plz thanx....

tu phir thek kon si he?

ab tu extended day b khtm ho gya he

vu extend date of this assignment check LMS

2nf tak table thek hai but 3nf roung he.

RSS

Latest Activity

Muhammad Faizan Alam liked ・༓☾ Shayna ☽༓・'s profile
17 minutes ago
Muhammad Faizan Alam liked Ellen Shades's profile
18 minutes ago
Muhammad Faizan Alam replied to Muhammad Faizan Alam's discussion CS604 - Operating Systems Assignment NO 1 Due Date: 30-November-2020 in the group CS604 Operating Systems
21 minutes ago
■ T̲h̲e̲ ̲J̲o̲k̲e̲r̲ ■ replied to ■ T̲h̲e̲ ̲J̲o̲k̲e̲r̲ ■'s discussion Why Chat is not working anymore?
29 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS506 Assignment 01 Fall 2020 Solution / Discussion in the group CS506 Web Design and Development
30 minutes ago
Aysha Maqbool replied to +M.Tariq Malik's discussion CS506 Assignment 01 Fall 2020 Solution / Discussion in the group CS506 Web Design and Development
40 minutes ago
Profile IconAysha Maqbool and madi ali joined +M.Tariq Malik's group
40 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
44 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
50 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
51 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
52 minutes ago
++!!Zuni Khan(Am Cyco) posted discussions
59 minutes ago

Looking For Something? Search Here

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.