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

Looking For Something at Site? Search Below

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: 1118

Replies to This Discussion

any one help us......plz

 me waiting tooo.....

It is just converted into 1NF and 2NF .... it is not possible to convert in into 3NF

special HINT

bro this is not complete hint ... please explain with more detail thank.

REFER LINK FOR UNDERSTAND THE 1NF 2NF 3NF..

.............................

1NF is the most basic of normal forms - each cell in a table must contain only one piece of information, and there can be no duplicate rows.

2NF and 3NF are all about being dependent on the primary key. Recall that a primary key can be made up of multiple columns. As Chris said in his response:

The data depends on the key [1NF], the whole key [2NF] and nothing but the key [3NF] (so help meCodd).

2NF

Say you have a table containing courses that are taken in a certain semester, and you have the following data:

|-----Primary Key----|               uh oh |
V
CourseID
| Semester | #Places | Course Name |
-------------------------------------------------|
IT101
| 2009-1 | 100 | Programming |
IT101
| 2009-2 | 100 | Programming |
IT102
| 2009-1 | 200 | Databases |
IT102
| 2010-1 | 150 | Databases |
IT103
| 2009-2 | 120 | Web Design |

This is not in 2NF, because the fourth column does not rely upon the entire key - but only a part of it. The course name is dependent on the Course's ID, but has nothing to do with which semester it's taken in. Thus, as you can see, we have duplicate information - several rows telling us that IT101 is programming, and IT102 is Databases. So we fix that by putting the course name into another table, where CourseID is the ENTIRE key.

Primary Key |

CourseID
| Course Name |
---------------------------|
IT101
| Programming |
IT102
| Databases |
IT103
| Web Design |

No redundancy!

3NF

Okay, so let's say we also add the name of the teacher of the course, and some details about them, into the RDBMS:

|-----Primary Key----|                           uh oh |
V
Course
| Semester | #Places | TeacherID | TeacherName |
---------------------------------------------------------------|
IT101
| 2009-1 | 100 | 332 | Mr Jones |
IT101
| 2009-2 | 100 | 332 | Mr Jones |
IT102
| 2009-1 | 200 | 495 | Mr Bentley |
IT102
| 2010-1 | 150 | 332 | Mr Jones |
IT103
| 2009-2 | 120 | 242 | Mrs Smith |

Now it should be obvious that TeacherName is dependent on TeacherID - so this is not in 3NF. To fix this, we do much the same as we did in 2NF - take TeacherName out of this table, and put it in its own, which has TeacherID as the key.

 Primary Key |

TeacherID
| TeacherName |
---------------------------|
332 | Mr Jones |
495 | Mr Bentley |
242 | Mrs Smith |

No redundancy!!

One important thing to remember is that if something is not in 1NF, it is not in 2NF or 3NF either. So each additional Normal Form requires everything that the lower ones had, plus some extra conditions, which must all be fulfilled.

 

YE HM NY B NET B ACHI TARAH DEKH LIA HY KUCH AISA SEND KRO JO JUST AP KO PATA HO

how we can give the reason? first we make first normal form then define it or some solution alse. reply plz

Here is the solution

Attachments:

CS614 Assignment#1 Solution Spring 2012

One more idea solution 

see the attached file please

Attachments:

Assignment No. 01
Semester Spring 2012
Data Warehousing-CS614

Due Date: 16/04/2012                                                             Total Marks: 15

 

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

 

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

 

Solution:

To get the first normal form we will remove the multiple attributes without no loss.

 1NF:

Student-ID

Student-Specialization

Student-Name

Specialization- Semester

Semester

Start-Date

Semester

End-Date

Specialization

Supervisor

BC00001

SE

Ali

F08

15-07-08

21-12-08

Prof Khalid

BC00001

AI

Ali

SP09

15-02-09

25-06-09

Prof Ashraf

BC00001

Graphics

Ali

F09

15-07-09

21-12-09

Prof Shaw

Bc00002

AI

Safdar

Sp09

15-02-09

25-06-09

Prof Ashraf

Bc00003

SE

Usman

F08

15-07-08

21-12-08

Prof Khalid

Bc00003

Graphics

Usman

SP09

15-02-09

25-06-09

Prof Shaw

Bc00003

AI

Usman

F09

15-07-09

21-12-09

Prof Ashraf

Bc00004

SE

Naeem

F09

15-07-09

21-12-09

Prof Khalid

Bc00004

AI

Naeem

Sp010

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

 

2NF:

To get the 2NF we will move the redundant to a separate table and also the table should be in 1NF.

 

Student-ID

Student-Specialization

Student-Name

Specialization

Supervisor

BC00001

SE

Ali

Prof Khalid

BC00001

AI

Ali

Prof Ashraf

BC00001

Graphics

Ali

Prof Shaw

Bc00002

