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

Assignment 1

 

Instructions to Solve Assignments

 

The purpose of the assignments is to give you hands on practice. It is expected that students will solve the assignments by themselves. Following rules will apply during the evaluation of the assignment.

 

  • Cheating from any source will result in zero marks in the assignment.
    • Any student found cheating in any two of the assignments submitted during the course will be awarded "F" grade in the course.
    • No assignment after due date will be accepted.

 

Answer the following questions in your own words. Plagiarism will be checked for each question. Marks will be awarded on the basis of answer and plagiarism report.

 

Q.1

a) Consider the following information. Is the given table is in Boyce Codd normal form? If your answer is yes, justify that otherwise give argument to prove that the given table is not in Boyce Codd Normal Form.

 

Manager

Project

Branch

Ali

abc

Lahore

Usman

abc

Lahore

Ali

qpr

Karachi

Shoaib

qpr

Karachi

 

b) What is the difference between third normal form and fourth normal form?

c) Explain limitations of normalization.                                                                15                                                  

 

 

 

Q.2

Draw an ER diagram for the following information:

 

There is an insurance company. Suppose that following are the requirements that were collected:

An insurance company has different policies. Policies have policy_no, term_price and coverage.

Policies are categorized based on their types. There are two types: Auto_policy and Home_policy.

Policies for vehicles come under Auto policy. Auto_policy has policy_no, vehicle type and issue date.

Policies for house come under home policy.Home_policy has policy_no, issue date and term_price.Customers take policies policy through policy agent. A customer can take only one policy.

a)      Identify the key attributes in the given problem and show their relationship.

b)      How many tables are required in the given scenario?                                         20

                                                                                    

 

 

 

 

 

Q.3 Read the paper entitled “

 Concurrency Control in Distributed Database System” and answer the following questions

 

a)      Briefly discuss under what conditions it is more suitable to prefer distributed database approach rather than centralized approach.

b)      In which algorithm time stamps are associated with the each transaction?                                                        

                                                                                                                     10+ 5

 

Link:  http://www.ijarcsse.com/docs/papers/Volume_3/7_July2013/V3I7-0526.pdf

 


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


Views: 1070

Attachments:

Replies to This Discussion

Yes, i think first assignment can be easily solved from Normalization concepts. Simple and easy. let us discuss.

Comment your observations and suggestion about this assignment.

a) Consider the following information. Is the given table is in Boyce Codd normal form? If your answer is yes, justify that otherwise give argument to prove that the given table is not in Boyce Codd Normal Form. Manager Project Branch Ali abc Lahore Usman abc Lahore Ali qpr Karachi Shoaib qpr Karachi

What is this?

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

Question 1 (a):

NOT in BCNF

Kashif Bhai! Please upload the solution if u have done or some useful hints regarding each question. thanks

5 tables

Policy, Home_Policy, Auto_Policy, Customer, Policy_Agent

Domain Key Normal Form DKNF.

thanks for sharing 

Teacher remarks for the students.

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

RSS

Latest Activity

Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar posted discussions
5 hours ago
+M.Tariq Malik replied to Fragrance of Islam's discussion ENG301 Business Communication GDB No 01 Fall 2020 Solution / Discussion in the group ENG301 Business Communication
7 hours ago
Profile IconSamina, sahara, Jero and 12 more joined Virtual University of Pakistan
7 hours ago
+!!! ❤️ Shadow Girl❤️!!! replied to Miss. Churhail's discussion $$$$$AB YE SOCHA HY K HAM HAD SE GUZAR JAYEN GY$$$$$$
7 hours ago
maha replied to +M.Tariq Malik's discussion Mid Term Quiz Will Be Conducted Instead Of Mid Term Examinations - Fall 2020 Semester
7 hours ago
+!!! ❤️ Shadow Girl❤️!!! liked Miss. Churhail's discussion $$$$$AB YE SOCHA HY K HAM HAD SE GUZAR JAYEN GY$$$$$$
7 hours ago
maha replied to +M.Tariq Malik's discussion Mid Term Quiz Will Be Conducted Instead Of Mid Term Examinations - Fall 2020 Semester
7 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion FIN630 GDB No 01 Fall 2020 Solution / Discussion Last Date: 27-11-2020 in the group FIN630 Investment Analysis & Portfolio Management
7 hours ago
Aasma kiran commented on +M.Tariq Malik's group ENG301 Business Communication
7 hours ago
Aasma kiran joined +M.Tariq Malik's group
7 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
7 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
7 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
8 hours ago

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

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

.