Wednesday, January 18, 2012
CS403 - Database Management Systems GDB fall 19 January 2011-2012
8:20 PM | Posted by
rameez |
CS403 - Database Management Systems GDB fall 19 January 2011-2012
Solution :
| Total Marks | 5 |
| Starting Date | Wednesday, January 18, 2012 |
| Closing Date | Thursday, January 19, 2012 |
“Normalization Process removes the anomalies from the data but ultimately it affects the Query Performance of DML operations:” why..? Justify the statement.
Guidelines
- Discuss both “Positive and negative effects” (if any)
- Your answer should be precise and should not be greater than 6 lines
- Do not post the answer of GDB topic in MDB
Solution :
This is because the Normalization process removes the anomalies from the data but ultimately it affects the Query performance of operations
Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for corruption or damage.
Negative Affect: It makes the DML query slow because number of joins are involved
Popular Posts
-
[B]Board of Intermediate and Secondary Education, Rawalpindi Board (BISE Rawalpindi) Matric final result 4 August 2011 . All students stay ...
-
Objective: To learn the basics of computing. Instructions: Please read the following instructions carefully before s... -
Board of Intermediate and Secondary Education, Faisalabad Board (BISE Faisalabad) Matric final result 2 August 2011 . All students stay at...
-
Rs. 15,000 prize bond draw list and results 2nd January,2012 check online draw results list of draw result list of Rs. 15,000prize bonds J...
-
Answers Question No.1 (Marks = 10) a) How many combinations of bits are exist when we make a truth table of 9 inputs? 2n are the total c...
-
Lahore, 9th Class Result 2011 of Board of Intermediate and Secondary Education DG khan (BISE DG khan Board) will be announced on August 22...
-
Assignment: # 01 (Spring-2011) Mth101 (Calculus & Analytical Geometry) Lecture: 01 – 09 Total Marks = 30 ...
-
Assignment No.1 Marks:20 “Administrative View of Management” National Community College (NCC) was opened in 1980 in Karachi to provide quali...
-
[B]check online B.A result punjab university 12 August 2011 [/B] for result click here B.A result punjab university 12 August 2011
-
n this competitive world, companies face challenges like technological advancements, volatile market behaviors and ever changing customers’ ...
Blog Archive
-
►
2011
(939)
- ► 12/25 - 01/01 (6)
- ► 12/18 - 12/25 (42)
- ► 11/27 - 12/04 (1)
- ► 11/20 - 11/27 (1)
- ► 11/13 - 11/20 (25)
- ► 11/06 - 11/13 (12)
- ► 10/30 - 11/06 (8)
- ► 10/23 - 10/30 (37)
- ► 10/16 - 10/23 (29)
- ► 10/09 - 10/16 (18)
- ► 10/02 - 10/09 (14)
- ► 09/25 - 10/02 (4)
- ► 09/18 - 09/25 (13)
- ► 09/11 - 09/18 (11)
- ► 09/04 - 09/11 (14)
- ► 08/28 - 09/04 (4)
- ► 08/21 - 08/28 (22)
- ► 08/14 - 08/21 (48)
- ► 08/07 - 08/14 (3)
- ► 07/31 - 08/07 (11)
- ► 07/24 - 07/31 (11)
- ► 07/17 - 07/24 (2)
- ► 07/10 - 07/17 (64)
- ► 07/03 - 07/10 (44)
- ► 06/26 - 07/03 (21)
- ► 06/19 - 06/26 (31)
- ► 06/12 - 06/19 (19)
- ► 06/05 - 06/12 (33)
- ► 05/29 - 06/05 (39)
- ► 05/22 - 05/29 (29)
- ► 05/15 - 05/22 (46)
- ► 05/08 - 05/15 (38)
- ► 05/01 - 05/08 (19)
- ► 04/24 - 05/01 (21)
- ► 04/17 - 04/24 (37)
- ► 04/10 - 04/17 (56)
- ► 04/03 - 04/10 (14)
- ► 03/20 - 03/27 (2)
- ► 03/13 - 03/20 (3)
- ► 02/27 - 03/06 (1)
- ► 02/20 - 02/27 (1)
- ► 02/13 - 02/20 (3)
- ► 01/30 - 02/06 (6)
- ► 01/23 - 01/30 (23)
- ► 01/16 - 01/23 (16)
- ► 01/09 - 01/16 (31)
- ► 01/02 - 01/09 (6)
-
►
2010
(433)
- ► 12/26 - 01/02 (21)
- ► 12/19 - 12/26 (1)
- ► 12/05 - 12/12 (1)
- ► 11/28 - 12/05 (1)
- ► 11/21 - 11/28 (5)
- ► 11/14 - 11/21 (3)
- ► 11/07 - 11/14 (22)
- ► 10/31 - 11/07 (20)
- ► 10/24 - 10/31 (25)
- ► 10/17 - 10/24 (10)
- ► 10/03 - 10/10 (1)
- ► 08/22 - 08/29 (1)
- ► 08/15 - 08/22 (5)
- ► 08/08 - 08/15 (17)
- ► 08/01 - 08/08 (19)
- ► 07/25 - 08/01 (4)
- ► 07/18 - 07/25 (24)
- ► 07/11 - 07/18 (2)
- ► 07/04 - 07/11 (15)
- ► 06/27 - 07/04 (20)
- ► 06/20 - 06/27 (45)
- ► 06/13 - 06/20 (4)
- ► 06/06 - 06/13 (2)
- ► 05/30 - 06/06 (22)
- ► 05/23 - 05/30 (25)
- ► 05/16 - 05/23 (13)
- ► 05/09 - 05/16 (36)
- ► 05/02 - 05/09 (67)
- ► 02/07 - 02/14 (1)
- ► 01/24 - 01/31 (1)
-
►
2009
(1)
- ► 12/20 - 12/27 (1)
Labels
- Aanchal Digest (1)
- ACC501 (3)
- Assignments Spring 2010 (219)
- c201 (1)
- Cricket (1)
- cs (1)
- CS 001 (2)
- cs101 (12)
- cs201 (7)
- cs301 (2)
- cs302 (5)
- cs304 (5)
- cs401 (9)
- cs402 (6)
- cs403 (8)
- cs408 (2)
- cs410 (2)
- cs501 (2)
- cs502 (2)
- cs504 (7)
- cs506 (5)
- cs507 (3)
- cs601 (7)
- cs604 (6)
- cs605 (1)
- cs610 (3)
- cs614 (7)
- cs619 (1)
- Domains and web host (1)
- ECO401 (5)
- ECO403 (1)
- ECO404 (1)
- eng101 (4)
- Eng201 (6)
- eng301 (4)
- fashion (2)
- fin621 (3)
- fin622 (2)
- fin630 (4)
- Hina Digest (1)
- hrm624 (3)
- http://www.blogger.com/img/blank.gif (2)
- ISL201 (4)
- IT430 E-Commerce (5)
- Jasoosi Digest (1)
- Job Ads (4)
- Khawateen Digest (1)
- Kiran Digest (1)
- mcm301 (1)
- mgm (1)
- Mgmt611 (1)
- MGMT623 (1)
- mgmt627 (1)
- mgt101 (8)
- mgt111 (3)
- mgt201 (2)
- mgt211 (7)
- mgt301 (7)
- mgt401 (1)
- mgt402 (5)
- Mgt411 (6)
- mgt501 (4)
- mgt502 (3)
- mgt503 (7)
- Mgt601 (1)
- Mgt602 (1)
- mgt603 (4)
- MGT604 (1)
- mgt610 (1)
- Mgt611 (1)
- mgt613 (4)
- Mgt625 (1)
- Midterm Spring 2010 (48)
- MKT (2)
- Mkt610 (1)
- mkt624 (2)
- mkt630 (1)
- MTH001 (1)
- mth101 (6)
- MTH202 (4)
- mth302 (2)
- Mth401 (1)
- MTH501 (1)
- mth603 (2)
- News (15)
- Pakeezah Digest (1)
- papers (2)
- phy101 (4)
- phy301 (2)
- prize bonds (2)
- Punjab University (1)
- results (49)
- Rida Digest (1)
- Samsung Galaxy (1)
- Shuaa Digest (1)
- sta301 (8)
- sta630 (6)
- Tech (4)
- v (1)
- Virtual University Assignments (4)
- vu projects (4)
Imp Links
Followers
Total Pageviews
Subscribe for email
Blog Archive
-
►
2011
(939)
- ► 12/25 - 01/01 (6)
- ► 12/18 - 12/25 (42)
- ► 11/27 - 12/04 (1)
- ► 11/20 - 11/27 (1)
- ► 11/13 - 11/20 (25)
- ► 11/06 - 11/13 (12)
- ► 10/30 - 11/06 (8)
- ► 10/23 - 10/30 (37)
- ► 10/16 - 10/23 (29)
- ► 10/09 - 10/16 (18)
- ► 10/02 - 10/09 (14)
- ► 09/25 - 10/02 (4)
- ► 09/18 - 09/25 (13)
- ► 09/11 - 09/18 (11)
- ► 09/04 - 09/11 (14)
- ► 08/28 - 09/04 (4)
- ► 08/21 - 08/28 (22)
- ► 08/14 - 08/21 (48)
- ► 08/07 - 08/14 (3)
- ► 07/31 - 08/07 (11)
- ► 07/24 - 07/31 (11)
- ► 07/17 - 07/24 (2)
- ► 07/10 - 07/17 (64)
- ► 07/03 - 07/10 (44)
- ► 06/26 - 07/03 (21)
- ► 06/19 - 06/26 (31)
- ► 06/12 - 06/19 (19)
- ► 06/05 - 06/12 (33)
- ► 05/29 - 06/05 (39)
- ► 05/22 - 05/29 (29)
- ► 05/15 - 05/22 (46)
- ► 05/08 - 05/15 (38)
- ► 05/01 - 05/08 (19)
- ► 04/24 - 05/01 (21)
- ► 04/17 - 04/24 (37)
- ► 04/10 - 04/17 (56)
- ► 04/03 - 04/10 (14)
- ► 03/20 - 03/27 (2)
- ► 03/13 - 03/20 (3)
- ► 02/27 - 03/06 (1)
- ► 02/20 - 02/27 (1)
- ► 02/13 - 02/20 (3)
- ► 01/30 - 02/06 (6)
- ► 01/23 - 01/30 (23)
- ► 01/16 - 01/23 (16)
- ► 01/09 - 01/16 (31)
- ► 01/02 - 01/09 (6)
-
►
2010
(433)
- ► 12/26 - 01/02 (21)
- ► 12/19 - 12/26 (1)
- ► 12/05 - 12/12 (1)
- ► 11/28 - 12/05 (1)
- ► 11/21 - 11/28 (5)
- ► 11/14 - 11/21 (3)
- ► 11/07 - 11/14 (22)
- ► 10/31 - 11/07 (20)
- ► 10/24 - 10/31 (25)
- ► 10/17 - 10/24 (10)
- ► 10/03 - 10/10 (1)
- ► 08/22 - 08/29 (1)
- ► 08/15 - 08/22 (5)
- ► 08/08 - 08/15 (17)
- ► 08/01 - 08/08 (19)
- ► 07/25 - 08/01 (4)
- ► 07/18 - 07/25 (24)
- ► 07/11 - 07/18 (2)
- ► 07/04 - 07/11 (15)
- ► 06/27 - 07/04 (20)
- ► 06/20 - 06/27 (45)
- ► 06/13 - 06/20 (4)
- ► 06/06 - 06/13 (2)
- ► 05/30 - 06/06 (22)
- ► 05/23 - 05/30 (25)
- ► 05/16 - 05/23 (13)
- ► 05/09 - 05/16 (36)
- ► 05/02 - 05/09 (67)
- ► 02/07 - 02/14 (1)
- ► 01/24 - 01/31 (1)
-
►
2009
(1)
- ► 12/20 - 12/27 (1)
Labels
- Aanchal Digest (1)
- ACC501 (3)
- Assignments Spring 2010 (219)
- c201 (1)
- Cricket (1)
- cs (1)
- CS 001 (2)
- cs101 (12)
- cs201 (7)
- cs301 (2)
- cs302 (5)
- cs304 (5)
- cs401 (9)
- cs402 (6)
- cs403 (8)
- cs408 (2)
- cs410 (2)
- cs501 (2)
- cs502 (2)
- cs504 (7)
- cs506 (5)
- cs507 (3)
- cs601 (7)
- cs604 (6)
- cs605 (1)
- cs610 (3)
- cs614 (7)
- cs619 (1)
- Domains and web host (1)
- ECO401 (5)
- ECO403 (1)
- ECO404 (1)
- eng101 (4)
- Eng201 (6)
- eng301 (4)
- fashion (2)
- fin621 (3)
- fin622 (2)
- fin630 (4)
- Hina Digest (1)
- hrm624 (3)
- http://www.blogger.com/img/blank.gif (2)
- ISL201 (4)
- IT430 E-Commerce (5)
- Jasoosi Digest (1)
- Job Ads (4)
- Khawateen Digest (1)
- Kiran Digest (1)
- mcm301 (1)
- mgm (1)
- Mgmt611 (1)
- MGMT623 (1)
- mgmt627 (1)
- mgt101 (8)
- mgt111 (3)
- mgt201 (2)
- mgt211 (7)
- mgt301 (7)
- mgt401 (1)
- mgt402 (5)
- Mgt411 (6)
- mgt501 (4)
- mgt502 (3)
- mgt503 (7)
- Mgt601 (1)
- Mgt602 (1)
- mgt603 (4)
- MGT604 (1)
- mgt610 (1)
- Mgt611 (1)
- mgt613 (4)
- Mgt625 (1)
- Midterm Spring 2010 (48)
- MKT (2)
- Mkt610 (1)
- mkt624 (2)
- mkt630 (1)
- MTH001 (1)
- mth101 (6)
- MTH202 (4)
- mth302 (2)
- Mth401 (1)
- MTH501 (1)
- mth603 (2)
- News (15)
- Pakeezah Digest (1)
- papers (2)
- phy101 (4)
- phy301 (2)
- prize bonds (2)
- Punjab University (1)
- results (49)
- Rida Digest (1)
- Samsung Galaxy (1)
- Shuaa Digest (1)
- sta301 (8)
- sta630 (6)
- Tech (4)
- v (1)
- Virtual University Assignments (4)
- vu projects (4)
Informative Websites
Search