AI

Safdar

Prof Ashraf

Bc00003

SE

Usman

Prof Khalid

Bc00003

Graphics

Usman

Prof Shaw

Bc00003

AI

Usman

Prof Ashraf

Bc00004

SE

Naeem

Prof Khalid

Bc00004

AI

Naeem

Prof Ashraf

Bc00005

Graphics

Naveed

Prof Shaw

Bc00006

AI

Zaman

Prof Ashraf

Bc00007

SE

Zeshan

Prof Khalid

 

Semester table:

 

Student-ID

Specialization-

Semester

Semester

Start-Date

Semester

End-Date

BC00001

F08

15-07-08

21-12-08

BC00001

SP09

15-02-09

25-06-09

BC00001

F09

15-07-09

21-12-09

Bc00002

Sp09

15-02-09

25-06-09

Bc00003

F08

15-07-08

21-12-08

Bc00003

SP09

15-02-09

25-06-09

Bc00003

F09

15-07-09

21-12-09

Bc00004

F09

15-07-09

21-12-09

Bc00004

Sp010

15-02-10

25-07-10

Bc00005

Sp010

15-02-10

25-07-10

Bc00006

Sp010

15-02-10

25-07-10

Bc00007

Sp010

15-02-10

25-07-10

 

3NF:

Now we will eliminate the redundant data and also the tables should be in 2NF

Student Table:

Student-ID

Student-Name

BC00001

Ali

BC00002

Safdar

BC00003

Usman

BC00004

Naeem

BC00005

Naveed

BC00006

Zaman

BC00007

Zeshan

 

Specialization Table:

Student-ID

Specialization

Supervisor

Specialization

Supervisor

BC00001

SE

Prof Khalid

BC00001

AI

Prof Ashraf

BC00001

Graphics

Prof Shaw

Bc00002

AI

Prof Ashraf

Bc00003

SE

Prof Khalid

Bc00003

Graphics

Prof Shaw

Bc00003

AI

Prof Ashraf

Bc00004

SE

Prof Khalid

Bc00004

AI

Prof Ashraf

Bc00005

Graphics

Prof Shaw

Bc00006

AI

Prof Ashraf

Bc00007

SE

Prof Khalid

 

Semester Table:

 

Student-ID

Specialization-

Semester

Semester

Start-Date

Semester

End-Date

BC00001

F08

15-07-08

21-12-08

BC00001

SP09

15-02-09

25-06-09

BC00001

F09

15-07-09

21-12-09

Bc00002

Sp09

15-02-09

25-06-09

Bc00003

F08

15-07-08

21-12-08

Bc00003

SP09

15-02-09

25-06-09

Bc00003

F09

15-07-09

21-12-09

Bc00004

F09

15-07-09

21-12-09

Bc00004

Sp010

15-02-10

25-07-10

Bc00005

Sp010

15-02-10

25-07-10

Bc00006

Sp010

15-02-10

25-07-10

Bc00007

Sp010

15-02-10

25-07-10

 

thank u so much sir  

thanks sir

RSS

Latest Activity

+M.Tariq Malik added a discussion to the group MTH643 Introduction to MATLAB
17 seconds ago
lishay updated their profile
4 minutes ago
+++U updated their profile
7 minutes ago
Profile Iconlishay, Natasha shahdeen, Ali Shan and 17 more joined Virtual University of Pakistan
7 minutes ago
+محمد فرقان جالب replied to ++!!Zuni Khan(Am Cyco)'s discussion cs504 assignment No .1 fall 2020 in the group CS504 Software Engineering - I
7 minutes ago
Miss. Churhail replied to Miss. Churhail's discussion ENG506 GDB SOLUTION ????
18 minutes ago
faraz replied to +M.Tariq Malik's discussion STA630 Online Quiz No 01 Fall 2020 Solution / Discussion in the group STA630 Research Methods
29 minutes ago
faraz liked +M.Tariq Malik's discussion STA630 Online Quiz No 01 Fall 2020 Solution / Discussion
32 minutes ago
Honey Bun updated their profile
32 minutes ago
+M.Tariq Malik replied to Rose's discussion CS608 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 28-11-2020 in the group CS608 Software Verification and Validation
43 minutes ago
+M.Tariq Malik replied to Rose's discussion CS608 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 28-11-2020 in the group CS608 Software Verification and Validation
44 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS301 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS301 Data Structures
49 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion ACC501 Business Finance GDB No 01 Fall 2020 Solution / Discussion in the group ACC501 Business Finance
52 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion ACC501 Business Finance GDB No 01 Fall 2020 Solution / Discussion
52 minutes ago
Humaira Khadim added a discussion to the group PSY402 Experimental Psychology
53 minutes ago
Humaira Khadim joined +M.Tariq Malik's group
54 minutes ago

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

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

.