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

Looking For Something at Site? Search Below

# 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: 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 |                                           VCourseID|  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 |                                                       VCourse  |  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

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

## Latest Activity

+M.Tariq Malik added a discussion to the group MTH643 Introduction to MATLAB

### MTH643 Introduction to MATLAB Assignment 01 Fall 2020 Solution / Discussion Due Date: 07-12-2020

17 seconds ago
lishay updated their profile
4 minutes ago
+++U updated their profile
7 minutes ago
lishay, Natasha shahdeen, Ali Shan and 17 more joined Virtual University of Pakistan
7 minutes ago
7 minutes ago
18 minutes ago
29 minutes ago
32 minutes ago
Honey Bun updated their profile
32 minutes ago
43 minutes ago
44 minutes ago
49 minutes ago
52 minutes ago
52 minutes ago