First Normal Form: Remove the repeating groups in a table
Second Normal Form: Remove partial dependencies
Third Normal Form: Remove transitive depedencies
total 6 normal forms
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..:)
DBMS
Third normal form.
combines everything into a single system including, DBMS software,hardware, application programs and user interface
errjklerjqlwrjqwewqerlkwrlqewlrkqwerqewrqwklrjqweklodo tari ma no chodu
There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
Physical schema,logical schema and sub schemas
functions of DBA in DBMS
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?
Data is represented/organized in a dbms in the form of Schemas, tables, rows and columns One DBMS may have multiple Schemas One Schema may have multiple tables One table may have multiple rows One row may have multiple columns If these tables are related to one another it forms a RDBMS - A Relational DBMS