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

Looking For Something at Site? Search Below

# 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

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

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.

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?

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

5 hours ago
5 hours ago
5 hours ago
Kamal Qaisar posted discussions
5 hours ago
7 hours ago
Samina, sahara, Jero and 12 more joined Virtual University of Pakistan
7 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago
7 hours ago
Aasma kiran joined +M.Tariq Malik's group

7 hours ago
7 hours ago
7 hours ago
8 hours ago

1

2

3

4