0
so it role is basically to manage the database
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is structural constraints?
Structural constraints are set in place by a system or organization. This is based on rules that are to be followed as directed by the organization.
What is intension in dbms?
In database management system (DBMS), intension refers to the structure or schema of the database. It defines the overall design and organization of the database, including tables, columns, data types, constraints, and relationships. It serves as a blueprint for creating and managing the database.
What is a Multi-user DBMS Architecture?
A Multi-user DBMS Architecture is one big system of users and queries. The use of these are to over look and execute plans safely and does not violate and integrity constraints.
Consistency constraints in dbms?
Consistency constraints in a DBMS ensure that data remains accurate and reliable throughout the database. These constraints can include primary key constraints, foreign key constraints, unique constraints, and domain constraints, all of which help maintain data integrity by enforcing rules that must be followed when inserting or updating data in the database. By upholding consistency constraints, the DBMS helps prevent errors and maintains the overall quality of the data.
What ensures the value of the foreign key matches another tables primary key?
It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS
Describe two alternatives for specifying structural constraints on relationship types?
funny if i know the answer then why i search the answer of this question.
Which statement reflects the structural-functional approach to the issues of gender roles?
Gender roles help maintain social order :)
Mention 3 situations where it is not desirable to use dbms?
For small-scale projects with minimal data storage requirements, using a DBMS may introduce unnecessary complexity and overhead. In scenarios with strict real-time constraints or extreme performance requirements, the additional processing time involved in interacting with a DBMS may not be acceptable. When the data is highly unstructured or varies significantly in format, a DBMS may not be the most efficient or effective storage solution.
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.
What are advantages of rdbms over dbms?
Some advantages of relational database management systems (RDBMS) over traditional database management systems (DBMS) include data integrity through the use of constraints, normalization to reduce redundancy, support for ACID transactions, and standardized SQL language for data manipulation. RDBMS also offer scalability and flexibility for complex data structures and relationships.
What has the author E V Rathnaiah written?
E. V. Rathnaiah has written: 'Structural constraints in tribal education' -- subject(s): Dalits, Education
Major difference between dbms vs rdbms?
A DBMS (Database Management System) is a software that manages databases and provides functionalities to store, retrieve, and update data. An RDBMS (Relational Database Management System) is a type of DBMS that stores data in a structured way using tables with relationships between them. RDBMS enforces the relational model, which allows for data integrity through constraints and supports SQL for querying data.
