0
Add your answer:
Earn +20 pts
Examples of functional dependency in dbms?
a functionaly dependency is an association between two relational attribute of same relational database.one of the attribute is known as determinant and the other one is determined.for the each value of determinant there is only one value associated of determined. graphicaly it can be represented A----->B .
What is non trivial functional dependency?
-->non trivial functional dependency is totally opposite to the trivial functional dependency. --> non trivial dependency means X-->Y that is if Y is not proper subset of X table or relation with X then it said to be non trivial functional dependency.
If there is partial quotient then there must be partial product. If there is partial product, how do you do it?
Someone pls answer this question
What is partial proportion?
partial proportion is equal
What is partial sum method?
what is the meaning for partial sums
Describe the purpose of normalizing data and also list out the dependencies involved in the process of normalization?
The purpose of normalizing data in DBMS is to reduce the data redundancy and increase the consistency of data. a) Partial dependency: non-prime attribute ( field) depends on other non-prime attributes b) Functional dependency c) Transitive dependency
Solved examples of normalization in DBMS?
solved examples of normalization
Describe database normalization?
Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency
Difference between partial dependency and fully functional dependency?
The difference is that partial dependency is when a database's attribute is only partially dependent on the primary key. Fully functional dependency is when the attribute is entirely dependent on the key.
Describe the dependency diagram and explain its purpose?
A dependency diagram is a visual representation of a dependency graph. Dependency diagrams are integral to software development, outlining the complex, interrelationships of various functional elements. Typically in a dependency diagram, arrows point from each module to other modules which they are dependent upon.The dependency diagram is used as an aid to normalization within database design.
What do you understand by Normalization?
Normalization is the process of organizing data in a database to reduce redundancy and dependency by dividing larger tables into smaller ones and defining relationships between them. It ensures data integrity and avoids anomalies like update, insert, or delete anomalies. Normalization is essential for efficient database design and maintenance.
What is the basic terminology of dbms?
Acid cursor data database field primary & foreign keys procedure & function odbc & oledb normalization trigger
What is functional dependency in DBMS?
A key is a set of attributes that uniquely identifies an entire tuple, a function dependency allow us to express constraints that uniquely identify the values of certain attribute.
Difference between rdbms and dbms?
dbms stands for data base management system whereas rdbms is relational data base management system. A Database Management System (DBMS) is collection of software programs which enable large, structured sets of data to be stored, modified, extracted and manipulated in different ways. Whereas Relational Database Managemet System (RDBMS) is a data structured in database tables, fields and records. Each RDBMS tables consist of database table rows.
What is normalization in DBMS?
Normalisation means make table very effective and usable means make table atomic ,unique primary key,not redundancy etc.
What is Partial functional dependency?
Partial Functional Dependency Indicates that if A and B are attributes of a table , B is partially dependent on A if there is some attribute that can be removed from A and yet the dependency still holds. Say for Ex, consider the following functional dependency that exists in the Tbl_Staff table: StaffID,Name -------> BranchID BranchID is functionally dependent on a subset of A (StaffID,Name), namely StaffID. Source :http://www.mahipalreddy.com/dbdesign/dbqa.htm
Find out functional dependencies?
A constraint between two sets of attributes is known as functional dependency in relational database. Determination of functional dependencies is vital in database denormalization, normalization and relational model.
