We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

Assignment No. 03
Semester Fall2010
Database Management Systems-CS403

 

Total Marks: 15

 

Due Date: 03/01/2011

 

Objective:

To learn and understand basic concepts of Normalization.

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit (zero marks) if:

 

o        The assignment is submitted after due date.

o        The submitted assignment does not open or file corrupt.

o        The submitted assignment is in the format other than MS Word (doc).

o        The assignment is copied (from other student or copy from handouts).

o        Student ID is not mentioned in the assignment File or name of file is other than student ID.

 

For any query about the assignment, contact at cs403@vu.edu.pk

 

GOOD LUCK

 

 

 

Q 1: Normalize the below table up to 3rd normal form.(7.5+7.5)

 

 

 

 

Student-ID

Specialization

Name

Specialization Semester

Semester

Start-Date

Semester

End-Date

Specialization

Supervisor

Vu001

SE

Faizan

Fall2009

05-07-09

31-12-09

Prof Majid

Vu001

AI

Faizan

Spring2010

05-02-10

30-06-10

Prof Saeed

Vu002

AI

Zafar

Spring2010

05-02-10

30-06-10

Prof Saeed

Vu003

SE

Ahmad

Fall2009

05-07-09

31-12-09

Prof Majid

Vu003

Networks

Ahmad

Spring2010

05-02-10

30-06-10

Prof Wajid

Vu003

AI

Ahmad

Fall2010

05-07-10

31-12-10

Prof Saeed

Vu004

SE

Fahad

Fall2010

05-07-10

31-12-10

Prof Majid

Vu004

AI

Fahad

Spring2011

05-02-11

30-06-11

Prof Saeed

 

 

 

 

 

Guidelines / Instructions

 

  • Understand the scenario on the basis of given data only.
  • The relation is already in 1st normal form and has composite Primary Key.
  • Don’t convert the relation in to 3rd normal form directly. 
  • Show each step. (First 2nd normal form then 3rd normal form).

 

 

“Try to upload the assignment before BONUS day”

 

 

 

 

                                                                                                                           

 

For complete assignment.Please see attached file..

 

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 504

.

+ 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)

Attachments:

Replies to This Discussion

Please Discuss Here about this assignment. Thanks

plz yaar koi upload karo assignment ka solution....tension ho gai hey

 

                                                                        Cs403

      Assignment solution data

Make the file complete by using these headings

Best of luck

Q1 (Answer)

Feasibility report including these headings, you can explain by yourself just focus on headings.

1- Title (where you show subject, and your name)

2- contents

3- Introduction

(now start the report)

date

your name

4- Criteria

5- Method of obtaining facts

4- Overview of alternatives

5- Evaluation

6- Conclusions

7- Recommendations

(you just make a story after read the Q1, and write here)

Q-2

To answer the reader typical questions about empirical research report, writer use a substructure that has the following elements.

1- Introduction (Why is your research important to us)

2- Objectives of research(What were you trying to find out)

3- Methods Results(Was your research method sound

4- Discussion(What results did your research produce)

5- Conclusions(How do you interpet your research)

6- Recommendation(What do you think we should do)

 

 See the attached file please..

Attachments:

tariq bhai ye kis assignment ka solution hey...mera khiyal hey ye cs403 ka nahi hey

 

This is not the sure solution...only i want to discuss about my solution if u find me wrong please inform me...!!
to convert to 2NF make 3 tables following dependencies as
1. (Student-ID, Specialization) -> (Specialization Semester, Semester Start-Date, Semester End-Date)
2.(Student-ID) -> Name
3.(Specialization) -> Specialization Supervisor

To make 3NF remove transitive dependency from the table "1"

i.e Specialization -> specialization semester -> start date , End date

and make them in seprate tables.

 

MR.Hassan  i thik it is the best solution i also creat the solution as it is
hina yaar apna solution upload kar k share karwa do plz
my solution of cs403
mmmmmmmmmm
Attachments:
aap logon k result ka kaya bana????

@hinaa....thanks...!!
@silence....is se simple solution kya hai???
just jis tarha likha hai us ko table bana lo bas
:)

ok hassan i will try

RSS

Latest Activity

+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked + !! SARAH's discussion Beauty Of Fear !!
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to + Iuuoɔǝut+'s discussion mard ka dil...
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked + Iuuoɔǝut+'s discussion mard ka dil...
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked Whispering Soul's discussion شاہی جوڑے کی رکشہ میں آمد
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to +++LEARNER+++'s discussion Naseeb
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked +++LEARNER+++'s discussion Naseeb
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ Intel replied to + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ Intel liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion Twaja farmaen
1 hour ago
+ Iuuoɔǝut+ liked + Iuuoɔǝut+'s discussion Internship Report on IBF Meezan Bank Pakistan
1 hour ago
+ Iuuoɔǝut+ posted discussions
1 hour ago
+ M.Tariq Malik left a comment for ghulam hussain
1 hour ago
+ M.Tariq Malik liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ Iuuoɔǝut+ liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ !! ATHER replied to + !! SARAH's discussion Beauty Of Fear !!
2 hours ago
+ M.Tariq Malik liked 2.O's discussion Difference B/w Null and Undefined (Only Devs can understand) :P :P
2 hours ago

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

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