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.vustudents.ning.com

 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

# CS614 FIRST ASSIGNMENT SOLUTION FOR IDEA REQUIRES

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)

Views: 1117

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.

## Latest Activity

Muhammad Faizan Alam liked ･༓☾ Shayna ☽༓･'s profile
17 minutes ago
18 minutes ago
21 minutes ago
29 minutes ago
30 minutes ago
40 minutes ago
Aysha Maqbool and madi ali joined +M.Tariq Malik's group

### CS506 Web Design and Development

40 minutes ago
44 minutes ago
50 minutes ago
51 minutes ago
52 minutes ago
++!!Zuni Khan(Am Cyco) posted discussions
59 minutes ago

1

2

3