0
What else can I help you with?
Explain what is meant by repetition of information and inability to represent information Explain why each of these properties may indicate a bad relational database design?
Repetition of Information is a condition in a relational database where the values of one attribute are determined by the values of another attribute in the same relation, and both values are repeated throughout the relation. This is a bad relational database design because it increases the storage required for the relation and it makes updating the relation more difficult. - Inability to represent information is a condition where a relationship exists among only a proper subset of the attributes in a relation. This is bad relational database design because all the unrelated attributes must be filled with null values otherwise a tuple without the unrelated information cannot be inserted into the relation. Regards, Jose Deleep. S
Difference between database and relational database explain with example?
Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.
What is relational database Explain the purpose of creating database?
A relational database is a type of database that stores and organizes data in tables with a predefined structure. The purpose of creating a database is to efficiently store, manage, and retrieve data for various applications or systems. Databases help to ensure data integrity, enable data sharing, provide a structured way to store information, and support data analysis and reporting.
Which type of data is used to explain a relationship?
A foreign key constraint is used to represent a relationship in a RDBMS (relational database management system).
Explain 2 advantages of a paper based database?
that it is cheap and use eaisly
What is a relational database query and Explain with an example?
A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for many people to understand.For example, a data set containing all the real-estate transactions in a town can be grouped by the year each transaction occurred, the sale price, a buyer's last name and so on. Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."The software used to do this grouping is called a relational database management system (RDBMS). The term "relational database" often refers to this type of software.Relational databases are currently the predominant choice in storing data like financial records, medical records, personal information and manufacturing and logistical data.
Explain two rules in relational model of database systems?
1) Entity Integrity: In a base relation, no attribute of a primary key can be null. 2) Referential Integrity: If foreign key exists in a relation, either foreign key value must match a candidate key value of some tuple in its home relation or foreign key value must be wholly null
Explain the select Operation in Relational Algebra with an example?
Relational Algebra - Example
Explain two advantages of a paper based-database?
it is cheaper an cannot e corrupted by umair obaid cheers
Explain architecture of Distributed Database systems Also explain the reasons for building distributed database systems?
1 Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?
What are the characteristics of database?
chandranana explain the characteristic of database?
How would one explain what an SQL server is?
SQL server, or a Structured Query Languange server, is Microsoft's relational database management system. As a server it provided different needs, like data warehousing and web-enabled databases.
