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

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

# CS403 Assignment#03 Solution & Discussion Due Date:03-01-2011

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:

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 become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

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

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)

Attachments:

### Replies to This Discussion

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

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

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)

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

## Latest Activity

+++STUDENT+++ liked Azhar Sagar's discussion Learn complete HTML IN 40 Minutes
18 seconds ago
+++STUDENT+++ posted discussions
3 minutes ago
+ "AS" replied to + "AS"'s discussion Neelam Mat Karna ...
4 minutes ago
+ ! Ryan replied to + "AS"'s discussion Neelam Mat Karna ...
10 minutes ago
+ ! Ryan replied to + "AS"'s discussion Neelam Mat Karna ...
11 minutes ago
Azhar Sagar posted a discussion

### Learn complete HTML IN 40 Minutes

16 minutes ago
+ M.Tariq Malik liked + "AS"'s discussion Neelam Mat Karna ...
33 minutes ago
+ M.Tariq Malik liked + Adeeena's discussion har shakhas muhabt krta hae !!!
33 minutes ago
38 minutes ago
+ "AS" liked + "AS"'s discussion Neelam Mat Karna ...
39 minutes ago
+ "AS" posted discussions
39 minutes ago
+ M.Tariq Malik liked + Adeeena's discussion sometimes......
40 minutes ago
Usama Rao is now a member of Virtual University of Pakistan
41 minutes ago
+ "AS" liked + "AS"'s discussion Zabt Sabhi ...
47 minutes ago
+ "AS" liked + "AS"'s discussion Jo Ghair Thy..
53 minutes ago
+ ! Ryan replied to + "Jɨyą's discussion me esi hon...!
1 hour ago
2 hours ago
2 hours ago
2 hours ago
2 hours ago

1

2

3