Relational Model 28 Jun,2023 boomtecho2@gmail.com6 Comments Please enter your email: 1. Q1.What is Relational Model ? Represents how data is stored in Relational Databases a collection of tables an approach to managing data using a structure and language consistent with first-order predicate logic All of the Above 2. What is tuple? It is related set of record in table It corresponds to a row in table It is another name of third normal form It is the Attribute for each relation and the governing constraint 3. Q3. Tables with rows and columns can be viewed as ___. Analytical Models Composite Model Relational Model Database Model 4. Q4.What is a row in a table also known as? Tuple Name Attribute None 5. Q5. What column in a table is contained? Tuple Name Attribute Both B and C 6. Q6. In ___, columns in a particular table are listed by their names. Domain Instance Schema Attribute 7. Q7.___ should be there in each attribute. Keys Schema instance Domain 8. Q8. How Many’s no of Codd rules 10 12 13 11 9. Q9. How many properties of relations are there? 4 5 6 7 10. Q10. Which of the following is among the 12 Codd’s Rules? View Updating Rule Relational Level Operation Rule Distribution Independence Rule None of the Above 11. Q11. Which of the following is TRUE about Information Rule in the 12 Codd’s Rules? The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database. Null values are treated in database records according to this rule. Database systems must update all views tables on a regular basis. Databases contain a wide variety of information, and each row and column of each table must hold this information. 12. Q12.What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd’s Rules? Unknown Data Inappropriate Information No value in Cell All of the Above 13. Q13. Who one Proposed Codd Rules Dr. Edgar F. codd E.R Codd Dr John Codd Both A and B 14. Q14. In Which year was codd rules are proposed? 1985 1986 1999 1987 15. Q15. name of rule 3_ Systematic treatment of null value Information rule view updating rules foundation rule 16. Q16. View updating Rules _ The system must support at least one relational language that All views those can be updated theoretically, must be updated by the system. The system must support set-at-a-time insert, update, and delete operators. None of the Above 17. Q17. THe Logical data Independence It indicates that any modifications made at the logical level (or the table structures) should not have an impact on the user’s experience (application) Changes to the logical level (tables, columns, rows, and so on) must not require a change to an application based on the structure. Both A and B None of the Above 18. Q18. The None Subversion Rule_ If a system uses a low-level or different language to access the DB system other than SQL, it should not bypass or subvert data integrity. All the entered values must not be changed, and the integrity of the data should not be reliant on any external component or application. Changes to the logical level (tables, columns, rows, and so on) must not require a change to an application based on the structure. none of the Above 19. Q19.What is Integrity Independence? Integrity constraints must be specified separately from application programs and stored in the catalog. here never defined structure of relation All enter value must be changed none of the above 20. Q20 . What is constraint ? we have to define some conditions that must hold for the data present in a database. In DBMS, constraints refer to limitations placed on data or data processes. This indicates that only a particular type of data may be entered into the database Both A and B None of the Above Loading …
Test
Thanx Dear For attending.
this is my test of Ef codd
thanx dear Iram
My codd rules test…
My codd rules test…