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

 

+ How to Follow the New Added Discussions at Your Mail Address?

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

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

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


See Your Saved Posts Timeline

Views: 513

.

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

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

Mehboob Ali Cheema left a comment for areeba khan
26 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment No 01 Fall 2019 Solution & Discussion in the group MGT301 Principles of Marketing
1 hour ago
Profile IconPreçîõûš and Fari Malik joined + M.Tariq Malik's group
1 hour ago
Preçîõûš joined + M.Tariq Malik's group
1 hour ago
Preçîõûš joined + M.Tariq Malik's group
1 hour ago
Preçîõûš joined + M.Tariq Malik's group
1 hour ago
Preçîõûš replied to +¢αяєℓєѕѕ gιяℓ's discussion CS408 - Human Computer Interaction Assignment No.1 Semester: Fall 2019 in the group CS408 Human Computer Interaction
1 hour ago
Preçîõûš replied to +¢αяєℓєѕѕ gιяℓ's discussion CS408 - Human Computer Interaction Assignment No.1 Semester: Fall 2019 in the group CS408 Human Computer Interaction
1 hour ago
Preçîõûš replied to +¢αяєℓєѕѕ gιяℓ's discussion CS408 - Human Computer Interaction Assignment No.1 Semester: Fall 2019 in the group CS408 Human Computer Interaction
1 hour ago
Preçîõûš joined + M.Tariq Malik's group
1 hour ago
Nissa commented on + M.Tariq Malik's group EDU430 ICT in Education
2 hours ago
Fahad liked + M.Tariq Malik's group CS206 Introduction to Network Design & Analysis
2 hours ago
Fahad liked + M.Tariq Malik's group CS205 Information Security
2 hours ago
Fahad joined + M.Tariq Malik's group
2 hours ago
Fahad joined + M.Tariq Malik's group
2 hours ago

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

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