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: 1069

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

+M.Tariq Malik replied to Rose's discussion CS608 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 28-11-2020 in the group CS608 Software Verification and Validation
6 minutes ago
+M.Tariq Malik replied to Rose's discussion CS608 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 28-11-2020 in the group CS608 Software Verification and Validation
7 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS301 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS301 Data Structures
12 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion ACC501 Business Finance GDB No 01 Fall 2020 Solution / Discussion in the group ACC501 Business Finance
15 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion ACC501 Business Finance GDB No 01 Fall 2020 Solution / Discussion
15 minutes ago
Humaira Khadim added a discussion to the group PSY402 Experimental Psychology
16 minutes ago
Humaira Khadim joined +M.Tariq Malik's group
17 minutes ago
+M.Tariq Malik added a discussion to the group ACC501 Business Finance
17 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion EDU401 Contemporary Issues and Trends in Education Assignment 01 Fall 2020 Solution / Discussion in the group EDU401 Contemporary Issues and Trends in Education
20 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion EDU401 Contemporary Issues and Trends in Education Assignment 01 Fall 2020 Solution / Discussion
20 minutes ago
+M.Tariq Malik added a discussion to the group EDU401 Contemporary Issues and Trends in Education
20 minutes ago
Profile IconAli Shan, Bushra ilyas, maham and 15 more joined Virtual University of Pakistan
21 minutes ago

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

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

.