A child relationship refers to an entity or table that cannot exist without the existence of another entity or table. An example of this would be a table that is created to address a many-to-many relationship between two other tables.
DBMS
combines everything into a single system including, DBMS software,hardware, application programs and user interface
data dictionary
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.
the architecture of dbms contains three levels 1/ external level:different users views of the database,shows relevant data for a particular user. 2/conceptual level:global view pf the database;describes what data is stored and its relationships. 3/internal level:physical representation of the database on the computer, Describes how the data is stored in the database.
Physical schema,logical schema and sub schemas
network model is a collection data in which records are physically linked through linked lists .A DBMS is said to be a Network DBMS if the relationships among data in the database are of type many-to-many. The relationships among many-to-many appears in the form of a network. Thus the structure of a network database is extremely complicated because of these many-to-many relationships in which one record can be used as a key of the entire database. A network database is structured in the form of a graph that is also a data structure .
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?
explain how good working relationships can be developed with team members