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

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

 

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

RSS

Latest Activity

Musawar Ahmed replied to +M.Tariq Malik's discussion STA301 GDB Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
52 minutes ago
Musawar Ahmed joined +M.Tariq Malik's group
52 minutes ago
Mr Ak updated their profile
54 minutes ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS610 Assignment No 01 Fall 2020 Solution & Discussion in the group CS610 Computer Network
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group
1 hour ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS605 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS605 Software Engineering-II
1 hour ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS605 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS605 Software Engineering-II
1 hour ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS605 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS605 Software Engineering-II
1 hour ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS605 Assignment No 01 Fall 2020 Solution & Discussion Due Date: 26-11-2020 in the group CS605 Software Engineering-II
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group
1 hour ago
Musawar Ahmed replied to +M.Tariq Malik's discussion CS408 Assignment No 01 Fall 2020 Solution / Discussion in the group CS408 Human Computer Interaction
1 hour ago
Musawar Ahmed joined +M.Tariq Malik's group
1 hour ago

Today Top Members 

Looking For Something? Search Here

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

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

.