0
First Normal Form: Remove the repeating groups in a table
Second Normal Form: Remove partial dependencies
Third Normal Form: Remove transitive depedencies
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How many types of normal forms in DBMS?
total 6 normal forms
What is bcnf explain with respect to dbms?
Boyce -Codd normal form which is one of the forms of dbms noramlizations.normalization is converting the relations or tables in a standard form.bcnf is based on functional dependencies that take into account all candidate keys.a relation is in bcnf if every determinant has a candidate key..:)
Explain the link between hardware and application software?
DBMS
What is minimal normal form a relation must satisfy in dbms?
Third normal form.
Explain the centralized DBMS architecture in detail?
combines everything into a single system including, DBMS software,hardware, application programs and user interface
Draw a neat diagram of components of DBMS and explain?
errjklerjqlwrjqwewqerlkwrlqewlrkqwerqewrqwklrjqweklodo tari ma no chodu
Explain the types of dbms users?
There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
Why DBMS are important in your information based society?
DBMS (Database Management Systems) are important in an information-based society because they provide a structured way to store, manage, and retrieve data efficiently. They help in organizing and maintaining large volumes of data, ensuring data consistency and integrity, and enabling quick access to pertinent information. DBMS also support data sharing and collaboration among users, leading to enhanced decision-making processes and overall business performance.
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
Construct system architecture of DBMS . explain each component in detail?
a representation of DBMS design. It helps to design, develop, implement, and maintain the database management system. A DBMS architecture allows dividing the database system into individual components that can be independently modified, changed, replaced, and
Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?
Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?
