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 Join Subject Study Groups & Get Helping Material?

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

Views: 501

.

+ 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

belive me mjy is assignent ki kuch smj ni arhi agar kisi ny bana li hy to wo ik br mjy dikha dy my apny style sy wesi bna lo ga please yar koi to share ker dy....
Here is my solution Frndz n tell me if i m wrong plz.....
Attachments:

Electric Toothbrush Models
Manufacturer Model Model Full Name Manufacturer Country
Forte X-Prime Forte X-Prime Italy
Forte Ultraclean Forte Ultraclean Italy
Dent-o-Fresh EZbrush Dent-o-Fresh EZBrush USA
Kobayashi ST-60 Kobayashi ST-60 Japan
Hoch Toothmaster Hoch Toothmaster Germany
Hoch X-Prime Hoch X-Prime Germany

Even if the designer has specified the primary key as {Model Full Name}, the table is not in 2NF. {Manufacturer, Model} is also a
candidate key, and Manufacturer Country is dependent on a proper subset
of it: Manufacturer. To make the design conform to 2NF, it is necessary
to have two tables:

Electric Toothbrush Manufacturers
Manufacturer Manufacturer Country
Forte Italy
Dent-o-Fresh USA
Kobayashi Japan
Hoch Germany

Electric Toothbrush Models
Manufacturer Model Model Full Name
Forte X-Prime Forte X-Prime
Forte Ultraclean Forte Ultraclean
Dent-o-Fresh EZbrush Dent-o-Fresh EZBrush
Kobayashi ST-60 Kobayashi ST-60
Hoch Toothmaster Hoch Toothmaster
Hoch X-Prime Hoch X-Prime
i think ap ak bar mera solution chak kr lo plz kia wo sahi hay

CS403 Database Management Systems

Assignment#3

Mc090409946

Second Normal Form

 Specialization semester Semester start date Semester end date Fall 2009 05-07-09 31-12-09 Spring 2010 05-02-10 30-06-10 Spring 2010 05-02-10 30-06-10 Fall 2009 05-07-09 31-12-09 Spring 2010 05-02-10 30-06-10 Fall 2010 05-07-10 31-12-10 Fall 2010 05-07-10 31-12-10 Spring 2011 05-02-11 30-06-11

 Specialization Specialization supervisor SE Prof. Majid AI Prof. Saeed AI Prof. Saeed SE Prof. Majid Networks Prof. Wajid AI Prof. Saeed SE Prof. Majid AI Prof. Saeed

Third Normal Form

 Specialization Specialization semester Semester start date Semester end date SE Fall 2009 05-07-09 31-12-09 AI Spring 2010 05-02-10 30-06-10 AI Spring 2010 05-02-10 30-06-10 SE Fall 2009 05-07-09 31-12-09 Networks Spring 2010 05-02-10 30-06-10 AI Fall 2010 05-07-10 31-12-10 SE Fall 2010 05-07-10 31-12-10 AI Spring 2011 05-02-11 30-06-11

Attachments:
See the another idea solution file
Attachments:
This is a solution take a quite look on it
Regards.

Modify it before you send.

#include
class House;
class Room
{ public: Room() { };
static void createRoom_v(Room* (&room), House* hse,
char* name) { room = new Room(hse, name);
} Room(House* hse, char* myName)
{ cout"PakistaniCitizens\n";
myHse_p = hse;
if(NULL != myHse_p)
{ name_p = new char(sizeof(strlen(myName)));
name_p = myName;
} else { cout"Please enter the age of the citizen\n";

} };
~Room() { cout"PakistaniCitizens\n";
myHse_p = NULL;
delete (name_p);
};
void disp() { cout name_p;
cout"\n";
} static void initList_v(Room *(& roomsList_p)[3])
{ roomsList_p[3] = new Room[3];
} private: House * myHse_p;
char * name_p;};
class House{ public: House(char *myName) { cout"PakistaniCitizens\n";
name_p = new char(sizeof(strlen(myName)));;
name_p = myName;
Room::initList_v(roomsList_p);
Room* myRoom;
Room::createRoom_v(myRoom, this, "name");
roomsList_p[0] = myRoom;
Room::createRoom_v(myRoom, this, "age");
roomsList_p[1] = myRoom;
Room::createRoom_v(myRoom, this, "CNIC No");
roomsList_p[2] = myRoom;
} ~House() { cout"PakistaniCitizens\n";
unsigned int i;
cout"Eligible for vote cast...\n";
for(i=0; i<3; ++i) {
if(roomsList_p[i] != NULL)
{ delete (roomsList_p[i]);

} }

delete [] roomsList_p;
delete (name_p);
} void disp()
{ cout"\n\nPakistaniCitizens :"name_p;
if(roomsList_p != NULL) { unsigned int i;
cout"\n\nVotersList...\n";
for(i=0; i<3; ++i) { if(NULL != roomsList_p[i])
{ roomsList_p[i]->disp();
} } cout"\n\n"; } } private:
char* name_p;
Room* roomsList_p[3];};
int main(){ cout"\nExample of Composition Relationship\n";
cout"-----------------------------------------\n\n";
House hse("data members");
cout"\n\nPakistaniCitizens...\n";
hse.disp();
cout"Age is less than 18...\n";
return(0);

## Latest Activity

M +S +K posted a status
"Zaroori Toh Nahi Jo Khushi Dey Ussi Se Mohabbat Ho, Pyar Toh Akser Dil Torne Walon Se Bhi Ho Jaata Hai"
52 seconds ago
M +S +K posted a status
"Tum Aik Shayar Ki Mohabbat Ho Jaana, Zinda Rahogi Hemesha Lafzon Mein"
7 minutes ago
M +S +K posted a status
"Kabhi Parh Toh Sahee Meri Aankhon ko, Yahan Samundar Behta Hai Teri Mohabbat Ka"
9 minutes ago
Zain Kazimi posted discussions
9 minutes ago
Zain Kazimi liked Zain Kazimi's discussion Self Poetry
10 minutes ago
M +S +K posted a status
"Usne Apni Aankhon Se Tableegh Hee Yun Ki, Main Bina Soche Mohabbat Pe Iman Le Aaya"
12 minutes ago
M +S +K posted a status
"Mohabbat Azmani Ho Toh Bus Itna Hee Kaafi Hai, Zara Sa Ruth Kar Dekho Manane Kaun Aata Hai"
13 minutes ago
M +S +K posted a status
"Yeh Ishq, Mohabbat, Pyaar Nahi Maloom Kya Hai, Per Humein Jo Tumse Hai Woh In Sab Se Bhi Judaa Hai"
15 minutes ago

1

2

3