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..

 

+ Click Here To Join also Our facebook study Group.

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

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


See Your Saved Posts Timeline

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)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

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

Student ID

Name

Vu001

Faizan

Vu001

Faizan

Vu002

Zafar

Vu003

Ahmad

Vu003

Ahmad

Vu003

Ahmad

Vu004

Fahad

Vu004

Fahad

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

RSS

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

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

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