Mb0049 fall drive assignment 2012

Explain briefly the life cycle of a project. In life cycle of a project, firstly information is collected from the customer pertaining to the project and the requirements are analyzed.

Mb0049 fall drive assignment 2012

List and explain various Normal Forms. The end result is that redundant data is eliminated, and only data related to the attribute is stored within the table.

First Normal form 1NF: A relation is said to be in 1NF if it has only single valued attributes, neither repeating nor arrays are permitted. Second Normal Form 2NF: A relation is said to be in 2NF if it is in 1NF and every non key attribute is fully functional dependent on the primary key.

Mb0049 fall drive assignment 2012

Third Normal Form 3NF: We say that a relation is in 3NF if it is in 2NF and has no transitive dependencies. A relation is said to be in BCNF if and only if every determinant in the relation is a candidate key.

Fourth Normal Form 4NF: Fifth Normal Form 5NF: A relation is said to be in 5NF if and only if every join dependency in relation is implied by the candidate keys of relation. We say that a relation is in DKNF if it is free of all modification anomalies.

[email protected]

Insertion, Deletion, and update anomalies come under modification anomalies. This means that a row could be uniquely identified by each column individually but that no column depends on any other column to identify the row.

If columns X, Y and Z exist, deleting any two columns will still leave a set of uniquely identifiable rows. BCNF extends 3NF, stating that no non-trivial functional dependencies can exist on anything other than the superkey - that is, a superset of the candidate keys. Typically, 3NF means there are no transitive dependencies.

Contact Us

A transitive dependency is when two columnar relationships imply another relationship. In the table we have defined, though, we still have a 3NF table.

Or if a customer moves?

Mb0049 fall drive assignment 2012

These entry points for error are problematic but acceptable in 3NF because the dependencies are trivial.MB_MBA_Sem2_Fall/August Master of Business Administration - MBA Semester 2 MB – Project Management - 4 Credits Assignment Set- 1 (60 Marks) Note: Each question carries 10 Marks.

MB_MBA_Sem2_Fall/August Master of Business Administration - MBA Semester 2 MB – Productions & Operations Management- 4 Credits.

MB Project Management - [PDF Document]

MB Fall Drive Assignment - Free download as PDF File .pdf), Text File .txt) or read online for free. Scribd is the world's largest social reading and publishing site. Search Search. MB_MBA_Sem2_Fall/August Master of Business Administration - MBA Semester 2 MB – Project Management - 4 Credits Assignment Set- 1 (60 Marks) Note: Each question carries 10 Marks.

MB_MBA_Sem2_Fall/August Master of Business Administration - MBA Semester 2 MB – Project Management - 4 Credits Assignment Set- 1 (60 Marks) Note: Each question carries 10 Marks.

MB Fall Drive Assignment - Free download as PDF File .pdf), Text File .txt) or read online for free.

Project Management MB - [PDF Document]