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.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

# Assignment 1 of cs712 hase been uploaded and the due date is 23-11-2015

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

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

## Latest Activity

52 minutes ago
Musawar Ahmed joined +M.Tariq Malik's group

### STA301 Statistics and Probability

52 minutes ago
Mr Ak updated their profile
54 minutes ago
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group

### CS610 Computer Network

1 hour ago
1 hour ago
1 hour ago
1 hour ago
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group

### CS605 Software Engineering-II

1 hour ago
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group

1 hour ago

1

2

3

## Looking For Something? Search Here

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

.